How to pass data from one Api Controller to another Api controller?

Demo Cloud

Hello Sir,

I'm trying to pass the data from Multi_DB_LoginController : ApiController to Multiple_SelectController : ApiController.

From Multi_DB_LoginController : ApiController I wanted to pass the selected database i-e connStr to Multiple_SelectController : ApiController and all the apicontrollers present in the project. Using these Web Api's to connect Mobile App to the database.

Please help me.

Thank you and Regards.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
you can also create a class to change connection dynamically as per user selection.
public class Connection {
        public string ConfigurnewConnectionString(string server, string database, string userid, string password, string ConnectionString) {
            System.Configuration.Configuration Config1 = WebConfigurationManager.OpenWebConfiguration("~");
            ConnectionStringsSection conSetting = (ConnectionStringsSection) Config1.GetSection("connectionStrings");
            conSetting.ConnectionStrings[ConnectionString].ConnectionString = conSetting.ConnectionStrings[ConnectionString].ConnectionString.ToString().Replace("{0}", server);
            conSetting.ConnectionStrings[ConnectionString].ConnectionString = conSetting.ConnectionStrings[ConnectionString].ConnectionString.ToString().Replace("{1}", database);
            conSetting.ConnectionStrings[ConnectionString].ConnectionString = conSetting.ConnectionStrings[ConnectionString].ConnectionString.ToString().Replace("{2}", userid);
            conSetting.ConnectionStrings[ConnectionString].ConnectionString = conSetting.ConnectionStrings[ConnectionString].ConnectionString.ToString().Replace("{3}", password);
            return conSetting.ConnectionStrings[ConnectionString].ConnectionString;
        }
    }


// in your user selection

if (obj.DatabaseName == "PersonDatabase") {
            ConStr = objConnection.ConfigurnewConnectionString(obj.Servername, obj.DatabaseName, obj.UserId, obj.Password, "PersonDatabaseEntities").ToString();
        } else if (obj.DatabaseName == "EmployeeDatabase") {
            ConStr = objConnection.ConfigurnewConnectionString(obj.Servername, obj.DatabaseName, obj.UserId, obj.Password, "EmployeeDatabaseEntities").ToString();
        }
+1
Sachin Singh5y ago
after going through your code, i can understand that you want to store client selection (database) so that you can pick right connection string in web api,
Though it is not right solution but you can use Session in web api , to use session in web api in your global.asax (MVC) file add below lines of code
public override void Init()
{
    this.PostAuthenticateRequest += MvcApplication_PostAuthenticateRequest;
    base.Init();
}

void MvcApplication_PostAuthenticateRequest(object sender, EventArgs e)
{
    System.Web.HttpContext.Current.SetSessionStateBehavior(
        SessionStateBehavior.Required);
}
Now you can use Session to store Client Selection in web api.
+1
Demo Cloud5y ago
Hello,

Im using these Api controllers to connect the database with the mobile app.
Please help. I've also attached the code for the controllers where i'm trying topass the selected database from on APi controller to another.
Thanks
+1
Sachin Singh5y ago
create a common base class and use with different controllers
public abstract class MyBaseController:ApiController
{
    public void CommonMethod()
    {
        // Do something here
    }
}

then use them like

public class ControllerA : MyBaseController
{
    public void MethodA()
    {
        base.CommonMethod();

        // Do something else
    }
}

public class ControllerB : MyBaseController
{
    public void MethodB()
    {
        base.CommonMethod();

        // Do Something else
    }
}
+1