public ActionResult AdminLogin(string returnUrl, FormCollection fc) { if (!string.IsNullOrEmpty(fc["EmployeeCode"]) && !string.IsNullOrEmpty(fc["Password"])) { var sa = db.SuperAdmins.Find(1); if (sa.LoginName.Equals(fc["EmployeeCode"]) && sa.Password.Equals(fc["Password"])) { FormsAuthentication.SetAuthCookie(sa.LoginName, true); return(RedirectToAction("Dashboard", "SuperAdmin")); } int empCode = 0; int.TryParse(fc["EmployeeCode"], out empCode); string password = fc["Password"]; UserMaster user = db.UserMasters.Where(u => u.EmployeeCode == empCode && u.Password.Equals(password)).FirstOrDefault(); if (user != null) { TempData["wel"] = "Your Login is Successful"; { var userName = user.EmployeeCode.ToString(); var empdetail = (from a in db.EmployeeGIs where a.EmployeeCode == user.EmployeeCode select new { empic = a.EmployeePhoto, empname = a.First_Name }).FirstOrDefault(); Session["name"] = empdetail.empname; Session["employeecode"] = user.EmployeeCode.ToString(); Session["User"] = user; Session.Timeout = 60000; string roletext = (from a in db.RoleMasters where a.RoleId == user.RoleId select a.RoleName).FirstOrDefault(); var role = (from a in db.UserMasters where a.EmployeeCode == user.EmployeeCode select a.RoleId).FirstOrDefault(); var userType = (from a in db.RoleMasters where a.RoleId == role select a.RoleName).FirstOrDefault(); Session["Role"] = userType; try { if (userType.Contains("Admin")) { EmployeeAttendance attendence = new EmployeeAttendance(); attendence.EmployeeCode = user.EmployeeCode; attendence.OnDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()); string timelogin = String.Format("{0:T}", DateTime.Now); attendence.LoginTime = Convert.ToDateTime(timelogin); // "4:05 PM"; attendence.LogoutTime = Convert.ToDateTime(timelogin); db.EmployeeAttendances.Add(attendence); db.SaveChanges(); } } catch { } FormsAuthentication.SetAuthCookie(userName, true); return(RedirectToAction("index", "Home")); } } else { TempData["wel"] = "Invalid UserName or Password"; return(RedirectToAction("index", "Login")); } } // else { TempData["wel"] = "Pls Enter UserName and Password"; return(RedirectToAction("index", "Login")); } }
public ActionResult Create([Bind(Include = "ClassNumber, ClassName, ClassStatus")] ClassMaster classMaster) { ClassMaster cls = new ClassMaster(); if (ModelState.IsValid) { cls.EmployeeID = Convert.ToInt32(@Session["employeecode"]); cls.ClassName = classMaster.ClassName; cls.ClassNumber = classMaster.ClassNumber; cls.ClassStatus = classMaster.ClassStatus; cls.CreatedDate = DateTime.Now; db.ClassMasters.Add(cls); db.SaveChanges(); } return(RedirectToAction("Create")); }
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)); }
public ActionResult Create([Bind(Include = "CustomerId,StoreNumber,StoreName,StoreStatus,StoreDesc,StoreImgName")] StoreMaster storeMaster, HttpPostedFileBase StoreImgName) { StoreMaster s = new StoreMaster(); ViewBag.Status = new SelectList(db.StatusMasters, "RecordId", "StatusName"); if (StoreImgName != null) { string path = Server.MapPath("~/Uploads/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } System.Drawing.Image img = System.Drawing.Image.FromStream(StoreImgName.InputStream); int height = img.Height; int width = img.Width; decimal size = Math.Round(((decimal)StoreImgName.ContentLength / (decimal)1024), 2); if (width == 300 || height == 250) { s.EmployeeID = Convert.ToInt32(@Session["employeecode"]); s.CreatedDate = DateTime.Now; s.StoreName = storeMaster.StoreName; s.StoreNumber = storeMaster.StoreNumber; s.StoreStatus = storeMaster.StoreStatus; s.StoreImgName = (storeMaster.StoreName + "_" + Path.GetFileName(StoreImgName.FileName)); s.StoreDesc = storeMaster.StoreDesc; db.StoreMasters.Add(s); db.SaveChanges(); StoreImgName.SaveAs(path + (storeMaster.StoreName + "_" + Path.GetFileName(StoreImgName.FileName))); return(RedirectToAction("Create")); } else { ViewBag.ImgMessage = string.Format("Please Select Image With resolution of 300px X 250px .\\nCurrent resolution is Width: {0}px and Heigth: {1}px", width.ToString(), height.ToString()); return(View()); } } else { ViewBag.ImgMessage = string.Format("Please select image"); return(View()); } }
public ActionResult Create([Bind(Include = "CustomerId,UOMName, UOMCode, UOMDesc, UOMStatus")] UomMaster uomMaster) { UomMaster uom = new UomMaster(); { ModelState.Remove("EmployeeID"); if (ModelState.IsValid) { uom.EmployeeID = Convert.ToInt32(@Session["employeecode"]); } uom.UOMName = uomMaster.UOMName; uom.UOMDesc = uomMaster.UOMDesc; uom.UOMStatus = uomMaster.UOMStatus; uom.UOMCode = uomMaster.UOMCode; uom.CreatedDate = DateTime.Now; db.UomMasters.Add(uom); db.SaveChanges(); } return(RedirectToAction("Create")); }
//[ValidateAntiForgeryToken] public ActionResult UserCreate([Bind(Include = "CustomerId,LeaveAccId,EmployeeCode,LeaveTypeName,LeaveFromDate,LeaveToDate,NoOfDays,AppDate,IsApproved,IsDeleted,CreatedDate")] LeaveApplication leaveApplication) { List <LeaveTypeMaster> LeaveTypeklist = new List <LeaveTypeMaster>(); LeaveTypeklist = (from a in db.LeaveTypeMasters select a).ToList(); //ViewBag.CountryList = CountryList; ViewBag.LeaveTypeName = new SelectList(LeaveTypeklist, "LeaveTypeId", "LeaveTypeName"); if (ModelState.IsValid) { int lt = Convert.ToInt32(leaveApplication.LeaveTypeName); var leavetype = (from a in db.LeaveTypeMasters where a.LeaveTypeId == lt select a.LeaveTypeName).FirstOrDefault(); leaveApplication.LeaveTypeName = leavetype; var inprocess = (from a in db.LeaveApplications where a.Status == "Pending" && a.EmployeeCode == leaveApplication.EmployeeCode select a).Count(); if (inprocess == 0) { leaveApplication.Status = "Pending"; int count = (from a in db.LeaveLedgers where a.EmployeeCode == leaveApplication.EmployeeCode && a.LeaveType == leaveApplication.LeaveTypeName select a.BalanceLeaves).Count(); var balanceLeave = (from a in db.LeaveLedgers where a.EmployeeCode == leaveApplication.EmployeeCode && a.LeaveType == leaveApplication.LeaveTypeName && a.BalanceLeaves >= leaveApplication.NoOfDays select a.BalanceLeaves).FirstOrDefault(); if ((balanceLeave > 0) || (count == 0)) { db.LeaveApplications.Add(leaveApplication); db.SaveChanges(); TempData["msg"] = "<script>alert('Your Leave Application is Submitted');</script>"; return(RedirectToAction("UserIndex")); } else { TempData["msg"] = "<script>alert('No Leaves in Balance');</script>"; return(View(leaveApplication)); } } else { TempData["msg"] = "<script>alert('Your Application is already in process');</script>"; } } return(View(leaveApplication)); }
public ActionResult Create([Bind(Include = "CustomerId,OrderNo, VendorId, ItemId,ItemQunt,ItemDesc,ItemTax,DeliLoc,Terms")] PurchaseOrder porder) { PurchaseOrder po = new PurchaseOrder(); ModelState.Remove("EmployeeID"); if (ModelState.IsValid) { po.OrderNo = porder.OrderNo; po.VendorId = porder.VendorId; po.ItemId = porder.ItemId; po.ItemQunt = porder.ItemQunt; po.ItemDesc = porder.ItemDesc; po.ItemTax = porder.ItemTax; po.DeliLoc = porder.DeliLoc; po.Terms = porder.Terms; po.EmployeeID = Convert.ToInt32(@Session["employeecode"]); po.CreatedDate = DateTime.Now; db.PurchaseOrders.Add(po); db.SaveChanges(); } return(RedirectToAction("Create")); }
public JsonResult InsertCriv(List <CrivVoucher> criv) { using (db) { if (criv == null) { criv = new List <CrivVoucher>(); } //Loop and insert records. foreach (CrivVoucher c in criv) { CrivVoucher cr = new CrivVoucher(); cr.CRIVVoucherId = c.CRIVVoucherId; cr.EmployeeID = Convert.ToInt32(@Session["employeecode"]); cr.DepartmentId = c.DepartmentId; cr.Store = c.Store; cr.DateIns = c.DateIns; cr.Item = c.Item; cr.Class = c.Class; cr.Qunatity = c.Qunatity; cr.Uom = c.Uom; cr.Rate = c.Rate; cr.TotalValue = c.TotalValue; cr.BatchDetail = c.BatchDetail; cr.RequisitionOfficer = c.RequisitionOfficer; cr.RecivingPerson = c.RecivingPerson; cr.Remarks = c.Remarks; cr.CreatedDate = DateTime.Now; cr.TotalCost = c.TotalCost; cr.AmtWord = c.AmtWord; cr.Name1 = c.Name1; cr.Fac1 = c.Fac1; cr.Sign1 = c.Sign1; cr.Date1 = c.Date1; cr.Sign2 = c.Sign2; cr.Date2 = c.Date2; cr.Name3 = c.Name3; cr.Fac3 = c.Fac3; cr.Date3 = c.Date3; db.CrivVouchers.Add(cr); } int insertedRecords = db.SaveChanges(); insertedRecords = 0; return(Json(insertedRecords)); } }
public ActionResult MidLevelCreate([Bind(Include = "CustomerId,EmployeeMIId,EmployeeCode,NhisNo,NhisProvider,BloodGroup,BloodGenotype,CreatedDate,IsDeleted")] EmployeeMI employeeMI) { try { if (ModelState.IsValid) { int empidcount = (from a in db.EmployeeMIs where a.EmployeeCode == employeeMI.EmployeeCode select a).Count(); if (empidcount == 0) { employeeMI.IsDeleted = false; employeeMI.CreatedDate = DateTime.Now.Date; db.EmployeeMIs.Add(employeeMI); db.SaveChanges(); TempData["successmsg"] = "Record is Successfully Added"; 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(); return(RedirectToAction("MidLevelIndex")); //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", employeeMI.EmployeeCode); return(View(employeeMI)); }
public JsonResult InsertCustomers(EmployeeAI obj, List <EmpAIAssociation> ObjAssociation, List <EmpAIConference> ObjConferenece) { int insertedRecords = 0; try { using (IARTDBNEWEntities entities = new IARTDBNEWEntities()) { int i = (from a in entities.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) { entities.EmpAIAssociations.Add(item); } if (ObjConferenece == null) { ObjConferenece = new List <EmpAIConference>(); } //Loop and insert records. foreach (EmpAIConference item in ObjConferenece) { entities.EmpAIConferences.Add(item); } insertedRecords = entities.SaveChanges(); } } catch (Exception ext) { } return(Json(insertedRecords)); }
public JsonResult InsertStoreRecipt(List <StoreReciptVoucher> criv) { using (db) { if (criv == null) { criv = new List <StoreReciptVoucher>(); } //Loop and insert records. foreach (StoreReciptVoucher c in criv) { StoreReciptVoucher cr = new StoreReciptVoucher(); cr.VoucherId = c.VoucherId; cr.EmployeeID = Convert.ToInt32(@Session["employeecode"]); cr.DepartmentId = c.DepartmentId; cr.Store = c.Store; cr.DateIns = c.DateIns; cr.Item = c.Item; cr.Vendor = c.Vendor; cr.Qunatity = c.Qunatity; cr.Uom = c.Uom; cr.Rate = c.Rate; cr.TotalValue = c.TotalValue; cr.BatchDetail = c.BatchDetail; cr.StoreOfficer = c.StoreOfficer; cr.RecivingPerson = c.RecivingPerson; cr.Remark = c.Remark; cr.CreatedDate = DateTime.Now; cr.Date1 = c.Date1; cr.Sign1 = c.Sign1; cr.Date2 = c.Date2; cr.Sign2 = c.Sign2; cr.Date3 = c.Date3; cr.Sign3 = c.Sign3; cr.ReceviedFrom = c.ReceviedFrom; db.StoreReciptVouchers.Add(cr); } int insertedRecords = db.SaveChanges(); insertedRecords = 0; return(Json(insertedRecords)); } }
public ActionResult Create([Bind(Include = "CustomerId,EmployeePIId,EmployeeCode,EmpEmailId,PermanentAddress,MobileNo,EmailIdKin,KinName,AddressNextOfKin,StateNextOfKin,LGAextOfKin,Relation,PhoneNoNextOfKin,NameOfStaffBenificiary,PhoneOfStaffBenificiary,AddressOfStaffBenificiary,EmployeeStatus,CreatedDate,IsDeleted")] EmployeePI employeePI) { var user = (UserMaster)Session["User"]; List <CityMaster> CityList = new List <CityMaster>(); CityList = (from CityName in db.CityMasters select CityName).ToList(); ViewBag.LGAextOfKins = new SelectList(CityList, "City", "City"); List <StateMaster> StateList = new List <StateMaster>(); StateList = (from State in db.StateMasters select State).ToList(); ViewBag.StateNextOfKins = new SelectList(StateList, "State", "State"); ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "EmployeeCode"); var isAlready = (from a in db.EmployeePIs where a.EmployeeCode == employeePI.EmployeeCode select a.EmployeeCode).Count(); if (isAlready == 0) { try { if (ModelState.IsValid) { int empidcount = (from a in db.EmployeePIs where a.EmployeeCode == employeePI.EmployeeCode select a).Count(); if (empidcount == 0) { int DuplicateEmailMobile = (from a in db.EmployeePIs where a.EmpEmailId == employeePI.EmpEmailId && a.MobileNo == employeePI.MobileNo select a).ToList().Count(); if (DuplicateEmailMobile == 0) { employeePI.CreatedDate = DateTime.Now.Date; db.EmployeePIs.Add(employeePI); db.SaveChanges(); TempData["successmsg"] = "Record is Successfully Added"; 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")); } } else { TempData["msg"] = "Email Id or Mobile No. is already exist"; return(View(employeePI)); } } } } catch (Exception ext) { TempData["successmsg"] = ""; TempData["msg"] = "Record is not Added,Please try again"; } ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "EmployeeCode", employeePI.EmployeeCode); return(View(employeePI)); } else { TempData["successmsg"] = ""; TempData["msg"] = "This Record is Already Exist"; return(View(employeePI)); } }
public ActionResult Create([Bind(Include = "CustomerId,StoreId, ClassId, ItemName,ItemCat,UomId,VendorId,ItemRate,ItemTax,StatusId,ItemDesc")] ItemMaster item, HttpPostedFileBase ItemImage) { ItemMaster i = new ItemMaster(); ModelState.Remove("ItemImage"); if (ModelState.IsValid) { if (ItemImage != null) { string path = Server.MapPath("~/Uploads/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } System.Drawing.Image img = System.Drawing.Image.FromStream(ItemImage.InputStream); int height = img.Height; int width = img.Width; decimal size = Math.Round(((decimal)ItemImage.ContentLength / (decimal)1024), 2); if (width == 300 || height == 250) { i.EmployeeID = Convert.ToInt32(@Session["employeecode"]); i.StoreId = item.StoreId; i.ClassId = item.ClassId; i.ItemName = item.ItemName; i.ItemCat = item.ItemCat; i.UomId = item.UomId; i.VendorId = item.VendorId; i.ItemRate = item.ItemRate; i.ItemTax = item.ItemTax; i.StatusId = item.StatusId; i.ItemDesc = item.ItemDesc; i.ItemImage = (item.ItemName + "_" + Path.GetFileName(ItemImage.FileName)); i.CreatedDate = DateTime.Now; db.ItemMasters.Add(i); db.SaveChanges(); ItemImage.SaveAs(path + (item.ItemName + "_" + Path.GetFileName(ItemImage.FileName))); return(RedirectToAction("Create")); } else { ViewBag.Store = new SelectList(GetStore(), "Value", "Text"); ViewBag.Class = new SelectList(GetClass(), "Value", "Text"); ViewBag.Uom = new SelectList(GetUom(), "Value", "Text"); ViewBag.Vendor = new SelectList(GetVendor(), "Value", "Text"); ViewBag.Status = new SelectList(GetStatus(), "Value", "Text"); ViewBag.ImgMessage = string.Format("Please Select Image With resolution of 300px X 250px .\\nCurrent resolution is Width: {0}px and Heigth: {1}px", width.ToString(), height.ToString()); return(View()); } } else { ViewBag.Store = new SelectList(GetStore(), "Value", "Text"); ViewBag.Class = new SelectList(GetClass(), "Value", "Text"); ViewBag.Uom = new SelectList(GetUom(), "Value", "Text"); ViewBag.Vendor = new SelectList(GetVendor(), "Value", "Text"); ViewBag.Status = new SelectList(GetStatus(), "Value", "Text"); ViewBag.ImgMessage = string.Format("Please select image"); return(View()); } } return(RedirectToAction("Create")); }
//[ValidateAntiForgeryToken] public ActionResult Create([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) { var isAlready = (from a in db.EmployeeGIs where a.EmployeeCode == employeeGI.EmployeeCode select a.EmployeeCode).Count(); if (isAlready == 0) { try { if (employeeGI.Marital_Status != "Married") { employeeGI.Spouse_Name = "N/A"; } 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 (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); } var user = (UserMaster)Session["User"]; employeeGI.File_No = employeeGI.File_No; employeeGI.EmployeeGIId = employeeGI.EmployeeCode; employeeGI.CustomerId = user.CustomerId; db.EmployeeGIs.Add(employeeGI); db.SaveChanges(); TempData["successmsg"] = "Record is Successfully added"; 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(); return(RedirectToAction("Index")); } 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)); } else { TempData["successmsg"] = ""; TempData["msg"] = "This Employee Record is already exist"; return(View(employeeGI)); } }
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)); }