//Table Internal Revenue Allotment public ActionResult Get_OfficeTypeTable() { FM_OfficeType_OfficeType model = new FM_OfficeType_OfficeType(); List <OfficeTypeList> tbl_OfficeType = new List <OfficeTypeList>(); var SQLQuery = "SELECT * FROM DB_TOSS.dbo.OfficeType"; //SQLQuery += " WHERE (IsActive != 0)"; using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString())) { Connection.Open(); using (SqlCommand command = new SqlCommand("[dbo].[SP_OfficeTypeList]", Connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery)); SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { tbl_OfficeType.Add(new OfficeTypeList() { OfficeTypeID = Convert.ToInt32(dr[0]), OfficeTypeName = GlobalFunction.ReturnEmptyString(dr[1]), OfficeTypeCode = GlobalFunction.ReturnEmptyString(dr[2]), }); } } Connection.Close(); } model.getOfficeTypeList = tbl_OfficeType.ToList(); return(PartialView("_OfficeTypeTable", model.getOfficeTypeList)); }
//Delete Internal Revenue Allotment public ActionResult DeleteOfficeType(FM_OfficeType_OfficeType model, int OfficeTypeID) { OfficeType tblOfficeType = (from e in TOSSDB.OfficeTypes where e.OfficeTypeID == OfficeTypeID select e).FirstOrDefault(); TOSSDB.OfficeTypes.Remove(tblOfficeType); TOSSDB.SaveChanges(); return(RedirectToAction("Index")); }
//Get Update Internal Revenue Allotment public ActionResult Get_UpdateOfficeType(FM_OfficeType_OfficeType model, int OfficeTypeID) { OfficeType tblOfficeType = (from e in TOSSDB.OfficeTypes where e.OfficeTypeID == OfficeTypeID select e).FirstOrDefault(); model.getOfficeTypecolumns.OfficeTypeID = tblOfficeType.OfficeTypeID; model.getOfficeTypecolumns.OfficeTypeName = tblOfficeType.OfficeTypeName; model.getOfficeTypecolumns.OfficeTypeCode = tblOfficeType.OfficeTypeCode; return(PartialView("_UpdateOfficeType", model)); }
//Update Internal Revenue Allotment public ActionResult UpdateOfficeType(FM_OfficeType_OfficeType model) { OfficeType tblOfficeType = (from e in TOSSDB.OfficeTypes where e.OfficeTypeID == model.getOfficeTypecolumns.OfficeTypeID select e).FirstOrDefault(); tblOfficeType.OfficeTypeName = model.getOfficeTypecolumns.OfficeTypeName; tblOfficeType.OfficeTypeCode = model.getOfficeTypecolumns.OfficeTypeCode; TOSSDB.Entry(tblOfficeType); TOSSDB.SaveChanges(); return(PartialView("_UpdateOfficeType", model)); }
//Add Internal Revenue Allotment public JsonResult AddOfficeType(FM_OfficeType_OfficeType model) { OfficeType tblOfficeType = new OfficeType(); tblOfficeType.OfficeTypeName = model.getOfficeTypecolumns.OfficeTypeName; tblOfficeType.OfficeTypeCode = model.getOfficeTypecolumns.OfficeTypeCode; TOSSDB.OfficeTypes.Add(tblOfficeType); TOSSDB.SaveChanges(); return(Json(tblOfficeType)); }
//Get Add Internal Revenue Allotment Partial View public ActionResult Get_AddOfficeType() { FM_OfficeType_OfficeType model = new FM_OfficeType_OfficeType(); return(PartialView("_AddOfficeType", model)); }