public JsonResult DeleteUser(string Id) { ClsDB db = new ClsDB(); User user = new User(); try { _SbQry = new StringBuilder("Delete From UserMaster Where UserId='" + Id + "'"); db.Connect(); int Count = db.ExecuteNonQuery(_SbQry.ToString()); if (Count > 0) { user.Response = "Y"; } else { user.Response = "N"; user.ErrorMessage = "User could not be deleted"; } } 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)); }
public JsonResult AddNewUser(User user) { ClsDB db = new ClsDB(); try { if (ModelState.IsValid) { _SbQry = new StringBuilder("Insert Into UserMaster(UserId,Name) Values('" + user.Id + "','" + user.Name + "')"); db.Connect(); int Count = db.ExecuteNonQuery(_SbQry.ToString()); if (Count > 0) { user.Response = "Y"; } else { user.Response = "N"; user.ErrorMessage = "User could not be added"; } } else { foreach (var Key in ModelState.Keys) { if (ModelState[Key].Errors.Count > 0) { user.Response = "N"; user.ErrorMessage = ModelState[Key].Errors[0].ErrorMessage; return(Json(user, JsonRequestBehavior.AllowGet)); } } } } 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)); }