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)); }