public ActionResult Create([Bind(Include="EmpID,EmpNo,EmpName,DesigID,JobID,Gender,ShiftID,LocID,TypeID,GradeID,SecID,CardNo,FpID,PinCode,NicNo,FatherName,BloodGroup,BirthDate,MarStatus,JoinDate,ValidDate,IssueDate,ResignDate,HomeAdd,ProcessAtt,ProcessIn,Status,PhoneNo,Remarks,Email,CellNo,CrewID,FlagFP,FlagFace,FlagCard,EmpImageID,HasOT")] Emp emp) { string empNo = ""; int cardno = Convert.ToInt32(emp.CardNo); emp.CardNo = cardno.ToString("0000000000"); if (string.IsNullOrEmpty(emp.EmpNo)) ModelState.AddModelError("EmpNo", "Emp No is required!"); if (string.IsNullOrEmpty(emp.EmpName)) ModelState.AddModelError("EmpName", "Name is required!"); if (emp.EmpNo != null) { if (emp.EmpNo.Length > 15) ModelState.AddModelError("EmpNo", "String length exceeds!"); if (db.Emps.Where(aa => aa.EmpNo.ToUpper() == emp.EmpNo.ToUpper()).Count() > 0 ) ModelState.AddModelError("EmpNo", "Emp No should be unique!"); } if (emp.CardNo != null) { if (db.Emps.Where(aa => aa.CardNo == emp.CardNo).Count() > 0) if(emp.CardNo!="0000000000") ModelState.AddModelError("CardNo", "Card No should be unique!"); if (emp.CardNo.Length > 10) ModelState.AddModelError("CardNo", "String length exceeds!"); } if (emp.EmpName != null) { if (emp.EmpName.Length > 40) ModelState.AddModelError("EmpName", "String length exceeds!"); } if(emp.SecID== null) ModelState.AddModelError("SecID", "Please Specify section!"); if (emp.TypeID == null) ModelState.AddModelError("TypeID", "Please Specify Type!"); if (emp.GradeID == null) ModelState.AddModelError("GradeID", "Please Specify Grade!"); if (ModelState.IsValid) { emp.ProcessAtt = true; emp.ProcessIn = true; emp.EmpNo = emp.EmpNo.ToUpper(); empNo = emp.EmpNo; emp.FpID = emp.EmpID; db.Emps.Add(emp); db.SaveChanges(); int _userID = Convert.ToInt32(Session["LogedUserID"].ToString()); HelperClass.MyHelper.SaveAuditLog(_userID, (byte)MyEnums.FormName.Employee, (byte)MyEnums.Operation.Add, DateTime.Now); HttpPostedFileBase file = Request.Files["ImageData"]; if (file != null) { ImageConversion _Image = new ImageConversion(); int imageID = _Image.UploadImageInDataBase(file, emp.EmpNo); if (imageID!=0) { using (var ctx = new TAS2013Entities()) { var _emp = ctx.Emps.Where(aa => aa.EmpNo == empNo).ToList(); if (_emp.Count > 0) { _emp.FirstOrDefault().EmpImageID = imageID; ctx.SaveChanges(); ctx.Dispose(); } } } else { } } return RedirectToAction("Index"); } var _wings = new List<Division>(); using (TAS2013Entities context = new TAS2013Entities()) { _wings = context.Divisions.ToList(); ViewBag.Wing = new SelectList(_wings.OrderBy(s=>s.DivisionName), "WingID", "WingName"); User LoggedInUser = Session["LoggedUser"] as User; ViewBag.CrewID = new SelectList(db.Crews.OrderBy(s=>s.CrewName), "CrewID", "CrewName"); ViewBag.DesigID = new SelectList(db.Designations.OrderBy(s=>s.DesignationName), "DesignationID", "DesignationName"); ViewBag.GradeID = new SelectList(db.Grades.OrderBy(s=>s.GradeName), "GradeID", "GradeName"); ViewBag.JobID = new SelectList(db.JobTitles.OrderBy(s=>s.JobTitle1), "JobID", "JobTitle1"); ViewBag.LocID = new SelectList(db.Locations.OrderBy(s=>s.LocName), "LocID", "LocName"); ViewBag.SecID = new SelectList(db.Sections.OrderBy(s=>s.SectionName), "SectionID", "SectionName"); ViewBag.ShiftID = new SelectList(db.Shifts.OrderBy(s=>s.ShiftName), "ShiftID", "ShiftName"); ViewBag.TypeID = new SelectList(db.EmpTypes.OrderBy(s=>s.TypeName), "TypeID", "TypeName"); ViewBag.CatID = new SelectList(db.Categories.OrderBy(s=>s.CatName), "CatID", "CatName"); ViewBag.DeptID = new SelectList(db.Departments.OrderBy(s=>s.DeptName), "DeptID", "DeptName"); } return View(emp); }
public ActionResult Edit([Bind(Include = "EmpID,EmpNo,EmpName,DesigID,JobID,Gender,ShiftID,LocID,TypeID,GradeID,SecID,CardNo,FpID,PinCode,NicNo,FatherName,BloodGroup,BirthDate,MarStatus,JoinDate,ValidDate,IssueDate,ResignDate,HomeAdd,ProcessAtt,ProcessIn,Status,PhoneNo,Remarks,Email,CellNo,CrewID,FlagFP,FlagFace,FlagCard,EmpImageID,HasOT")] Emp emp) { try { ViewBag.Message = ""; HttpPostedFileBase file = Request.Files["ImageData"]; if (file != null) { ImageConversion _Image = new ImageConversion(); int imageid = _Image.UploadImageInDataBase(file, emp); if (imageid!=0) { emp.EmpImageID= imageid; } else { } } if (string.IsNullOrEmpty(emp.EmpNo)) ModelState.AddModelError("EmpNo", "Emp No field is required!"); if (string.IsNullOrEmpty(emp.EmpName)) ModelState.AddModelError("EmpName", "Namefield is required!"); if (emp.EmpNo != null) { if (emp.EmpNo.Length > 15) ModelState.AddModelError("EmpNo", "String length exceeds!"); } if (emp.EmpName != null) { if (emp.EmpName.Length > 40) ModelState.AddModelError("EmpName", "String length exceeds!"); } if (emp.SecID == null) ModelState.AddModelError("SecID", "Please Specify section!"); if (emp.TypeID == null) ModelState.AddModelError("TypeID", "Please Specify Type!"); if (emp.GradeID == null) ModelState.AddModelError("GradeID", "Please Specify Grade!"); if (ModelState.IsValid) { emp.EmpNo = emp.EmpNo.ToUpper(); db.Entry(emp).State = EntityState.Modified; ViewBag.JS = "toastr.success('" + emp.EmpName + " data Successfully edited');"; db.SaveChanges(); int _userID = Convert.ToInt32(Session["LogedUserID"].ToString()); HelperClass.MyHelper.SaveAuditLog(_userID, (byte)MyEnums.FormName.Employee, (byte)MyEnums.Operation.Edit, DateTime.Now); return RedirectToAction("Index"); } User LoggedInUser = Session["LoggedUser"] as User; ViewBag.CrewID = new SelectList(db.Crews.OrderBy(s=>s.CrewName), "CrewID", "CrewName"); ViewBag.DesigID = new SelectList(db.Designations.OrderBy(s=>s.DesignationName), "DesignationID", "DesignationName"); ViewBag.GradeID = new SelectList(db.Grades.OrderBy(s=>s.GradeName), "GradeID", "GradeName"); ViewBag.JobID = new SelectList(db.JobTitles.OrderBy(s=>s.JobTitle1), "JobID", "JobTitle1"); ViewBag.LocID = new SelectList(db.Locations.OrderBy(s=>s.LocName), "LocID", "LocName"); ViewBag.SecID = new SelectList(db.Sections.OrderBy(s=>s.SectionName), "SectionID", "SectionName"); ViewBag.ShiftID = new SelectList(db.Shifts.OrderBy(s=>s.ShiftName), "ShiftID", "ShiftName"); ViewBag.TypeID = new SelectList(db.EmpTypes.OrderBy(s=>s.TypeName), "TypeID", "TypeName"); ViewBag.EmpID = new SelectList(db.EmpFaces.OrderBy(s=>s.Face1), "EmpID", "Face1"); ViewBag.EmpID = new SelectList(db.EmpFps.OrderBy(s=>s.Fp1), "EmpID", "Fp1"); ViewBag.CatID = new SelectList(db.Categories.OrderBy(s=>s.CatName), "CatID", "CatName"); ViewBag.DeptID = new SelectList(db.Departments.OrderBy(s=>s.DeptName), "DeptID", "DeptName"); return View(emp); } catch (Exception ex) { ViewBag.Message = ex.InnerException.ToString(); User LoggedInUser = Session["LoggedUser"] as User; ViewBag.CrewID = new SelectList(db.Crews.OrderBy(s=>s.CrewName), "CrewID", "CrewName"); ViewBag.DesigID = new SelectList(db.Designations.OrderBy(s=>s.DesignationName), "DesignationID", "DesignationName"); ViewBag.GradeID = new SelectList(db.Grades.OrderBy(s=>s.GradeName), "GradeID", "GradeName"); ViewBag.JobID = new SelectList(db.JobTitles.OrderBy(s=>s.JobTitle1), "JobID", "JobTitle1"); ViewBag.LocID = new SelectList(db.Locations.OrderBy(s=>s.LocName), "LocID", "LocName"); ViewBag.SecID = new SelectList(db.Sections.OrderBy(s=>s.SectionName), "SectionID", "SectionName"); ViewBag.ShiftID = new SelectList(db.Shifts.OrderBy(s=>s.ShiftName), "ShiftID", "ShiftName"); ViewBag.TypeID = new SelectList(db.EmpTypes.OrderBy(s=>s.TypeName), "TypeID", "TypeName"); ViewBag.EmpID = new SelectList(db.EmpFaces.OrderBy(s=>s.Face1), "EmpID", "Face1"); ViewBag.EmpID = new SelectList(db.EmpFps.OrderBy(s=>s.Fp1), "EmpID", "Fp1"); ViewBag.CatID = new SelectList(db.Categories.OrderBy(s=>s.CatName), "CatID", "CatName"); ViewBag.DeptID = new SelectList(db.Departments.OrderBy(s=>s.DeptName), "DeptID", "DeptName"); return View(emp); } }