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