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