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