// 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 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));
}
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 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;
}
}
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));
}
private void button3_Click(object sender, EventArgs e)
{
ClsDB db = new ClsDB();
try
{
db.Connect();
db.GetDataTable_Proc("Prc_User");
MessageBox.Show("Saved");
}
catch (Exception ex) { MessageBox.Show(ex.Message); Log.Error(ex, "Error Occured"); }
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;
}
}
private void button4_Click(object sender, EventArgs e)
{
ClsDB db = new ClsDB();
try
{
db.Connect();
Dictionary <string, string> DicProcParameter = new Dictionary <string, string>();
DicProcParameter.Add("@Id", txtId.Text);
DicProcParameter.Add("@Name", txtName.Text);
db.GetDataTable_Proc("Prc_User", DicProcParameter);
MessageBox.Show("Saved");
}
catch (Exception ex) { MessageBox.Show(ex.Message); Log.Error(ex, "Error Occured"); }
finally
{
db.DisConnect();
db = null;
}
}
private void button2_Click(object sender, EventArgs e)
{
ClsDB db = new ClsDB();
try
{
db.Connect();
SqlParameter[] parameters =
{
new SqlParameter("@Id", txtId.Text),
new SqlParameter("@Name", txtName.Text)
};
db.GetDataTable_Proc("Prc_User", parameters);
MessageBox.Show("Saved");
}
catch (Exception ex) { MessageBox.Show(ex.Message); Log.Error(ex, "Error Occured"); }
finally
{
db.DisConnect();
db = null;
}
}