// GET: EmployeeGIs/Create public ActionResult Create() { try { EmployeeGI empgi = new EmployeeGI(); empgi.DateOfBirth = DateTime.Now.Date.AddYears(-18).Date; ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "EmployeeCode"); List <SelectListItem> File_Nos = new List <SelectListItem>(); for (int i = 1; i <= 111; i++) { File_Nos.Add(new SelectListItem { Text = i.ToString(), Value = i.ToString() }); } var user = (UserMaster)Session["User"]; ViewBag.File_Nos = new SelectList(File_Nos, "Value", "Text"); ViewBag.Ranks = new SelectList(db.RankMasters.Where(item => item.CustomerId == user.CustomerId), "RankName", "RankName"); ViewBag.LGAs = new SelectList(db.CityMasters, "City", "City"); ViewBag.StateOfOrigins = new SelectList(db.StateMasters, "State", "State"); ViewBag.cadres = new SelectList(db.CadreMasters.Where(item => item.CustomerId == user.CustomerId), "CadreName", "CadreName"); ViewBag.Programmess = new SelectList(db.ProgrammeMasters.Where(item => item.CustomerId == user.CustomerId), "ProgrammeName", "ProgrammeName"); ViewBag.Unit_Researchs = new SelectList(db.UnitResearchMasters.Where(item => item.CustomerId == user.CustomerId), "UnitResearchName", "UnitResearchName"); ViewBag.Unit_Servicess = new SelectList(db.UnitServicesMasters.Where(item => item.CustomerId == user.CustomerId), "UnitServicesName", "UnitServicesName"); ViewBag.StationOfDeployments = new SelectList(db.StationMasters.Where(item => item.CustomerId == user.CustomerId), "StationName", "StationName"); ViewBag.Sections = new SelectList(db.SectionMasters.Where(item => item.CustomerId == user.CustomerId), "SectionName", "SectionName"); return(View(empgi)); } catch (Exception ext) { return(null); } }
public ActionResult Edit(EmployeeGI tenent) { if (ModelState.IsValid) { var tenentUpdate = db.EmployeeGIs.Find(tenent.EmployeeCode); tenentUpdate.First_Name = tenent.First_Name; tenentUpdate.Surname = tenent.Surname; tenentUpdate.Sex = tenent.Sex; tenentUpdate.DateOfBirth = tenent.DateOfBirth; tenentUpdate.Maiden_Name = tenent.Maiden_Name; tenentUpdate.Middle_Name = tenent.Middle_Name; tenentUpdate.Title = tenent.Title; tenentUpdate.StateOfOrigin = tenent.StateOfOrigin; tenentUpdate.LGA = tenent.LGA; tenentUpdate.Religion = tenent.Religion; tenentUpdate.DateOfRetirement = tenent.DateOfRetirement; tenentUpdate.EmployeeCode = tenent.EmployeeCode; tenentUpdate.Unit_Research = tenent.Unit_Research; tenentUpdate.Section = tenent.Section; tenentUpdate.StationOfDeployment = tenent.StationOfDeployment; tenentUpdate.File_No = tenent.File_No; tenentUpdate.Grade_Level = tenent.Grade_Level; tenentUpdate.Step = tenent.Step; tenentUpdate.Cadre = tenent.Cadre; tenentUpdate.Marital_Status = tenent.Marital_Status; tenentUpdate.PlaceOfBirth = tenent.PlaceOfBirth; tenentUpdate.Home_Town = tenent.Home_Town; tenentUpdate.ContactHomeAddress = tenent.ContactHomeAddress; tenentUpdate.FirstAppointmentDate = tenent.FirstAppointmentDate; tenentUpdate.FirstAppointmentLocation = tenent.FirstAppointmentLocation; tenentUpdate.ConfirmationDate = tenent.ConfirmationDate; tenentUpdate.LastPromotionDate = tenent.LastPromotionDate; tenentUpdate.Rank = tenent.Rank; db.Entry(tenentUpdate).State = EntityState.Modified; var customerUpdate = db.CustomerMasters.Find(tenentUpdate.CustomerId); customerUpdate.ContactPerson = tenent.CustomerMaster.ContactPerson = (tenent.First_Name + " " + tenent.Middle_Name + " " + tenent.Surname).Trim(); customerUpdate.OrgLogoUrl = tenent.CustomerMaster.OrgLogoUrl; customerUpdate.CountryLogoIrl = tenent.CustomerMaster.CountryLogoIrl; customerUpdate.OrgName = tenent.CustomerMaster.OrgName; customerUpdate.Email = tenent.CustomerMaster.Email; customerUpdate.Address = tenent.CustomerMaster.Address; customerUpdate.PhoneNumber = tenent.CustomerMaster.PhoneNumber; customerUpdate.CountryLogo = tenent.CustomerMaster.CountryLogo; customerUpdate.CountryLogoIrl = tenent.CustomerMaster.CountryLogoIrl; customerUpdate.OrgLogo = tenent.CustomerMaster.OrgLogo; customerUpdate.OrgLogoUrl = tenent.CustomerMaster.OrgLogoUrl; SaveImages(customerUpdate); db.Entry(customerUpdate).State = EntityState.Modified; var user = db.UserMasters.Where(um => um.CustomerId == tenent.CustomerId).FirstOrDefault(); user.Password = tenent.CustomerMaster.UserMaster.Password; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tenent)); }
// GET: CustomerMasters/Create public ActionResult Create() { ViewBag.LGAs = new SelectList(db.CityMasters.Where(c => c.StateId == 1), "City", "City"); ViewBag.StateOfOrigins = new SelectList(db.StateMasters, "State", "State"); var emp = new EmployeeGI() { CustomerMaster = new CustomerMaster() }; return(View()); }
/// // GET: EmployeeGIs/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EmployeeGI employeeGI = db.EmployeeGIs.Find(id); if (employeeGI == null) { return(HttpNotFound()); } return(View(employeeGI)); }
public ActionResult Create(EmployeeGI tenent) { if (ModelState.IsValid) { if (AddNewTenant(tenent)) { TempData["NewTenent"] = tenent.CustomerMaster; return(RedirectToAction("Index", "Tenant")); } } ViewBag.LGAs = new SelectList(db.CityMasters.Where(c => c.StateId == 1), "City", "City"); ViewBag.StateOfOrigins = new SelectList(db.StateMasters, "State", "State"); return(View(tenent)); }
private bool AddNewTenant(EmployeeGI tenent) { var isSaved = false; try { tenent.CustomerMaster.ContactPerson = tenent.CustomerMaster.ContactPerson = (tenent.First_Name + " " + tenent.Middle_Name + " " + tenent.Surname).Trim(); tenent.DateOfRetirement = DateTime.Now.AddYears(20); tenent.EmployeeCode = (db.EmployeeGIs.Any()) ? (db.EmployeeGIs.Max(e => e.EmployeeCode) + 1) : 1000; var loginUser = new UserMaster() { EmployeeCode = tenent.EmployeeCode, EmailId = "Update Your Mail Id", UserName = tenent.EmployeeCode.ToString(), Password = "******" + tenent.EmployeeCode.ToString(), RoleId = 1, RoleName = "Admin", }; db.UserMasters.Add(loginUser); db.SaveChanges(); tenent.CustomerMaster.LoginUserId = loginUser.UserId; tenent.CustomerMaster.EmployeeGIId = tenent.EmployeeGIId; db.EmployeeGIs.Add(tenent); db.SaveChanges(); tenent.CustomerMaster.EmployeeGIId = tenent.EmployeeGIId; loginUser.CustomerId = tenent.CustomerId; var isImagesSaved = SaveImages(tenent.CustomerMaster); var isConfigSaved = AddSystemConfig(tenent); isSaved = isImagesSaved && isConfigSaved; var rank = db.RankMasters.Where(r => r.CustomerId == tenent.CustomerMaster.CustomerId).FirstOrDefault()?.RankName; tenent.Rank = !string.IsNullOrEmpty(rank) ? rank : string.Empty; db.SaveChanges(); tenent.CustomerMaster.EmployeeGIId = tenent.EmployeeGIId; tenent.CustomerId = tenent.CustomerMaster.CustomerId; loginUser.CustomerId = tenent.CustomerMaster.CustomerId; db.Entry(loginUser).State = EntityState.Modified; db.Entry(tenent.CustomerMaster).State = EntityState.Modified; db.Entry(tenent).State = EntityState.Modified; tenent.CustomerMaster.UserMaster = loginUser; db.SaveChanges(); } catch (Exception ex) { var msg = ex.Message; isSaved = false; } return(isSaved); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var empCode = (from emp in db.EmployeeGIs where emp.EmployeeGIId == id.Value select emp.EmployeeCode).FirstOrDefault(); EmployeeGI tenent = db.EmployeeGIs.Find(empCode); tenent.CustomerMaster = db.CustomerMasters.Find(tenent.CustomerId); if (tenent == null) { return(HttpNotFound()); } ViewBag.LGAs = new SelectList(db.CityMasters.Where(c => c.StateId == 1), "City", "City"); ViewBag.StateOfOrigins = new SelectList(db.StateMasters, "State", "State"); return(View(tenent)); }
public ActionResult DeleteConfirmed(int id) { try { EmployeeGI employeeGI = db.EmployeeGIs.Find(id); db.EmployeeGIs.Remove(employeeGI); db.SaveChanges(); db.SaveChanges(); TempData["successmsg"] = "Record is Successfully Deleted"; TempData["msg"] = ""; } catch (Exception ext) { TempData["successmsg"] = ""; TempData["msg"] = "Please delete Other Information records of this Employee, before General Information deletion"; } return(RedirectToAction("Index")); }
private bool AddSystemConfig(EmployeeGI tenent) { // var path = "E:/MyProjects/AmitSoni-McAutomation/IARTAutomationApp/App_Data/SystemConfig.xlsx"; string filepath = Server.MapPath("~/App_Data/SystemConfig.xlsx"); FileStream fs = System.IO.File.Open(filepath, FileMode.Open, FileAccess.Read); IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(fs); DataSet ds = excelReader.AsDataSet(); fs.Close(); db.RankMasters.AddRange(AddRank(ds.Tables["Rank"].Rows, tenent.CustomerId.Value));// Not reading from excel as data is not avilable in excel. db.CadreMasters.AddRange(AddCadres(ds.Tables["Cadre"].Rows, tenent.CustomerId.Value)); db.ProgrammeMasters.AddRange(AddProgrammeMasters(ds.Tables["Programmes"].Rows, tenent.CustomerId.Value)); db.UnitResearchMasters.AddRange(AddUnitResearchMaster(ds.Tables["Unit - Research"].Rows, tenent.CustomerId.Value)); db.UnitServicesMasters.AddRange(AddUnitServicesMaster(ds.Tables["Unit - Service"].Rows, tenent.CustomerId.Value)); db.StationMasters.AddRange(AddStationOfDeployment(ds.Tables["Station of Deployment"].Rows, tenent.CustomerId.Value)); db.SectionMasters.AddRange(AddSectionMaster(ds.Tables["Section"].Rows, tenent.CustomerId.Value)); db.BankTypeMasters.AddRange(AddTypeOfBank(ds.Tables["Bank Types"].Rows, tenent.CustomerId.Value)); db.BankMasters.AddRange(AddBank(ds.Tables["Bank Names"].Rows, tenent.CustomerId.Value)); db.PFAMasters.AddRange(AddPFAMaster(ds.Tables["PFA"].Rows, tenent.CustomerId.Value)); return(db.SaveChanges() > 0 ? true : false); }
public ActionResult MidLevelEdit([Bind(Include = "EmployeeGIId,EmployeeCode,Rank,File_No,Grade_Level,Step,Cadre,Title,First_Name,Middle_Name,Surname,Sex,DateOfBirth,PlaceOfBirth,Marital_Status,Maiden_Name,Spouse_Name,StateOfOrigin,LGA,Home_Town,Religion,ContactHomeAddress,FirstAppointmentDate,FirstAppointmentLocation,ConfirmationDate,DateOfRetirement,LastPromotionDate,Programmes,Unit_Services,Unit_Research,Section,LeaveDays,Leave_fromDate,Leave_ToDate,EmployeePhoto,EmployeePhotoImage,StationOfDeployment,IsDeleted,CreatedDate")] EmployeeGI employeeGI) { try { if (employeeGI.EmployeePhotoImage != null && employeeGI.EmployeePhotoImage.ContentLength > 0) { var uploadDir = "~/uploads"; var imagePath = Path.Combine(Server.MapPath(uploadDir), employeeGI.EmployeePhotoImage.FileName.ToString()); var imageUrl = Path.Combine(uploadDir, employeeGI.EmployeePhotoImage.FileName.ToString()); employeeGI.EmployeePhoto = employeeGI.EmployeePhotoImage.FileName.ToString(); employeeGI.EmployeePhotoImage.SaveAs(imagePath); } if (employeeGI.Marital_Status != "Married") { employeeGI.Spouse_Name = "N/A"; } employeeGI.Leave_fromDate = DateTime.Now.Date; employeeGI.Leave_ToDate = DateTime.Now.Date; TimeSpan daydiff = Convert.ToDateTime(employeeGI.Leave_ToDate) - Convert.ToDateTime(employeeGI.Leave_fromDate); employeeGI.LeaveDays = daydiff.Days; employeeGI.CreatedDate = DateTime.Now.Date; employeeGI.IsDeleted = false; db.Entry(employeeGI).State = EntityState.Modified; db.SaveChanges(); TempData["successmsg"] = "Record is Successfully Updated"; TempData["msg"] = ""; int empcode = Convert.ToInt32(@Session["employeecode"]); return(RedirectToAction("MidLevelIndex")); } catch (Exception ext) { TempData["successmsg"] = ""; TempData["msg"] = "Record is not Updated,Try again"; } return(RedirectToAction("Index")); }
// GET: EmployeeGIs/Edit/5 public ActionResult MidLevelEdit(int?id) { EmployeeGI employeeGI = db.EmployeeGIs.Find(id); List <SelectListItem> File_Nos = new List <SelectListItem>(); File_Nos.Add(new SelectListItem { Text = "Select", Value = "0" }); for (int i = 1; i <= 200; i++) { //if (i != 9) File_Nos.Add(new SelectListItem { Text = i.ToString(), Value = i.ToString() }); //else // File_Nos.Add(new SelectListItem { Text = i.ToString(), Value = i.ToString(), Selected = true }); } List <SelectListItem> Titles = new List <SelectListItem>(); //Titles.Add(new SelectListItem { Text = "Select", Value = "0" }); Titles.Add(new SelectListItem { Text = "Mr", Value = "0" }); Titles.Add(new SelectListItem { Text = "Mrs", Value = "1" }); Titles.Add(new SelectListItem { Text = "Miss", Value = "2" }); Titles.Add(new SelectListItem { Text = "Dr", Value = "3" }); Titles.Add(new SelectListItem { Text = "Prof", Value = "4" }); ViewBag.Titles = new SelectList(Titles, "Text", "Text"); List <SelectListItem> Steps = new List <SelectListItem>(); Steps.Add(new SelectListItem { Text = "Select", Value = "0" }); for (int i = 1; i <= 15; i++) { Steps.Add(new SelectListItem { Text = i.ToString(), Value = i.ToString() }); } List <SelectListItem> Grades = new List <SelectListItem>(); Grades.Add(new SelectListItem { Text = "Select", Value = "0" }); for (int i = 1; i <= 15; i++) { Grades.Add(new SelectListItem { Text = i.ToString(), Value = i.ToString() }); } //ViewBag.File_No = new SelectList(File_Nos, "Value", "Text", employeeGI.File_No); ViewBag.Steps = new SelectList(Steps, "Value", "Text"); ViewBag.Grade_Levels = new SelectList(Grades, "Value", "Text"); //ViewBag.Rank = new SelectList(db.RankMasters, "RankName", "RankName", employeeGI.Rank); //ViewBag.LGA = new SelectList(db.CityMasters, "City", "City", employeeGI.LGA); //ViewBag.StateOfOrigin = new SelectList(db.StateMasters, "State", "State", employeeGI.StateOfOrigin); //ViewBag.cadre = new SelectList(db.CadreMasters, "CadreName", "CadreName"); //ViewBag.Programmes = new SelectList(db.ProgrammeMasters, "ProgrammeName", "ProgrammeName"); //ViewBag.Unit_Research = new SelectList(db.UnitResearchMasters, "UnitResearchName", "UnitResearchName"); //ViewBag.Unit_Services = new SelectList(db.UnitServicesMasters, "UnitServicesName", "UnitServicesName"); //ViewBag.StationOfDeployment = new SelectList(db.StationMasters, "StationName", "StationName"); //ViewBag.Section = new SelectList(db.SectionMasters, "SectionName", "SectionName"); ViewBag.File_Noa = new SelectList(File_Nos, "Value", "Text"); /////// ViewBag.Ranks = new SelectList(db.RankMasters, "RankName", "RankName"); ViewBag.LGAs = new SelectList(db.CityMasters, "City", "City"); ViewBag.StateOfOrigins = new SelectList(db.StateMasters, "State", "State"); ViewBag.cadres = new SelectList(db.CadreMasters, "CadreName", "CadreName"); ViewBag.Programmess = new SelectList(db.ProgrammeMasters, "ProgrammeName", "ProgrammeName"); ViewBag.Unit_Researchs = new SelectList(db.UnitResearchMasters, "UnitResearchName", "UnitResearchName"); ViewBag.Unit_Servicess = new SelectList(db.UnitServicesMasters, "UnitServicesName", "UnitServicesName"); ViewBag.StationOfDeployments = new SelectList(db.StationMasters, "StationName", "StationName"); ViewBag.Sections = new SelectList(db.SectionMasters, "SectionName", "SectionName"); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (employeeGI == null) { return(HttpNotFound()); } ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "EmployeeCode", employeeGI.EmployeeCode); return(View(employeeGI)); }
//[ValidateAntiForgeryToken] public ActionResult MidLevelCreate([Bind(Include = "EmployeeGIId,EmployeeCode,Rank,File_No,Grade_Level,Step,Cadre,Title,First_Name,Middle_Name,Surname,Sex,DateOfBirth,PlaceOfBirth,Marital_Status,Maiden_Name,Spouse_Name,StateOfOrigin,LGA,Home_Town,Religion,ContactHomeAddress,FirstAppointmentDate,FirstAppointmentLocation,ConfirmationDate,DateOfRetirement,LastPromotionDate,Programmes,Unit_Services,Unit_Research,Section,LeaveDays,Leave_fromDate,Leave_ToDate,,EmployeePhotoImage,StationOfDeployment,IsDeleted,CreatedDate")] EmployeeGI employeeGI) { try { if (employeeGI.Marital_Status != "Married") { employeeGI.Spouse_Name = "N/A"; } var list = new List <int>(); for (int i = 1; i <= 111; i++) { list.Add(i); } List <SelectListItem> File_Nos = new List <SelectListItem>(); File_Nos.Add(new SelectListItem { Text = "Select", Value = "0" }); for (int i = 1; i <= 111; i++) { File_Nos.Add(new SelectListItem { Text = i.ToString(), Value = i.ToString() }); } ViewBag.File_No = new SelectList(File_Nos, "Value", "Text"); employeeGI.CreatedDate = DateTime.Now.Date; employeeGI.IsDeleted = false; ViewBag.Ranks = new SelectList(db.RankMasters, "RankName", "RankName"); ViewBag.LGAs = new SelectList(db.CityMasters, "City", "City"); ViewBag.StateOfOrigins = new SelectList(db.StateMasters, "State", "State"); ViewBag.cadres = new SelectList(db.CadreMasters, "CadreName", "CadreName"); ViewBag.Programmess = new SelectList(db.ProgrammeMasters, "ProgrammeName", "ProgrammeName"); ViewBag.Unit_Researchs = new SelectList(db.UnitResearchMasters, "UnitResearchName", "UnitResearchName"); ViewBag.Unit_Servicess = new SelectList(db.UnitServicesMasters, "UnitServicesName", "UnitServicesName"); ViewBag.StationOfDeployments = new SelectList(db.StationMasters, "StationName", "StationName"); ViewBag.Sections = new SelectList(db.SectionMasters, "SectionName", "SectionName"); //if (ModelState.IsValid) //{ if (employeeGI.EmployeePhotoImage.FileName != null && employeeGI.EmployeePhotoImage.ContentLength > 0) { var uploadDir = "~/uploads"; var imagePath = Path.Combine(Server.MapPath(uploadDir), employeeGI.EmployeePhotoImage.FileName.ToString()); var imageUrl = Path.Combine(uploadDir, employeeGI.EmployeePhotoImage.FileName.ToString()); employeeGI.EmployeePhoto = employeeGI.EmployeePhotoImage.FileName.ToString(); employeeGI.EmployeePhotoImage.SaveAs(imagePath); } employeeGI.File_No = employeeGI.File_No; employeeGI.EmployeeGIId = employeeGI.EmployeeCode; db.EmployeeGIs.Add(employeeGI); db.SaveChanges(); TempData["successmsg"] = "Record is Successfully added"; TempData["msg"] = ""; return(RedirectToAction("MidLevelIndex")); //int empcode = Convert.ToInt32(@Session["employeecode"]); //DateTime dttoday = DateTime.Now.Date; //var Role = (from a in db.UserMasters where a.EmployeeCode == empcode select a.RoleId).FirstOrDefault(); //var RoleName = (from b in db.RoleMasters where b.RoleId == Role select b.RoleName).FirstOrDefault(); //if (RoleName == "Admin" || RoleName == "Super Admin") //{ // return RedirectToAction("Index"); //} //else if (RoleName == "Mid Level Admin") //{ // return RedirectToAction("MidLevelIndex"); //} //else if (RoleName == "Low Level Admin") //{ // return RedirectToAction("MidLevelIndex"); //} //else //{ // return RedirectToAction("UserIndex"); //} } catch (Exception ext) { TempData["successmsg"] = ""; TempData["msg"] = "Record is not added,Try again"; } ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "EmployeeCode", employeeGI.EmployeeCode); return(View(employeeGI)); }
// GET: EmployeeGIs/Create public ActionResult MidLevelCreate() { try { EmployeeGI empgi = new EmployeeGI(); //empgi.DateOfBirth = DateTime.Now.Date.AddYears(-18).Date; ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "EmployeeCode"); List <SelectListItem> File_Nos = new List <SelectListItem>(); File_Nos.Add(new SelectListItem { Text = "Select", Value = "0" }); for (int i = 1; i <= 111; i++) { File_Nos.Add(new SelectListItem { Text = i.ToString(), Value = i.ToString() }); } ViewBag.File_Nos = new SelectList(File_Nos, "Value", "Text"); /////// ViewBag.Ranks = new SelectList(db.RankMasters, "RankName", "RankName"); ViewBag.LGAs = new SelectList(db.CityMasters, "City", "City"); ViewBag.StateOfOrigins = new SelectList(db.StateMasters, "State", "State"); ViewBag.cadres = new SelectList(db.CadreMasters, "CadreName", "CadreName"); ViewBag.Programmess = new SelectList(db.ProgrammeMasters, "ProgrammeName", "ProgrammeName"); ViewBag.Unit_Researchs = new SelectList(db.UnitResearchMasters, "UnitResearchName", "UnitResearchName"); ViewBag.Unit_Servicess = new SelectList(db.UnitServicesMasters, "UnitServicesName", "UnitServicesName"); ViewBag.StationOfDeployments = new SelectList(db.StationMasters, "StationName", "StationName"); ViewBag.Sections = new SelectList(db.SectionMasters, "SectionName", "SectionName"); //List<RankMaster> Ranklist = new List<RankMaster>(); //Ranklist = (from a in db.RankMasters select a).ToList(); ////ViewBag.CountryList = CountryList; //ViewBag.Rank = new SelectList(Ranklist, "RankId", "RankName"); /////// //List<CityMaster> CityList = new List<CityMaster>(); //CityList = (from a in db.CityMasters select a).ToList(); ////ViewBag.CountryList = CountryList; //ViewBag.LGA = new SelectList(CityList, "Id", "City"); /////// //List<StateMaster> StateList = new List<StateMaster>(); //StateList = (from State in db.StateMasters select State).ToList(); ////ViewBag.CountryList = CountryList; //ViewBag.StateOfOrigin = new SelectList(StateList, "Id", "State"); /////// //List<CadreMaster> cadrelist = new List<CadreMaster>(); //cadrelist = (from a in db.CadreMasters select a).ToList(); ////ViewBag.CountryList = CountryList; //ViewBag.cadre = new SelectList(cadrelist, "CadreId", "CadreName"); /////// //List<ProgrammeMaster> Programlist = new List<ProgrammeMaster>(); //Programlist = (from a in db.ProgrammeMasters select a).ToList(); ////ViewBag.CountryList = CountryList; //ViewBag.Programmes = new SelectList(Programlist, "ProgrammeId", "ProgrammeName"); /////// //List<UnitResearchMaster> UnitResearchlist = new List<UnitResearchMaster>(); //UnitResearchlist = (from a in db.UnitResearchMasters select a).ToList(); ////ViewBag.CountryList = CountryList; //ViewBag.Unit_Research = new SelectList(UnitResearchlist, "UnitResearchId", "UnitResearchName"); /////// //List<UnitServicesMaster> UnitServicelist = new List<UnitServicesMaster>(); //UnitServicelist = (from a in db.UnitServicesMasters select a).ToList(); ////ViewBag.CountryList = CountryList; //ViewBag.Unit_Services = new SelectList(UnitServicelist, "UnitServicesId", "UnitServicesName"); /////// //List<StationMaster> Stationlist = new List<StationMaster>(); //Stationlist = (from a in db.StationMasters select a).ToList(); ////ViewBag.CountryList = CountryList; //ViewBag.StationOfDeployment = new SelectList(Stationlist, "StationId", "StationName"); /////// //List<SectionMaster> Sectionlist = new List<SectionMaster>(); //Sectionlist = (from a in db.SectionMasters select a).ToList(); ////ViewBag.CountryList = CountryList; //ViewBag.Section = new SelectList(Sectionlist, "SectionId", "SectionName"); return(View(empgi)); } catch (Exception ext) { return(null); } }
public JsonResult Edit(EmployeeAI obj, List <EmpAIAssociation> ObjAssociation, List <EmpAIConference> ObjConferenece) { int insertedRecords = 0; try { var id = (from a in db.EmployeeAIs where a.EmployeeCode == obj.EmployeeCode select a.EmployeeAIId).FirstOrDefault(); var idgI = (from a in db.EmployeeGIs where a.EmployeeCode == obj.EmployeeCode select a.EmployeeGIId).FirstOrDefault(); EmployeeGI objempGi = db.EmployeeGIs.Find(idgI); EmployeeAI objdest = db.EmployeeAIs.Find(id); objdest.EmployeeCode = obj.EmployeeCode; objdest.InstitutionAttended1 = obj.InstitutionAttended1; objdest.InstitutionAttended2 = obj.InstitutionAttended2; objdest.InstitutionAttended3 = obj.InstitutionAttended3; objdest.Qualification1 = obj.Qualification1; objdest.Qualification2 = obj.Qualification2; objdest.Qualification3 = obj.Qualification3; objdest.YearOfGraduation1 = obj.YearOfGraduation1; objdest.YearOfGraduation2 = obj.YearOfGraduation2; objdest.YearOfGraduation3 = obj.YearOfGraduation3; objdest.CreatedDate = objdest.CreatedDate; objdest.IsDeleted = objdest.IsDeleted; objdest.ConferenceAttendedDate = DateTime.Now.Date; objdest.ConferenceAttendedName = "NA"; objdest.ConferenceAttendedTitle = "NA"; objdest.ProfessionalAssociationsDate = DateTime.Now.Date; objdest.ProfessionalAssociationsIdNo = "1"; objdest.ProfessionalAssociationsTitle = "NA"; objdest.EmployeeGI = objempGi; db.SaveChanges(); int i = (from a in db.EmployeeAIs where a.EmployeeCode == obj.EmployeeCode select a).Count(); if (i == 0) { //entities.EmployeeAIs.Add(obj); //Check for NULL. if (ObjAssociation == null) { ObjAssociation = new List <EmpAIAssociation>(); } } //Loop and insert records. foreach (EmpAIAssociation item in ObjAssociation) { EmpAIAssociation Existed_Emp = db.EmpAIAssociations.Find(item.AssociationsId); Existed_Emp.IDnumber = item.IDnumber; Existed_Emp.Title = item.Title; Existed_Emp.AttendedDate = item.AttendedDate; Existed_Emp.IsDeleted = false; } db.SaveChanges(); if (ObjConferenece == null) { ObjConferenece = new List <EmpAIConference>(); } //Loop and insert records. foreach (EmpAIConference item in ObjConferenece) { EmpAIConference Existed_Emp = db.EmpAIConferences.Find(item.ConferenceId); Existed_Emp.Name = item.Name; Existed_Emp.Title = item.Title; Existed_Emp.AttendedDate = item.AttendedDate; Existed_Emp.IsDeleted = false; } db.SaveChanges(); insertedRecords = id; } catch (Exception ext) { } return(Json(insertedRecords)); }
public ActionResult Edit([Bind(Include = "CustomerId,EmployeeGIId,EmployeeCode,Rank,File_No,Grade_Level,Step,Cadre,Title,First_Name,Middle_Name,Surname,Sex,DateOfBirth,PlaceOfBirth,Marital_Status,Maiden_Name,Spouse_Name,StateOfOrigin,LGA,Home_Town,Religion,ContactHomeAddress,FirstAppointmentDate,FirstAppointmentLocation,ConfirmationDate,DateOfRetirement,LastPromotionDate,Programmes,Unit_Services,Unit_Research,Section,LeaveDays,Leave_fromDate,Leave_ToDate,EmployeePhoto,EmployeePhotoImage,StationOfDeployment,IsDeleted,CreatedDate")] EmployeeGI employeeGI) { try { //if (ModelState.IsValid) //{ if (employeeGI.EmployeePhotoImage != null && employeeGI.EmployeePhotoImage.ContentLength > 0) { var uploadDir = "~/uploads"; var imagePath = Path.Combine(Server.MapPath(uploadDir), employeeGI.EmployeePhotoImage.FileName.ToString()); var imageUrl = Path.Combine(uploadDir, employeeGI.EmployeePhotoImage.FileName.ToString()); employeeGI.EmployeePhoto = employeeGI.EmployeePhotoImage.FileName.ToString(); employeeGI.EmployeePhotoImage.SaveAs(imagePath); } if (employeeGI.Marital_Status != "Married") { employeeGI.Spouse_Name = "N/A"; } employeeGI.Leave_fromDate = DateTime.Now.Date; employeeGI.Leave_ToDate = DateTime.Now.Date; TimeSpan daydiff = Convert.ToDateTime(employeeGI.Leave_ToDate) - Convert.ToDateTime(employeeGI.Leave_fromDate); employeeGI.LeaveDays = daydiff.Days; employeeGI.CreatedDate = DateTime.Now.Date; employeeGI.IsDeleted = false; db.Entry(employeeGI).State = EntityState.Modified; db.SaveChanges(); TempData["successmsg"] = "Record is Successfully Updated"; TempData["msg"] = ""; int empcode = Convert.ToInt32(@Session["employeecode"]); DateTime dttoday = DateTime.Now.Date; var Role = (from a in db.UserMasters where a.EmployeeCode == empcode select a.RoleId).FirstOrDefault(); var RoleName = (from b in db.RoleMasters where b.RoleId == Role select b.RoleName).FirstOrDefault(); //if (RoleName == "Admin" || RoleName == "Super Admin") //{ return(RedirectToAction("Index")); //} //else if (RoleName == "Mid Level Admin") //{ // return RedirectToAction("MidLevelIndex"); //} //else if (RoleName == "Low Level Admin") //{ // return RedirectToAction("MidLevelIndex"); //} //else //{ // return RedirectToAction("UserIndex"); //} } catch (Exception ext) { TempData["successmsg"] = ""; TempData["msg"] = "Record is not Updated,Try again"; } //} //ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "EmployeeCode", employeeGI.EmployeeCode); return(RedirectToAction("Index")); }