public int InsertUserForm(UserFormModel model)
{
try
{
Mapper.CreateMap <UserFormModel, UserFormTran>();
UserFormTran objUser = Mapper.Map <UserFormTran>(model);
Dbcontext.UserFormTrans.Add(objUser);
return(Dbcontext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public int checkFrmID(int?formID, int?uid)
{
Mapper.CreateMap <UserFormTran, UserFormTranItem>();
UserFormTran objBranch = DbContext.UserFormTrans.SingleOrDefault(m => m.FormID == formID && m.UID == uid);
UserFormTranItem objBItem = Mapper.Map <UserFormTranItem>(objBranch);
if (objBItem == null)
{
return(0);
}
else
{
return(objBItem.FormID.Value);
}
}
public int InsertLeftMenu(LoginItem model, bool chk, int?formID)
{
try
{
Mapper.CreateMap <LoginItem, UserFormTran>();
UserFormTran objLogin = Mapper.Map <UserFormTran>(model);
objLogin.FormID = formID;
objLogin.IsChecked = chk;
objLogin.CreatedBy = model.UId;
objLogin.CreatedDate = System.DateTime.Now;
DbContext.UserFormTrans.Add(objLogin);
return(DbContext.SaveChanges());
}
catch (Exception ex)
{
throw;
}
}
public ActionResult Edit(LoginItem model)
{
UserService objUser = new UserService();
LoginItem objItem = new LoginItem();
string uid = null;
if (Session["UserId"] != null)
{
uid = Session["UserId"].ToString();
}
model.UpdatedBy = uid;
model.UpdatedDate = System.DateTime.Now;
objUser.Update(model);
//int UID = Convert.ToInt32(Session["UserId"].ToString());
int UID = model.UId;
foreach (var i in model.ListModules)
{
int? MHId = i.MHId;
bool chk = i.IsChecked;
int id = objUser.checkMHID(MHId, UID);
int uhid = model.UHTID;
if (id == null || id == 0)
{
//if (chk == true)
//{
objUser.InsertModules(model, MHId, chk, UID);
//}
}
else
{
//objUser.updateModules(model, MHId, chk, UID);
UserModulesTran userData = DbContext.UserModulesTrans.Where(u => u.UID == UID && u.MHID == MHId).SingleOrDefault();
//userData.UMTID = model.UMTID;
userData.MHID = MHId;
userData.IsChecked = chk;
userData.UID = UID;
userData.UpdatedBy = UID;
userData.UpdatedDate = System.DateTime.Now;
DbContext.SaveChanges();
}
}
foreach (var i in model.ListForm)
{
int umtid = model.UMTID;
bool chk = i.IsChecked;
int? formID = i.FormId;
int? id = objUser.checkFrmID(formID, UID);
int? uhid = model.UHTID;
int? mhid = i.MHId;
if (id == null || id == 0)
{
//if (chk == true)
//{
objUser.InsertLeftMenu(model, chk, formID);
//}
}
else
{
UserFormTran userData = DbContext.UserFormTrans.Where(u => u.UID == UID && u.FormID == formID).SingleOrDefault();
//userData.UMTID = model.UMTID;
userData.FormID = formID;
userData.IsChecked = chk;
DbContext.SaveChanges();
userData.UpdatetdDate = System.DateTime.Now;
userData.UpdatedBy = UID;
//objUser.updateModules(model, MHId, chk, UID);
//objUser.updateModules(model1);
}
}
return(RedirectToAction("Create", new { @menuId = model.Viewbagidformenu }));
}
public ActionResult Index(UserModel model, string cmd, UserModuleModel module, UserFormModel form)
{
UserService objService = new UserService();
int uid = 0;
int rid = 0;
int did = 0;
int user = 0;
if (Session["UID"] != null)
{
uid = Convert.ToInt32(Session["UID"].ToString());
rid = Convert.ToInt32(Session["RoleID"].ToString());
did = Convert.ToInt32(Session["DID"].ToString());
if (cmd == "Save")
{
try
{
NetworkInterface[] nics = NetworkInterface.GetAllNetworkInterfaces();
String sMacAddress = string.Empty;
foreach (NetworkInterface adapter in nics)
{
if (sMacAddress == String.Empty)// only return MAC Address from first card
{
IPInterfaceProperties properties = adapter.GetIPProperties();
sMacAddress = adapter.GetPhysicalAddress().ToString();
}
}
model.DeviceID = sMacAddress;
//if (rid == 2)
//{
// model.CompID = cid;
//}
model.Status = true;
model.CanLogin = true;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = uid;
model.UserName = model.Email;
model.Password = Convert.ToString(model.Mobile);
user = objService.Insert(model);
if (model.ListModule != null)
{
foreach (var m in model.ListModule)
{
module.MID = m.MID;
module.UID = user;
module.IsChecked = m.IsChecked;
module.AssignedBy = uid;
module.AssignedDate = System.DateTime.Now;
objService.InsertUserModule(module);
}
foreach (var f in model.ListForms)
{
form.UID = user;
form.FID = f.FID;
form.IsChecked = f.IsChecked;
form.AssignedDate = System.DateTime.Now;
form.AssignedBy = uid;
objService.InsertUserForm(form);
}
}
else
{
foreach (var m in model.ListUserModule)
{
module.MID = m.MID;
module.UID = user;
module.IsChecked = m.IsChecked;
module.AssignedBy = uid;
module.AssignedDate = System.DateTime.Now;
objService.InsertUserModule(module);
}
foreach (var f in model.ListUserForms)
{
form.UID = user;
form.FID = f.FID;
form.IsChecked = f.IsChecked;
form.AssignedDate = System.DateTime.Now;
form.AssignedBy = uid;
objService.InsertUserForm(form);
}
}
TempData["AMsg"] = "Saved Successfully!";
}
catch (Exception ex)
{
TempData["AMsg"] = "Error Occured, " + ex;
}
}
else
{
try
{
//ManagementObjectSearcher mos = new ManagementObjectSearcher("select * from Win32_NetworkAdapter where Name='" + comboBox1.SelectedItem.ToString() + "'");
//ManagementObjectSearcher mos = new ManagementObjectSearcher("select * Win32_NetworkAdapter");
//ManagementObjectCollection moc = mos.Get();
//string mac = "";
//if (moc.Count > 0)
//{
// foreach (ManagementObject mo in moc)
// {
// mac = (string)mo["MACAddress"];
// }
//}
NetworkInterface[] nics = NetworkInterface.GetAllNetworkInterfaces();
String sMacAddress = string.Empty;
foreach (NetworkInterface adapter in nics)
{
if (sMacAddress == String.Empty)// only return MAC Address from first card
{
IPInterfaceProperties properties = adapter.GetIPProperties();
sMacAddress = adapter.GetPhysicalAddress().ToString();
}
}
//ManagementObjectSearcher objMOS = new ManagementObjectSearcher("Win32_NetworkAdapterConfiguration");
//ManagementObjectCollection objMOC = objMOS.Get();
//string MACAddress = String.Empty;
//foreach (ManagementObject objMO in objMOC)
//{
// if (MACAddress == String.Empty) // only return MAC Address from first card
// {
// MACAddress = objMO["MacAddress"].ToString();
// }
// objMO.Dispose();
//}
//MACAddress = MACAddress.Replace(":", "");
model.DeviceID = sMacAddress;
model.IPAddress = Request.UserHostAddress;
model.UpdatedBy = uid;
model.UpdatedDate = System.DateTime.Now;
objService.Update(model);
if (model.reset == true)
{
UserMaster um = Dbcontext.UserMasters.Where(m => m.UID == model.UID).SingleOrDefault();
um.Password = Convert.ToString(model.Mobile);
um.UserName = model.Email;
Dbcontext.SaveChanges();
}
user = model.UID;
foreach (var m in model.ListUserModule)
{
UserModuleTran userData = Dbcontext.UserModuleTrans.Where(u => u.UID == user && u.MID == m.MID).SingleOrDefault();
userData.MID = m.MID;
userData.UID = user;
userData.IsChecked = m.IsChecked;
userData.UpdatedBy = uid;
userData.UpdatedDate = System.DateTime.Now;
Dbcontext.SaveChanges();
}
foreach (var f in model.ListUserForms)
{
UserFormTran userForm = Dbcontext.UserFormTrans.Where(u => u.UID == user && u.FID == f.FID).SingleOrDefault();
userForm.UID = user;
userForm.FID = f.FID;
userForm.IsChecked = f.IsChecked;
userForm.UpdatedDate = System.DateTime.Now;
userForm.UpdatedBy = uid;
Dbcontext.SaveChanges();
}
if (model.reset == true)
{
TempData["AMsg"] = "Password Reset and Record Updated Successfully.";
}
else
{
TempData["AMsg"] = "Updated Successfully!";
}
}
catch (Exception ex)
{
TempData["AMsg"] = "Error Occured, " + ex;
}
}
}
else
{
Response.Redirect("/Login/Index");
}
return(RedirectToAction("Index"));
}
public ActionResult Index(UserModel model, string cmd, UserModuleModel module, UserFormModel form)
{
UserService objService = new UserService();
int uid = 0;
int rid = 0;
int cid = 0;
int user = 0;
if (Session["UID"] != null)
{
uid = Convert.ToInt32(Session["UID"].ToString());
rid = Convert.ToInt32(Session["RoleID"].ToString());
cid = Convert.ToInt32(Session["CompID"].ToString());
if (cmd == "Save")
{
try
{
//if (rid == 2)
//{
// model.CompID = cid;
//}
model.Status = true;
model.CanLogin = true;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = uid;
model.UserName = model.Email;
model.Password = Convert.ToString(model.Mobile);
user = objService.Insert(model);
if (model.ListModule != null)
{
foreach (var m in model.ListModule)
{
module.MID = m.MID;
module.UID = user;
module.IsChecked = m.IsChecked;
module.AssignedBy = uid;
module.AssignedDate = System.DateTime.Now;
objService.InsertUserModule(module);
}
foreach (var f in model.ListForms)
{
form.UID = user;
form.FID = f.FID;
form.IsChecked = f.IsChecked;
form.AssignedDate = System.DateTime.Now;
form.AssignedBy = uid;
objService.InsertUserForm(form);
}
}
else
{
foreach (var m in model.ListUserModule)
{
module.MID = m.MID;
module.UID = user;
module.IsChecked = m.IsChecked;
module.AssignedBy = uid;
module.AssignedDate = System.DateTime.Now;
objService.InsertUserModule(module);
}
foreach (var f in model.ListUserForms)
{
form.UID = user;
form.FID = f.FID;
form.IsChecked = f.IsChecked;
form.AssignedDate = System.DateTime.Now;
form.AssignedBy = uid;
objService.InsertUserForm(form);
}
}
TempData["AMsg"] = "Saved Successfully!";
}
catch (Exception ex)
{
TempData["AMsg"] = "Error Occured, " + ex;
}
}
else
{
try
{
model.UpdatedBy = uid;
model.UpdatedDate = System.DateTime.Now;
objService.Update(model);
if (model.reset == true)
{
UserMaster um = Dbcontext.UserMasters.Where(m => m.UID == model.UID).SingleOrDefault();
um.Password = Convert.ToString(model.Mobile);
um.UserName = model.Email;
Dbcontext.SaveChanges();
}
user = model.UID;
foreach (var m in model.ListUserModule)
{
UserModuleTran userData = Dbcontext.UserModuleTrans.Where(u => u.UID == user && u.MID == m.MID).SingleOrDefault();
userData.MID = m.MID;
userData.UID = user;
userData.IsChecked = m.IsChecked;
userData.UpdatedBy = uid;
userData.UpdatedDate = System.DateTime.Now;
Dbcontext.SaveChanges();
}
foreach (var f in model.ListUserForms)
{
UserFormTran userForm = Dbcontext.UserFormTrans.Where(u => u.UID == user && u.FID == f.FID).SingleOrDefault();
userForm.UID = user;
userForm.FID = f.FID;
userForm.IsChecked = f.IsChecked;
userForm.UpdatedDate = System.DateTime.Now;
userForm.UpdatedBy = uid;
Dbcontext.SaveChanges();
}
if (model.reset == true)
{
TempData["AMsg"] = "Password Reset and Record Updated Successfully.";
}
else
{
TempData["AMsg"] = "Updated Successfully!";
}
}
catch (Exception ex)
{
TempData["AMsg"] = "Error Occured, " + ex;
}
}
}
else
{
Response.Redirect("/Login/Index");
}
return(RedirectToAction("Index"));
}
