public ActionResult Create([Bind(Include = "user_id,user_name,user_password,user_type_id,employee_id,fl_active")] user_accountViewModel user_acc)
{
if (ModelState.IsValid)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
ms_employee emp = db.ms_employee.Find(user_acc.employee_id);
if (emp == null)
{
throw new Exception("Employee not found " + user_acc.employee_id.ToString());
}
else
{
user_acc.employee_nik = emp.employee_nik;
user_acc.employee_name = emp.employee_name;
user_acc.employee_email = emp.employee_email;
emp.fl_active = true;
emp.updated_by = UserProfile.UserId;
emp.updated_date = DateTime.Now;
emp.deleted_by = null;
emp.deleted_date = null;
db.Entry(emp).State = EntityState.Modified;
ms_user ms_user = new ms_user()
{
user_name = user_acc.user_name,
user_password = App_Helpers.CryptorHelper.Encrypt(user_acc.user_password, "MD5", true),
user_type_id = user_acc.user_type_id,
employee_id = emp.employee_id,
fl_active = user_acc.fl_active,
created_by = UserProfile.UserId,
created_date = DateTime.Now,
updated_by = UserProfile.UserId,
updated_date = DateTime.Now,
deleted_by = null,
deleted_date = null
};
db.ms_user.Add(ms_user);
db.SaveChanges();
}
transaction.Commit();
ViewBag.ResultMessage = "Record inserted into table successfully.";
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
transaction.Rollback();
ViewBag.ResultMessage = string.Format("Error occured, records rolledback. {0}", ex.Message);
}
}
}
return(View(user_acc));
}
// GET: user/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ms_user ms_user = db.ms_user.Find(id);
if (ms_user == null)
{
return(HttpNotFound());
}
user_accountViewModel usr_acc = new user_accountViewModel()
{
fl_active = ms_user.fl_active,
user_id = ms_user.user_id,
user_name = ms_user.user_name,
user_password = ms_user.user_password,
user_type_id = ms_user.user_type_id,
employee_id = ms_user.employee_id,
employee_nik = ms_user.ms_employee.employee_nik,
employee_name = ms_user.ms_employee.employee_name,
employee_email = ms_user.ms_employee.employee_email,
};
return(View(usr_acc));
}
////GET: user/Details/5
//public ActionResult Details(int? id)
//{
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// ms_user ms_user = db.ms_user.Find(id);
// if (ms_user == null)
// {
// return HttpNotFound();
// }
// return View(ms_user);
//}
public ActionResult ModalFrm(int?id = 0)
{
user_accountViewModel usr_acc = null;
int user_id = (int)id;
ms_user ms_user = db.ms_user.Find(user_id);
if (ms_user == null)
{
usr_acc = new user_accountViewModel()
{
fl_active = true,
rec_isactive = "Yes",
user_id = 0,
user_type_id = 0,
employee_id = 0
};
}
else
{
usr_acc = new user_accountViewModel()
{
fl_active = true,
rec_isactive = "Yes",
user_id = ms_user.user_id,
user_name = ms_user.user_name,
user_password = App_Helpers.CryptorHelper.Decrypt(ms_user.user_password, "MD5", true),
user_type_id = ms_user.user_type_id,
user_type_name = ms_user.ms_user_type.user_type_name,
employee_id = ms_user.ms_employee.employee_id,
employee_nik = ms_user.ms_employee.employee_nik,
employee_name = ms_user.ms_employee.employee_name,
employee_email = ms_user.ms_employee.employee_email
};
}
List <SelectListItem> first = new List <SelectListItem> {
new SelectListItem {
Text = "- [Not Set] -", Value = "0", Selected = true
}
};
usr_acc.sli_user_type_list = (from t in db.ms_user_type
where (t.fl_active == true && t.deleted_date == null)
select new SelectListItem
{
Text = t.user_type_name,
Value = t.user_type_id.ToString()
}
).ToList <SelectListItem>().Union(first);
usr_acc.FormMode = (user_id > 0) ? EnumFormModeKey.Form_Edit : EnumFormModeKey.Form_New;
return(PartialView(usr_acc));
}
public ActionResult Edit([Bind(Include = "user_id,user_name,user_password,user_type_id,employee_id,fl_active")] user_accountViewModel user_acc)
{
if (ModelState.IsValid)
{
ms_user ms_user = db.ms_user.Find(user_acc.user_id);
ms_user.user_name = user_acc.user_name;
if (!string.IsNullOrWhiteSpace(user_acc.user_password))
{
ms_user.user_password = App_Helpers.CryptorHelper.Encrypt(user_acc.user_password, "MD5", true);
}
ms_user.user_type_id = user_acc.user_type_id;
ms_user.fl_active = true;
ms_user.updated_by = UserProfile.UserId;
ms_user.updated_date = DateTime.Now;
ms_user.deleted_by = null;
ms_user.deleted_date = null;
ms_employee emp = db.ms_employee.Find(user_acc.employee_id);
if (emp != null)
{
ms_user.employee_id = emp.employee_id;
emp.fl_active = true;
emp.updated_by = UserProfile.UserId;
emp.updated_date = DateTime.Now;
emp.deleted_by = null;
emp.deleted_date = null;
db.Entry(emp).State = EntityState.Modified;
}
db.Entry(ms_user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user_acc));
}
public ActionResult SaveDataUserAccount([Bind(Include = "user_id,user_name,user_password,user_type_id,employee_id,fl_active")] user_accountViewModel user_acc)
{
if (ModelState.IsValid)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
#region INSERT_DATA
if (user_acc.FormMode == EnumFormModeKey.Form_New)
{
ms_employee emp = db.ms_employee.Find(user_acc.employee_id);
if (emp == null)
{
throw new Exception("Employee not found. Please create Employee first " + user_acc.employee_id.ToString());
}
else
{
user_acc.employee_nik = emp.employee_nik;
user_acc.employee_name = emp.employee_name;
user_acc.employee_email = emp.employee_email;
emp.fl_active = true;
emp.updated_by = UserProfile.UserId;
emp.updated_date = DateTime.Now;
emp.deleted_by = null;
emp.deleted_date = null;
db.Entry(emp).State = EntityState.Modified;
ms_user ms_user = db.ms_user.Find(user_acc.user_id);
if (ms_user == null)
{
ms_user = new ms_user()
{
user_name = user_acc.user_name,
user_password = App_Helpers.CryptorHelper.Encrypt(user_acc.user_password, "MD5", true),
user_type_id = user_acc.user_type_id,
employee_id = emp.employee_id,
fl_active = user_acc.fl_active,
created_by = UserProfile.UserId,
created_date = DateTime.Now,
updated_by = UserProfile.UserId,
updated_date = DateTime.Now,
deleted_by = null,
deleted_date = null
};
db.ms_user.Add(ms_user);
}
else
{
ms_user.user_name = user_acc.user_name;
ms_user.user_password = App_Helpers.CryptorHelper.Encrypt(user_acc.user_password, "MD5", true);
ms_user.user_type_id = user_acc.user_type_id;
ms_user.employee_id = user_acc.employee_id;
ms_user.fl_active = user_acc.fl_active;
ms_user.created_by = UserProfile.UserId;
ms_user.created_date = DateTime.Now;
ms_user.updated_by = UserProfile.UserId;
ms_user.updated_date = DateTime.Now;
ms_user.deleted_by = null;
ms_user.deleted_date = null;
db.Entry(ms_user).State = EntityState.Modified;
}
db.SaveChanges();
}
ViewBag.ResultMessage = "Record inserted successfully.";
}
#endregion
#region UPDATE_DATA
else
{
ms_user ms_user = db.ms_user.Find(user_acc.user_id);
ms_user.user_name = user_acc.user_name;
if (!string.IsNullOrWhiteSpace(user_acc.user_password))
{
ms_user.user_password = App_Helpers.CryptorHelper.Encrypt(user_acc.user_password, "MD5", true);
}
ms_user.user_type_id = user_acc.user_type_id;
ms_user.fl_active = true;
ms_user.updated_by = UserProfile.UserId;
ms_user.updated_date = DateTime.Now;
ms_user.deleted_by = null;
ms_user.deleted_date = null;
ms_employee emp = db.ms_employee.Find(user_acc.employee_id);
if (emp != null)
{
ms_user.employee_id = emp.employee_id;
emp.fl_active = true;
emp.updated_by = UserProfile.UserId;
emp.updated_date = DateTime.Now;
emp.deleted_by = null;
emp.deleted_date = null;
db.Entry(emp).State = EntityState.Modified;
}
db.Entry(ms_user).State = EntityState.Modified;
ViewBag.ResultMessage = "Record updated successfully.";
}
#endregion
transaction.Commit();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
transaction.Rollback();
ViewBag.ResultMessage = string.Format("Error occured, records rolledback. {0}", ex.Message);
}
}
}
return(View(user_acc));
}
