public ActionResult GetOfficeTypeDTable() { OfficeTypeModel model = new OfficeTypeModel(); List <OfficeTypeList> getOfficeTypeList = new List <OfficeTypeList>(); var SQLQuery = "SELECT * FROM [Tbl_FMOfficeType]"; using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString())) { Connection.Open(); using (SqlCommand command = new SqlCommand("[dbo].[SP_OfficeType]", Connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery)); SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { getOfficeTypeList.Add(new OfficeTypeList() { OfficeTypeID = GlobalFunction.ReturnEmptyInt(dr[0]), OfficeTypeTitle = GlobalFunction.ReturnEmptyString(dr[1]), OfficeTypeCode = GlobalFunction.ReturnEmptyString(dr[2]) }); } } Connection.Close(); } model.getOfficeTypeList = getOfficeTypeList.ToList(); return(PartialView("_TableOfficeType", model.getOfficeTypeList)); }
public static OfficeTypeModel OfficeTypeToOfficeTypeModel(OfficeType model) { var officeTypeModel = new OfficeTypeModel { Id = model.Id, CreatedDate = model.CreatedDate, OfficeTypeName = model.OfficeTypeName, UpdatedDate = model.UpdatedDate }; return(officeTypeModel); }
public static OfficeType OfficeTypeModelToOfficeType(OfficeTypeModel model) { var officeType = new OfficeType { Id = model.Id, CreatedDate = model.CreatedDate, OfficeTypeName = model.OfficeTypeName, UpdatedDate = model.UpdatedDate }; return(officeType); }
public ActionResult GetOfficeTypeForm(int ActionID, int PrimaryID) { OfficeTypeModel model = new OfficeTypeModel(); if (ActionID == 2) { var officeType = (from e in BOSSDB.Tbl_FMOfficeType where e.OfficeTypeID == PrimaryID select e).FirstOrDefault(); model.OfficeTypeList.OfficeTypeTitle = officeType.OfficeTypeTitle; model.OfficeTypeList.OfficeTypeCode = officeType.OfficeTypeCode; model.OfficeTypeList.OfficeTypeID = officeType.OfficeTypeID; } model.ActionID = ActionID; return(PartialView("_OfficeTypeForm", model)); }
public IEnumerable <OfficeTypeModel> Items() { try { List <OfficeTypeModel> lstOfficeType = new List <OfficeTypeModel>(); using (SqlConnection con = new SqlConnection(Connection)) { SqlCommand cmd = new SqlCommand("uspOfficeType", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { OfficeTypeModel officeTypeModel = new OfficeTypeModel(); officeTypeModel.OfficeTypeId = Convert.ToInt32(rdr["OfficeTypeId"]); officeTypeModel.OfficeType = rdr["OfficeType"].ToString(); lstOfficeType.Add(officeTypeModel); } con.Close(); } return(lstOfficeType); } catch (Exception ex) { //OSN.Generic.EventLogHelper appLog = new OSN.Generic.EventLogHelper(); //appLog.Source = "Communique"; //StringBuilder sb = new StringBuilder(); //sb.Append("public System.Data.DataTable Items()"); //sb.Append("Exception=" + ex.Message); //appLog.WriteEntry(sb.ToString()); return(null); } }
public ActionResult Edit(OfficeTypeModel model) { try { if (ModelState.IsValid) { model.UpdatedDate = DateTime.Now; officeTypeService.Update(model); TempData["Success"] = $"{model.OfficeTypeName} is updated"; return(RedirectToAction("Index")); } return(View(@"~\Views\Configuration\OfficeType\Edit.cshtml", model)); } catch (Exception e) { TempData["Danger"] = $"Oppsss something went wrong {e.Message}"; throw; } }
public ActionResult SaveOfficeType(OfficeTypeModel model) { var isExist = ""; if (ModelState.IsValid) { var offtypetitle = model.OfficeTypeList.OfficeTypeTitle; offtypetitle = Regex.Replace(offtypetitle, @"\s\s+", ""); offtypetitle = Regex.Replace(offtypetitle, @"^\s+", ""); offtypetitle = Regex.Replace(offtypetitle, @"\s+$", ""); offtypetitle = new CultureInfo("en-US").TextInfo.ToTitleCase(offtypetitle); Tbl_FMOfficeType checkofficetype = (from a in BOSSDB.Tbl_FMOfficeType where (a.OfficeTypeTitle == offtypetitle || a.OfficeTypeCode == model.OfficeTypeList.OfficeTypeCode) select a).FirstOrDefault(); if (model.ActionID == 1) { if (checkofficetype == null) { Tbl_FMOfficeType OfficeTypeTbl = new Tbl_FMOfficeType(); OfficeTypeTbl.OfficeTypeTitle = GlobalFunction.ReturnEmptyString(model.OfficeTypeList.OfficeTypeTitle); OfficeTypeTbl.OfficeTypeCode = GlobalFunction.ReturnEmptyString(model.OfficeTypeList.OfficeTypeCode); BOSSDB.Tbl_FMOfficeType.Add(OfficeTypeTbl); BOSSDB.SaveChanges(); isExist = "false"; } else if (checkofficetype != null) { isExist = "true"; } } else if (model.ActionID == 2) { Tbl_FMOfficeType officetype = (from e in BOSSDB.Tbl_FMOfficeType where e.OfficeTypeID == model.OfficeTypeList.OfficeTypeID select e).FirstOrDefault(); List <Tbl_FMOfficeType> officeTitle = (from e in BOSSDB.Tbl_FMOfficeType where e.OfficeTypeTitle == offtypetitle select e).ToList(); List <Tbl_FMOfficeType> officeCode = (from e in BOSSDB.Tbl_FMOfficeType where e.OfficeTypeCode == model.OfficeTypeList.OfficeTypeCode select e).ToList(); if (checkofficetype != null) { if (officetype.OfficeTypeTitle == offtypetitle && officetype.OfficeTypeCode == model.OfficeTypeList.OfficeTypeCode) //walang binago { officetype.OfficeTypeTitle = offtypetitle; officetype.OfficeTypeCode = model.OfficeTypeList.OfficeTypeCode; BOSSDB.Entry(officetype); BOSSDB.SaveChanges(); isExist = "justUpdate"; } else { if (officetype.OfficeTypeTitle != offtypetitle && officeTitle.Count >= 1 || officetype.OfficeTypeCode != model.OfficeTypeList.OfficeTypeCode && officeCode.Count >= 1) { isExist = "true"; } else { officetype.OfficeTypeTitle = offtypetitle; officetype.OfficeTypeCode = model.OfficeTypeList.OfficeTypeCode; BOSSDB.Entry(officetype); BOSSDB.SaveChanges(); isExist = "justUpdate"; } } } else if (checkofficetype == null) { officetype.OfficeTypeTitle = offtypetitle; officetype.OfficeTypeCode = model.OfficeTypeList.OfficeTypeCode; BOSSDB.Entry(officetype); BOSSDB.SaveChanges(); isExist = "justUpdate"; } } } return(new JsonResult() { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { isExist = isExist } }); }
// GET: FileMaintenanceOfficeType public ActionResult FileOfficeType() { OfficeTypeModel model = new OfficeTypeModel(); return(View()); }