public ActionResult ConnectedappView()
{
string mycon;
mycon = "server=localhost;port=3306;database=esignapp;user=root;password=sql123";
con = new MySql.Data.MySqlClient.MySqlConnection();
con.ConnectionString = mycon;
con.Open();
ConnectedappViewModel ObjModel = new ConnectedappViewModel();
ObjModel.UserList = new List <UserList>();
string lstdata = "select Id,FirstName from tbl_user where IsActive = 1";
MySql.Data.MySqlClient.MySqlCommand cmd1 = new MySql.Data.MySqlClient.MySqlCommand(lstdata, con);
MySqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
ObjModel.UserList.Add(new UserList
{
FirstName = reader["FirstName"].ToString(),
Id = Convert.ToInt32(reader["Id"].ToString())
});
}
ObjModel.lstUser = new SelectList(ObjModel.UserList, "Id", "FirstName");
con.Close();
return(View(ObjModel));
}
public ActionResult SubmitConnectedapp(ConnectedappViewModel ObjModel)
{
if (ModelState.IsValid)
{
string mycon;
mycon = "server=localhost;port=3306;database=esignapp;user=root;password=sql123";
con = new MySql.Data.MySqlClient.MySqlConnection();
con.ConnectionString = mycon;
con.Open();
string TokenKey = RandomString(10);
string InsertStatement = "Insert into tbl_connectedapp (AppName, IntegrationKey,userid ) values ('" + ObjModel.AppName + "','" + TokenKey + "','" + ObjModel.UserID + "')";
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(InsertStatement, con);
MySqlDataReader Reader = cmd.ExecuteReader();
con.Close();
long UserID = cmd.LastInsertedId;
con.Open();
//DateTime CurrentDate = DateTime.Now.Date;
//string InsertTokenStatement = "Insert into tbl_tokenmanager (Tokenkey,Userid) values ('" + TokenKey + "','" + Convert.ToInt32(UserID) + "')";
//MySql.Data.MySqlClient.MySqlCommand cmd1 = new MySql.Data.MySqlClient.MySqlCommand(InsertTokenStatement, con);
//MySqlDataReader Reader1 = cmd1.ExecuteReader();
con.Close();
}
return(RedirectToAction("ConnectedAppGrid", "Home"));
}
public ActionResult ConnectedAppGrid()
{
string mycon;
mycon = "server=localhost;port=3306;database=esignapp;user=root;password=sql123";
con = new MySql.Data.MySqlClient.MySqlConnection();
con.ConnectionString = mycon;
con.Open();
ConnectedappViewModel ObjModel = new ConnectedappViewModel();
ObjModel.lstConnectedapp = new List <ConnectedappViewModel>();
string lstdata = "select Id,AppName, IntegrationKey,userid from tbl_connectedapp";
MySql.Data.MySqlClient.MySqlCommand cmd1 = new MySql.Data.MySqlClient.MySqlCommand(lstdata, con);
MySqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
ObjModel.lstConnectedapp.Add(new ConnectedappViewModel
{
AppID = Convert.ToInt32(reader["Id"].ToString()),
AppName = reader["AppName"].ToString(),
IntegrationKey = reader["IntegrationKey"].ToString()
});
}
con.Close();
return(View(ObjModel));
}