public ActionResult ChangePassword(Master_User user, string NewPassword, string ConfirmPassword) { IUserService svc = new UserService(); var model = svc.ChangedPassword(user, NewPassword); this.AddNotification("Your Password Has Been Successfully Changed. ", NotificationType.SUCCESS); return(RedirectToAction("Index")); }
public Master_User AddUser(Master_User model) { IHashingService sec = new HashingService(); var dc = new eprocdbDataContext(); string Password = "******"; string pwd = sec.CreatePasswordHash(Password); model.Password = pwd; dc.Master_Users.InsertOnSubmit(model); dc.SubmitChanges(); return(model); }
public Master_User Add(Master_User model) { IHashingService sec = new HashingService(); string pwd = sec.CreatePasswordHash(model.Password.Trim()); var dc = new eprocdbDataContext(); model.ID = Guid.NewGuid(); model.Password = pwd; dc.Master_Users.InsertOnSubmit(model); dc.SubmitChanges(); return(model); }
public Master_User ChangedPassword(Master_User model, string NewPassword) { IHashingService sec = new HashingService(); string pwd = sec.CreatePasswordHash(NewPassword.Trim()); var dc = new eprocdbDataContext(); var md = (from c in dc.Master_Users where c.UserID == model.UserID select c).FirstOrDefault(); md.Password = pwd; dc.SubmitChanges(); return(model); }
public Master_User Reset(string UserID, Master_User model) { IHashingService sec = new HashingService(); string pwd = sec.CreatePasswordHash("dc123"); var dc = new eprocdbDataContext(); var md = (from c in dc.Master_Users where c.UserID == UserID select c).FirstOrDefault(); md.Password = pwd; dc.SubmitChanges(); return(model); }
public ActionResult ResetAJAX(string UserID, Master_User model) { try { IUserService svc = new UserService(); var result = svc.Reset(UserID, model); this.AddNotification("Reset Password Successfully.", NotificationType.SUCCESS); return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("User Reset", ex.Message, ex.StackTrace); this.AddNotification("Something Went Wrong.", NotificationType.ERROR); return(RedirectToAction("Index")); } }
public Master_User UpdateUser(string id, Master_User model) { var dc = new eprocdbDataContext(); var md = (from c in dc.Master_Users where c.UserID == id select c).SingleOrDefault(); md.FullName = model.FullName; md.GroupID = model.GroupID; md.id_vendor = model.id_vendor; dc.SubmitChanges(); return(model); }
public ActionResult Edit(string userId, Master_User Model, string VENDORID) { try { if (VENDORID != "") { Model.id_vendor = VENDORID; } IUserService svc = new UserService(); var result = svc.Edit(userId, Model); return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("User Edit", ex.Message, ex.StackTrace); return(View("~/Views/Master/User/Index.cshtml")); } }
public ActionResult Download(Master_User model) { try { XLWorkbook xlWorkBook = new XLWorkbook(); var xlWorkSheet = xlWorkBook.Worksheets.Add("Master User");// xlWorkSheet; xlWorkSheet.Cell(1, 1).Value = "UserId"; xlWorkSheet.Cell(1, 2).Value = "NamaLengkap"; xlWorkSheet.Cell(1, 3).Value = "Group"; xlWorkSheet.Cell(1, 4).Value = "IdVendor"; IUserService svc = new UserService(); var Data = svc.GetAll(); int Row = 2; if (Data.Count > 0) { for (int i = 0; i < Data.Count; i++) { xlWorkSheet.Cell(Row + i, 1).Value = Data[i].UserID; xlWorkSheet.Cell(Row + i, 2).Value = Data[i].FullName; xlWorkSheet.Cell(Row + i, 3).Value = Data[i].GroupID; xlWorkSheet.Cell(Row + i, 4).Value = Data[i].id_vendor; } xlWorkSheet.Columns().AdjustToContents(); var path = Server.MapPath("..") + "\\Master-User.xlsx"; xlWorkBook.SaveAs(path); xlWorkBook.Dispose(); return(File(path, "application/vnd.ms-excel", "Master-User.xlsx")); } return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("User Download", ex.Message, ex.StackTrace); this.AddNotification("Something Went Wrong.", NotificationType.ERROR); return(RedirectToAction("Index")); } }
public Master_User Edit(string userId, Master_User model) { IHashingService sec = new HashingService(); string pwd = sec.CreatePasswordHash(model.Password.Trim()); var dc = new eprocdbDataContext(); var md = (from c in dc.Master_Users where c.UserID == userId select c).FirstOrDefault(); md.UserID = model.UserID; md.FullName = model.FullName; md.GroupID = model.GroupID == null ? md.GroupID : model.GroupID; md.id_vendor = model.id_vendor == null ? md.id_vendor : model.id_vendor; //md.Group_VendorID = model.Group_VendorID; md.Email = model.Email; if (model.Password != null && model.Password != "" && model.Password != md.Password) { md.Password = pwd; } dc.SubmitChanges(); return(model); }
public ActionResult Add(Master_User model, string ConfirmPass) { try { IUserService svc = new UserService(); var user = svc.Getdata(model.UserID); if (user != null) { ViewBag.Message = "Username exist.!!"; this.ViewBag.groupId = GetGroupId(); this.ViewBag.vendorId = GetVendor(); this.ViewBag.groupVendorId = GetGroupVendor(); return(View("~/Views/Master/User/Add.cshtml")); } else if (ConfirmPass == model.Password) { model.Group_VendorID = ""; var result = svc.Add(model); this.AddNotification("Your Data Has Been Successfully Saved. ", NotificationType.SUCCESS); return(RedirectToAction("Index")); } else { ViewBag.Message = "Password not match.!!"; this.ViewBag.groupId = GetGroupId(); this.ViewBag.vendorId = GetVendor(); this.ViewBag.groupVendorId = GetGroupVendor(); return(View("~/Views/Master/User/Add.cshtml")); } } catch (Exception ex) { general.AddLogError("User Add", ex.Message, ex.StackTrace); this.AddNotification("ID exist", NotificationType.ERROR); return(View("~/Views/Master/User/Add.cshtml")); } }
public ActionResult Index(Master_User user) { if (ModelState.IsValid) { IUserService svc = new UserService(); var result = svc.Login(user.UserID, user.Password); if (result != null) { FormsAuthentication.SetAuthCookie(user.UserID, true); System.Web.HttpContext.Current.Session["USERS_DATA"] = result; System.Web.HttpContext.Current.Session["Fullname"] = result.FullName; System.Web.HttpContext.Current.Session["UserID"] = result.UserID; System.Web.HttpContext.Current.Session["VendorID"] = result.id_vendor; System.Web.HttpContext.Current.Session["GroupID"] = result.GroupID; AddLogLogin(result.SessionID == null ? "" : result.SessionID, result.UserID); return(RedirectToAction("Index", "Home")); } else { ViewData["error"] = "Login data is incorrect!"; } } return(View("Index", user)); }
public ActionResult Index(HttpPostedFileBase postedFile, CUSTOMFILEUPLOAD model, string DdlMasterType) { string filePath = string.Empty; if (postedFile != null) { string path = Server.MapPath("~/Uploads/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } string tahun = DateTime.Now.Year.ToString(); string bulan = DateTime.Now.Month.ToString(); string tgl = DateTime.Now.Day.ToString(); string jam = DateTime.Now.Hour.ToString(); string menit = DateTime.Now.Minute.ToString(); string detik = DateTime.Now.Second.ToString(); string tanggalSekarang = "_" + tahun + bulan + tgl + jam + menit + detik; string type = ""; if (DdlMasterType == "CUSTOMCOMPANY") { type = "CUSTOMCOMPANY"; } else if (DdlMasterType == "MSMATERIAL") { type = "MSMATERIAL"; } else if (DdlMasterType == "MSPLANT") { type = "MSPLANT"; } else if (DdlMasterType == "MSVENDOR") { type = "MSVENDOR"; } else if (DdlMasterType == "MSUSER") { type = "MSUSER"; } string FileName = type + tanggalSekarang + ".xls"; filePath = path + FileName; try { postedFile.SaveAs(filePath); IUploadVehicleService svcUploadFilename = new UploadVehicleService(); model.ID = Convert.ToInt32(UploadVehicleService.GenerateID()); model.FILEUPLOAD = FileName; model.MODIFIED_BY = "UserName"; model.MODIFIED_DATE = DateTime.Now; svcUploadFilename.Add(model); DataTable dt = postedFile.ToDataTable(); #region Insert #region CUSTOMCOMPANY if (type == "CUSTOMCOMPANY") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["COMPANYCODE"] != DBNull.Value) { var dc = new eprocdbDataContext(); //cek code ada atau tidak var compCode = (from c in dc.CUSTOMCOMPANies where c.COMPANYCODE == row["COMPANYCODE"].ToString() select new { c.COMPANYCODE }).ToList(); string code = string.Empty; foreach (var value in compCode) { code = value.COMPANYCODE; } //isi model customcompany sesuai row data table CUSTOMCOMPANY objModelComp = new CUSTOMCOMPANY(); objModelComp.COMPANYCODE = row["COMPANYCODE"].ToString(); objModelComp.COMPANYNAME = row["COMPANYNAME"].ToString(); objModelComp.ALAMAT = row["ALAMAT"].ToString(); objModelComp.KOTA = row["KOTA"].ToString(); objModelComp.REGION = row["REGION"].ToString(); objModelComp.POSTALCODE = row["POSTALCODE"].ToString(); objModelComp.TELEPON = row["TELEPON"].ToString(); objModelComp.NPWP = row["NPWP"].ToString(); objModelComp.KTPTDP = row["KTPTDP"].ToString(); objModelComp.COMPANYCODETSO = row["COMPANYCODETSO"].ToString(); //jika ada update if (code.ToString() != "") { objModelComp.DIUBAHOLEH = Session["UserID"].ToString(); objModelComp.DIUBAHTGL = DateTime.Now.Date; IUploadMasterService svc = new UploadMasterService(); var result = svc.UpdateCompany(row["COMPANYCODE"].ToString(), objModelComp); } //jika tidak ada Insert else { objModelComp.DIBUATOLEH = Session["UserID"].ToString(); objModelComp.DIBUATTGL = DateTime.Now.Date; IUploadMasterService svc = new UploadMasterService(); var result = svc.AddCompany(objModelComp); } } } } #endregion #region MSMATERIAL if (type == "MSMATERIAL") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["MATERIALNUMBER"] != DBNull.Value) { var dc = new eprocdbDataContext(); //cek code ada atau tidak var materialNumber = (from c in dc.MSMATERIALs where c.MATERIALNUMBER == row["MATERIALNUMBER"].ToString() select new { c.MATERIALNUMBER }).ToList(); string code = string.Empty; foreach (var value in materialNumber) { code = value.MATERIALNUMBER; } //isi model MSMATERIAL sesuai row data table MSMATERIAL objModelMaterial = new MSMATERIAL(); objModelMaterial.MATERIALNUMBER = row["MATERIALNUMBER"].ToString(); //objModelMaterial.DESCRIPTION = row["DESCRIPTION"].ToString(); //objModelMaterial.MATERIALTYPE = row["MATERIALTYPE"].ToString(); //objModelMaterial.MATERIALGROUP = row["MATERIALGROUP"].ToString(); //objModelMaterial.OLDMATERIAL = row["OLDMATERIAL"].ToString(); //objModelMaterial.BOMMATERIAL = row["BOMMATERIAL"].ToString(); //objModelMaterial.BRAND = row["BRAND"].ToString(); //objModelMaterial.MODEL = row["MODEL"].ToString(); //objModelMaterial.GARDAN = row["GARDAN"].ToString(); //objModelMaterial.YEAR = row["YEAR"].ToString(); //objModelMaterial.PURCHASEGROUPID = row["PURCHASEGROUPID"].ToString(); objModelMaterial.MATERIALIDVENDOR = row["MATERIALIDVENDOR"].ToString(); //double price = 0; //Double.TryParse(row["PRICELIST"].ToString(), out price); //objModelMaterial.PRICELIST = price; //jika ada update if (code.ToString() != "") { IUploadMasterService svc = new UploadMasterService(); var result = svc.UpdateMaterial(row["MATERIALNUMBER"].ToString(), objModelMaterial); } //jika tidak ada Insert else { IUploadMasterService svc = new UploadMasterService(); //var result = svc.AddMaterial(objModelMaterial); } } } } #endregion #region MSPLANT if (type == "MSPLANT") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["PLANTID"] != DBNull.Value) { var dc = new eprocdbDataContext(); //cek code ada atau tidak var plantID = (from c in dc.MSPLANTs where c.PLANTID == row["PLANTID"].ToString() select new { c.PLANTID }).ToList(); string code = string.Empty; foreach (var value in plantID) { code = value.PLANTID; } //isi model MSPLANT sesuai row data table MSPLANT objModelPlant = new MSPLANT(); objModelPlant.PLANTID = row["PLANTID"].ToString(); objModelPlant.NAME = row["NAME"].ToString(); objModelPlant.ALAMAT = row["ALAMAT"].ToString(); objModelPlant.KELURAHAN = row["KELURAHAN"].ToString(); objModelPlant.KECAMATAN = row["KECAMATAN"].ToString(); objModelPlant.CITY = row["CITY"].ToString(); objModelPlant.REGION = row["REGION"].ToString(); objModelPlant.CONTACTPERSONNAME = row["CONTACTPERSONNAME"].ToString(); objModelPlant.ALAMAT2 = row["ALAMAT2"].ToString(); objModelPlant.ALAMAT3 = row["ALAMAT3"].ToString(); objModelPlant.ALAMAT4 = row["ALAMAT4"].ToString(); objModelPlant.ALAMAT5 = row["ALAMAT5"].ToString(); objModelPlant.PROPINSI = row["PROPINSI"].ToString(); objModelPlant.PIC = row["PIC"].ToString(); objModelPlant.TITLECP = row["TITLECP"].ToString(); objModelPlant.NOHPCP = row["NOHPCP"].ToString(); objModelPlant.NOTELPPLANT = row["NOTELPPLANT"].ToString(); objModelPlant.POSTALCODE = row["POSTALCODE"].ToString(); objModelPlant.CUSTOMERNO = row["CUSTOMER_NUMBER"].ToString(); //jika ada update if (code.ToString() != "") { IUploadMasterService svc = new UploadMasterService(); var result = svc.UpdatePlant(row["PLANTID"].ToString(), objModelPlant); } //jika tidak ada Insert else { IUploadMasterService svc = new UploadMasterService(); var result = svc.AddPlant(objModelPlant); } } } } #endregion #region MSVENDOR if (type == "MSVENDOR") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["VENDORID"] != DBNull.Value) { var dc = new eprocdbDataContext(); //cek code ada atau tidak var vendorID = (from c in dc.MSVENDORs where c.VENDORID == row["VENDORID"].ToString() select new { c.VENDORID }).ToList(); string code = string.Empty; foreach (var value in vendorID) { code = value.VENDORID; } //isi model MSVENDOR sesuai row data table MSVENDOR objModelVendor = new MSVENDOR(); objModelVendor.VENDORID = row["VENDORID"].ToString(); //objModelVendor.VENDORNAME = row["VENDORNAME"].ToString(); //objModelVendor.STREET = row["STREET"].ToString(); //objModelVendor.DISTRIC = row["DISTRIC"].ToString(); //objModelVendor.CITY = row["CITY"].ToString(); //objModelVendor.POSTALCODE = row["POSTALCODE"].ToString(); //objModelVendor.TELEPHONE = row["TELEPHONE"].ToString(); //objModelVendor.EMAIL = row["EMAIL"].ToString(); //objModelVendor.EMAIL2 = row["EMAIL2"].ToString(); //objModelVendor.EMAIL3 = row["EMAIL3"].ToString(); //objModelVendor.EMAIL4 = row["EMAIL4"].ToString(); //objModelVendor.EMAIL5 = row["EMAIL5"].ToString(); //objModelVendor.EMAIL6 = row["EMAIL6"].ToString(); //objModelVendor.EMAIL7 = row["EMAIL7"].ToString(); //objModelVendor.EMAIL8 = row["EMAIL8"].ToString(); //objModelVendor.PLANTIDTSO = row["PLANTIDTSO"].ToString(); objModelVendor.B2B = row["ISB2B"].ToString() == "1" ? '1' : '0'; //jika ada update if (code.ToString() != "") { IUploadMasterService svc = new UploadMasterService(); var result = svc.UpdateVendor(row["VENDORID"].ToString(), objModelVendor); } //jika tidak ada Insert else { //IUploadMasterService svc = new UploadMasterService(); //var result = svc.AddVendor(objModelVendor); } } } } #endregion #region MSUSER if (type == "MSUSER") { foreach (DataRow row in dt.Rows) { //cek row null atau tidak if (row["UserId"] != DBNull.Value) { var dc = new eprocdbDataContext(); //cek code ada atau tidak var UserId = (from c in dc.Master_Users where c.UserID == row["UserId"].ToString() select new { c.UserID }).ToList(); string code = string.Empty; foreach (var value in UserId) { code = value.UserID; } //isi model MSVENDOR sesuai row data table Master_User objModelUser = new Master_User(); objModelUser.UserID = row["UserId"].ToString(); objModelUser.FullName = row["NamaLengkap"].ToString(); objModelUser.GroupID = row["Group"].ToString(); objModelUser.id_vendor = row["IdVendor"].ToString(); //jika ada update if (code.ToString() != "") { IUploadMasterService svc = new UploadMasterService(); var result = svc.UpdateUser(row["UserId"].ToString(), objModelUser); } //jika tidak ada Insert else { IUploadMasterService svc = new UploadMasterService(); var result = svc.AddUser(objModelUser); } } } } #endregion #endregion if (filePath != null || filePath != string.Empty) { if ((System.IO.File.Exists(filePath))) { System.IO.File.Delete(filePath); } } this.AddNotification("File uploaded successfully.", NotificationType.SUCCESS); } catch (Exception ex) { general.AddLogError("Upload Master", ex.Message, ex.StackTrace); this.AddNotification("File uploaded failed.", NotificationType.ERROR); return(View("~/Views/Master/UploadMaster/Index.cshtml")); throw ex; } } return(View("~/Views/Master/UploadMaster/Index.cshtml")); }
public MenuViewModel GetMenu() { var dc = new eprocdbDataContext(); Master_User sessionUser = (Master_User)HttpContext.Current.Session["USERS_DATA"]; string role = sessionUser.GroupID; var sourcedata = dc.Mgmt_Akses.Where(x => x.GroupID == role).ToList(); var vw = new MenuItemViewModel(); var parent = (from b in sourcedata join a in dc.Master_Menus on b.MenuID.Trim() equals a.MenuID.Trim() where a.ParentID == null orderby a.OrderNumber select new MenuItemViewModel { MenuItemId = a.MenuID, MenuItemName = a.Text, MenuItemPath = a.Url, ParentItemId = a.ParentID, ParentIconClass = a.ParentIconClass, ChildIconClass = a.ChildIconClass }).ToList(); var child = (from c in sourcedata join b in dc.Master_Menus on c.MenuID.Trim() equals b.MenuID.Trim() where b.MenuID != "007" select new MenuItemViewModel { MenuItemId = b.MenuID, MenuItemName = b.Text, MenuItemPath = b.Url, ParentItemId = b.ParentID, ParentIconClass = b.ParentIconClass, ChildIconClass = b.ChildIconClass }).ToList(); MenuViewModel mod = new MenuViewModel(); foreach (var a in parent) { vw = a; foreach (var z in child) { if (a.MenuItemId == z.ParentItemId) { vw.ChildMenuItems.Add(new MenuItemViewModel() { MenuItemName = z.MenuItemName, MenuItemPath = z.MenuItemPath, MenuItemId = z.MenuItemId, ParentItemId = z.ParentItemId, ParentIconClass = z.ParentIconClass, ChildIconClass = z.ChildIconClass }); } } mod.Items.Add(a); } return(mod); }