public ActionResult Create(SYS_USER sys_users, SYS_USER_INTERN sys_users_intern)
{
var checkemail = db.SYS_USER.SqlQuery("SELECT * FROM SYS_USER WHERE USER_NAME = '" + sys_users.USER_NAME + "' and USER_STATUS = 1").Count();
if (checkemail > 0)
{
TempData["Notifikasi"] = 2;
TempData["NotifikasiText"] = "Terjadi duplikasi data dengan Uername : " + sys_users.USER_NAME;
return(RedirectToAction("Create"));
}
else
{
var UserId = Session["USER_ID"];
var logcode = MixHelper.GetLogCode();
int idintern = MixHelper.GetSequence("SYS_USER_INTERN");
int lastid = MixHelper.GetSequence("SYS_USER");
var datenow = MixHelper.ConvertDateNow();
var fname1 = "USER_INTERN_ID,USER_INTERN_FULLNAME,USER_INTERN_ADDRESS,USER_INTERN_EMAIL,USER_INTERN_PHONE,USER_INTERN_CREATE_BY,USER_INTERN_CREATE_DATE,USER_INTERN_STATUS,USER_INTERN_LOG_CODE ";
var fvalue1 = "'" + idintern + "', " +
"'" + sys_users_intern.USER_INTERN_FULLNAME + "', " +
"'" + sys_users_intern.USER_INTERN_ADDRESS + "'," +
"'" + sys_users_intern.USER_INTERN_EMAIL + "'," +
"'" + sys_users_intern.USER_INTERN_PHONE + "'," +
"'" + UserId + "', " +
datenow + "," +
"1," +
"'" + logcode + "'";
db.Database.ExecuteSqlCommand("INSERT INTO SYS_USER_INTERN (" + fname1 + ") VALUES (" + fvalue1.Replace("''", "NULL") + ")");
var fname = "USER_ID,USER_NAME,USER_PASSWORD,USER_ACCESS_ID,USER_TYPE_ID,USER_REF_ID,USER_CREATE_BY,USER_CREATE_DATE,USER_LOG_CODE,USER_STATUS";
var fvalue = "'" + lastid + "', " +
"'" + sys_users.USER_NAME + "', " +
"'" + GenPassword(sys_users.USER_PASSWORD) + "', " +
"'" + sys_users.USER_ACCESS_ID + "'," +
"1," +
"'" + idintern + "', " +
"'" + UserId + "', " +
datenow + "," +
"'" + logcode + "'," +
"1";
//return Json(new { query = "INSERT INTO SYS_USER (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")" }, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("INSERT INTO SYS_USER (" + fname + ") VALUES (" + fvalue.Replace("''", "NULL") + ")");
String objek = fvalue.Replace("'", "-");
MixHelper.InsertLog(logcode, objek, 1);
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Data Berhasil Disimpan";
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(SYS_USER sys_users, SYS_USER_INTERN sys_users_intern)
{
var checkemail = db.SYS_USER.SqlQuery("SELECT * FROM SYS_USER WHERE USER_NAME = '" + sys_users.USER_NAME + "' AND USER_STATUS = 1 AND USER_ID != " + sys_users.USER_ID).Count();
if (checkemail > 0)
{
TempData["Notifikasi"] = 2;
TempData["NotifikasiText"] = "Terjadi duplikasi data dengan Uername : " + sys_users.USER_NAME;
return(RedirectToAction("Edit/" + sys_users.USER_ID));
}
else
{
var UserId = Session["USER_ID"];
var datenow = MixHelper.ConvertDateNow();
var fupdate1 = "USER_ACCESS_ID = '" + sys_users.USER_ACCESS_ID + "'," +
"USER_NAME = '" + sys_users.USER_NAME + "'," +
//"USER_PASSWORD = '******'," +
"USER_UPDATE_BY = '" + UserId + "'," +
"USER_UPDATE_DATE = " + datenow;
var fupdate2 = "USER_INTERN_FULLNAME = '" + sys_users_intern.USER_INTERN_FULLNAME + "'," +
"USER_INTERN_ADDRESS = '" + sys_users_intern.USER_INTERN_ADDRESS + "'," +
"USER_INTERN_EMAIL = '" + sys_users_intern.USER_INTERN_EMAIL + "'," +
"USER_INTERN_PHONE = '" + sys_users_intern.USER_INTERN_PHONE + "'," +
"USER_INTERN_UPDATE_BY = '" + UserId + "'," +
"USER_INTERN_UPDATE_DATE = " + datenow;
//return Json(new { query1 = "UPDATE SYS_USER SET " + fupdate1 + " WHERE USER_ID = " + sys_users.USER_ID, query2 = "UPDATE SYS_USER_INTERN SET " + fupdate2 + " WHERE USER_INTERN_ID = " + sys_users_intern.USER_INTERN_ID}, JsonRequestBehavior.AllowGet);
db.Database.ExecuteSqlCommand("UPDATE SYS_USER SET " + fupdate1 + " WHERE USER_ID = " + sys_users.USER_ID);
db.Database.ExecuteSqlCommand("UPDATE SYS_USER_INTERN SET " + fupdate2 + " WHERE USER_INTERN_ID = " + sys_users_intern.USER_INTERN_ID);
String objek = fupdate2.Replace("'", "-");
//MixHelper.InsertLog(logcode, objek, 1);
TempData["Notifikasi"] = 1;
TempData["NotifikasiText"] = "Data Berhasil Disimpan";
return(RedirectToAction("Index"));
}
}
