public JsonResult AddUpdateVendor(VendorModels Model) { var UseInfo = GetLoginUserInfo(Session["EmpId"].ToString()); if (Model.ID > 0) { Model.ModifiedDate = DateTime.Now; } else { Model.ReqEmpCode = UseInfo[1]; Model.ReqEmpName = UseInfo[2]; Model.ReqEmpTitle = UseInfo[3].Equals("M") ? "Mr." : "Ms."; Model.ReqEmpEmailID = UseInfo[4]; Model.ReqMobile = UseInfo[5]; Model.AddDate = DateTime.Now; } Model.IsActive = true; return(Json(_vendorRepository.AddUpdateVendor(Model), JsonRequestBehavior.AllowGet)); }
public string IsExistEmailOrMobile(string Email, string Mobile, int Id) { string name = null; VendorModels model = null; if (Id > 0) { var list = _context.NONSODVendorMaster.Where(n => n.EmailId == Email).ToList(); var list1 = _context.NONSODVendorMaster.Where(n => n.MobileNo == Mobile).ToList(); if (list.Count > 1) { name = "This email is already exist with " + (list[list.Count - 1].FirstName + " " + list[list.Count - 1].LastName); } else { if (list1.Count > 1) { name = "This mobile no. is already exist with " + (list1[list.Count - 1].FirstName + " " + list1[list.Count - 1].LastName); } } } else { model = _context.NONSODVendorMaster.Where(n => n.EmailId == Email).FirstOrDefault(); if (model != null) { name = "This email is already exist with " + (model.FirstName + " " + model.LastName); } else { model = _context.NONSODVendorMaster.Where(n => n.MobileNo == Mobile).FirstOrDefault(); if (model != null) { name = "This mobile no. is already exist with " + (model.FirstName + " " + model.LastName); } } } return(name); }
public JsonResult AddUpdateVendorhd(VendorModels Model) { var userinfo = (NonSODUserRoleDetails().Data) as List <EmployeeModel>; var userDetail = userinfo.Where(x => x.Email == Model.ReqEmpEmailID).ToList(); if (Model.ID > 0) { Model.ModifiedDate = DateTime.Now; Model.AddVendorOnBehalfof = "Helpdesk"; } else { Model.ReqEmpCode = userDetail[0].EmpCode; Model.ReqEmpName = userDetail[0].EmpName; Model.ReqEmpEmailID = userDetail[0].Email; Model.ReqMobile = userDetail[0].Phone; Model.AddDate = DateTime.Now; Model.AddVendorOnBehalfof = "Helpdesk"; } Model.IsActive = true; return(Json(_vendorRepository.AddUpdateVendor(Model), JsonRequestBehavior.AllowGet)); }
public string AddUpdateVendor(VendorModels vendorModels) { string msg = "Record successfully added!"; try { if (vendorModels.ID > 0) { var data = _context.NONSODVendorMaster.Where(n => n.ID == vendorModels.ID).OrderBy(n => n.ID).FirstOrDefault(); if (data != null) { msg = "Record has been updated successfully."; data.FirstName = vendorModels.FirstName; data.LastName = vendorModels.LastName; data.MobileNo = vendorModels.MobileNo; data.EmailId = vendorModels.EmailId; data.Gender = vendorModels.Gender; data.CompanyName = vendorModels.CompanyName; data.ModifiedDate = vendorModels.ModifiedDate; data.AddVendorOnBehalfof = vendorModels.AddVendorOnBehalfof; } } else { var num = _context.NONSODVendorMaster.Select(x => x.ID).Max(); vendorModels.VendorCode = WebConfigurationManager.AppSettings["VendorPrefixKey"] + (num > 0 ? (num + 1) : 1); _context.NONSODVendorMaster.Add(vendorModels); } _context.SaveChanges(); } catch (Exception ex) { throw; } return(msg); }