public JsonResult EditUser(string Id) { ClsDB db = new ClsDB(); User user = new User(); try { _SbQry = new StringBuilder("Select * From UserMaster Where UserId='" + Id + "'"); db.Connect(); DataTable dt = db.GetDataTable(_SbQry.ToString()); foreach (DataRow row in dt.Rows) { user.Id = row["UserId"].ToString(); user.Name = row["Name"].ToString(); } user.Response = "Y"; } catch (Exception ex) { ModelState.AddModelError("ErrorMessage", ex.Message); ViewBag.ErrorMessage = ex.Message; user.Response = "N"; user.ErrorMessage = "Error : " + ex.Message; } finally { db.DisConnect(); db = null; } return(Json(user, JsonRequestBehavior.AllowGet)); }
// GET: UserMaster public ActionResult ShowUsers() { UserViewModel userViewModel = new UserViewModel(); userViewModel.Users = new List <User>(); ClsDB db = new ClsDB(); try { _SbQry = new StringBuilder("Select * From UserMaster"); db.Connect(); DataTable dt = db.GetDataTable(_SbQry.ToString()); foreach (DataRow row in dt.Rows) { userViewModel.Users.Add(new User { Id = row["UserId"].ToString(), Name = row["Name"].ToString() }); } return(View(userViewModel)); } catch (Exception ex) { ModelState.AddModelError("ErrorMessage", ex.Message); ViewBag.ErrorMessage = ex.Message; return(View(userViewModel.Users)); } finally { db.DisConnect(); db = null; } }
public ActionResult EditUser(string Id) { ClsDB db = new ClsDB(); User user = new User(); try { _SbQry = new StringBuilder("Select * From UserMaster Where UserId='" + Id + "'"); db.Connect(); DataTable dt = db.GetDataTable(_SbQry.ToString()); foreach (DataRow row in dt.Rows) { user.Id = row["UserId"].ToString(); user.Name = row["Name"].ToString(); } return(PartialView(user)); } catch (Exception ex) { ModelState.AddModelError("ErrorMessage", ex.Message); user.ErrorMessage = ex.Message; return(PartialView(user)); } finally { db.DisConnect(); db = null; } }
private void btnInsert_Click(object sender, EventArgs e) { ClsDB db = new ClsDB(); try { string qry = $"Exec Prc_User {txtId.Text},'{txtName.Text}'"; db.Connect(); db.GetDataTable(qry); MessageBox.Show("Saved"); } catch (Exception ex) { MessageBox.Show(ex.Message); Log.Error(ex, "Error Occured"); } finally { db.DisConnect(); db = null; } }