public JsonResult GetDesignationMasterByDepartment(DepartmentMasterModel collection) { try { List <DesignationMasterModel> _list = new List <DesignationMasterModel>(); var _objDesignationMaster = _DbWorkPermitSystemEntities.tbl_DesignationMaster.Where(p => p.DepartmentID == collection.DepartmentID).ToList(); foreach (var item in _objDesignationMaster) { DesignationMasterModel _class = new Models.DesignationMasterModel(); _class.DesignationID = item.DesignationID; _class.DepartmentID = item.DepartmentID; _class.DesignationName = item.DesignationName; _list.Add(_class); } return(Json(_list, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ResultModel _objResult = new ResultModel(); _objResult.success = 0; _objResult.msg = ex.ToString(); return(Json(_objResult, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(int id, DepartmentMasterModel collection) { // TODO: Add update logic here //DepartmentMasterModel _objDepartment = new DepartmentMasterModel(); try { CheckViewBagData(); if (ModelState.IsValid) { var data = _DbWorkPermitSystemEntities.tbl_DepartmentMaster.Where(b => b.DepartmentID == id).FirstOrDefault(); { //data.DepartmentID = collection.DepartmentID; data.DepartmentName = collection.DepartmentName; _DbWorkPermitSystemEntities.Entry(data).State = EntityState.Modified; _DbWorkPermitSystemEntities.SaveChanges(); return(RedirectToAction("Index")); } } return(View()); } catch (Exception ex) { return(View()); } }
public IEnumerable <DepartmentMasterModel> GetAllDepartmentList(string databasename) { string strConnection = ""; strConnection = "Server=localhost;user id=root;password=pari@123;Database=" + databasename + ""; List <DepartmentMasterModel> data = new List <DepartmentMasterModel>(); MySqlConnection myConn = new MySqlConnection(); MySqlCommand myCmd = new MySqlCommand(); MySqlDataReader myRdr = null; try { myConn.ConnectionString = strConnection; myConn.Open(); myCmd.Connection = myConn; myCmd.CommandType = CommandType.Text; myCmd.CommandText = "SELECT Department_Code,Department_Name FROM tbldepartment Order By Department_Name"; myRdr = myCmd.ExecuteReader(); if (myRdr.HasRows) { while (myRdr.Read()) { DepartmentMasterModel singledata = new DepartmentMasterModel(); singledata.DepartmentId = Convert.ToInt16(myRdr["Department_Code"].ToString()); singledata.DepartmentName = myRdr["Department_Name"].ToString(); data.Add(singledata); } } } catch (Exception ex) { } finally { if (myRdr != null) { myRdr.Close(); myRdr.Dispose(); myRdr = null; } if (myCmd != null) { myCmd.Dispose(); myCmd = null; } if (myConn != null) { myConn.Close(); myConn.Dispose(); myConn = null; } } return(data); }
// GET: EmployeeDepartment/Details/5 public ActionResult Details(int id) { CheckViewBagData(); var model = _DbWorkPermitSystemEntities.tbl_DepartmentMaster.Where(a => a.DepartmentID == id).FirstOrDefault(); DepartmentMasterModel _objDepartmentModel = new DepartmentMasterModel(); _objDepartmentModel.DepartmentID = model.DepartmentID; _objDepartmentModel.DepartmentName = model.DepartmentName; _objDepartmentModel.DepartmentCreateDate = model.DepartmentCreateDate; return(View(_objDepartmentModel)); }
public ActionResult Create(DepartmentMasterModel collection) { CheckViewBagData(); if (ModelState.IsValid) { var data = new tbl_DepartmentMaster() { DepartmentName = collection.DepartmentName, DepartmentCreateDate = DateTime.Now }; if (!_DbWorkPermitSystemEntities.tbl_DepartmentMaster.Any(p => p.DepartmentName == collection.DepartmentName)) { try { _DbWorkPermitSystemEntities.tbl_DepartmentMaster.Add(data); _DbWorkPermitSystemEntities.SaveChanges(); List <string> Desig = new List <string> { "Activity Owner", "Area Owner" }; foreach (var item in Desig) { var DesignationData = new tbl_DesignationMaster() { DepartmentID = _DbWorkPermitSystemEntities.tbl_DepartmentMaster.Where(p => p.DepartmentName == collection.DepartmentName).Select(p => p.DepartmentID).FirstOrDefault(), DesignationName = item, DesignationCreateDate = DateTime.Now }; _DbWorkPermitSystemEntities.tbl_DesignationMaster.Add(DesignationData); _DbWorkPermitSystemEntities.SaveChanges(); } return(RedirectToAction("Index")); } catch (Exception ex) { return(View()); } } else { ViewBag.Errormessage = "Fail"; } } return(View()); }
public ActionResult Index() { CheckViewBagData(); List <DepartmentMasterModel> _objDepartmentModel = new List <DepartmentMasterModel>(); var Department = _DbWorkPermitSystemEntities.tbl_DepartmentMaster.ToList(); foreach (var item in Department) { DepartmentMasterModel _objDepartmentMasterModel = new DepartmentMasterModel(); var Departmentitem = _DbWorkPermitSystemEntities.tbl_DepartmentMaster.Where(p => p.DepartmentID == item.DepartmentID).FirstOrDefault(); _objDepartmentMasterModel.DepartmentID = Departmentitem.DepartmentID; _objDepartmentMasterModel.DepartmentName = Departmentitem.DepartmentName; _objDepartmentMasterModel.DepartmentCreateDate = Departmentitem.DepartmentCreateDate; _objDepartmentModel.Add(_objDepartmentMasterModel); } return(View(_objDepartmentModel.ToList())); }