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());
}
