public ActionResult GetAppropSourceForm(int ActionID, int PrimaryID) { AppropSourceModel model = new AppropSourceModel(); if (ActionID == 2) { var appropSource = (from a in BOSSDB.Tbl_FMApprop_AppropriationSource where a.AppropriationID == PrimaryID select a).FirstOrDefault(); model.FundSourceID = Convert.ToInt32(appropSource.FundSourceID); model.AppropSourceTypeID = Convert.ToInt32(appropSource.Tbl_FMApprop_FundSource.AppropSourceTypeID); model.AppropSourceList.Description = appropSource.Description; model.BudgetYearID = Convert.ToInt32(appropSource.BudgetYearID); model.AppropSourceList.AppropriationID = appropSource.AppropriationID; var fundsourceTBL = (from a in BOSSDB.Tbl_FMApprop_FundSource orderby a.FundSourceTitle where a.AppropSourceTypeID == model.AppropSourceTypeID select a).ToList(); if (fundsourceTBL.Count > 0) { model.FundSourceList = new SelectList(fundsourceTBL, "FundSourceID", "FundSourceTitle"); } } else { var appropSourceTypeTBL = (from a in BOSSDB.FMApprop_AppropriationSourceType orderby a.AppropSourceTypeTitle select a.AppropSourceTypeID).FirstOrDefault(); var fundsourceTBL = (from a in BOSSDB.Tbl_FMApprop_FundSource orderby a.FundSourceTitle where a.AppropSourceTypeID == appropSourceTypeTBL select a).ToList(); if (fundsourceTBL.Count > 0) { model.FundSourceList = new SelectList(fundsourceTBL, "FundSourceID", "FundSourceTitle"); } } model.FundSourceList = (from li in model.FundSourceList orderby li.Text select li).ToList(); model.ActionID = ActionID; return(PartialView("AppropriationSource/_AppropSourceForm", model)); }
//============================================================================================================================= //Apprpriation Source Tab //============================================================================================================================= //Get Appropriation Source Datatable Partial View public ActionResult GetAppropSourceDTable() { AppropSourceModel model = new AppropSourceModel(); List <AppropSourceList> getAppropSourceList = new List <AppropSourceList>(); var SQLQuery = "SELECT [AppropriationID], [AppropSourceTypeTitle], [FundSourceTitle], [Description], [BudgetYearTitle] FROM [Tbl_FMApprop_AppropriationSource], [Tbl_FMApprop_FundSource], [FMApprop_AppropriationSourceType], [FMApprop_BudgetYear] where [FMApprop_BudgetYear].BudgetYearID = [dbo].Tbl_FMApprop_AppropriationSource.BudgetYearID and [Tbl_FMApprop_AppropriationSource].FundSourceID = [Tbl_FMApprop_FundSource].FundSourceID and [Tbl_FMApprop_FundSource].AppropSourceTypeID = [FMApprop_AppropriationSourceType].AppropSourceTypeID"; using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString())) { Connection.Open(); using (SqlCommand command = new SqlCommand("[dbo].[SP_AppropriationSource]", Connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery)); SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { getAppropSourceList.Add(new AppropSourceList() { AppropriationID = GlobalFunction.ReturnEmptyInt(dr[0]), AppropSourceTypeTitle = GlobalFunction.ReturnEmptyString(dr[1]), FundSourceTitle = GlobalFunction.ReturnEmptyString(dr[2]), Description = GlobalFunction.ReturnEmptyString(dr[3]), BudgetYearTitle = GlobalFunction.ReturnEmptyString(dr[4]) }); } } Connection.Close(); } model.getAppropSourceList = getAppropSourceList.ToList(); return(PartialView("AppropriationSource/_TableAppropriationSource", model.getAppropSourceList)); }
public ActionResult GetAppSourceTab() { AppropSourceModel model = new AppropSourceModel(); return(PartialView("AppropriationSource/AppropriationSourceIndex", model)); }
public ActionResult SaveAppropSource(AppropSourceModel model) { var isExist = ""; if (ModelState.IsValid) { var appropDesc = model.AppropSourceList.Description; appropDesc = Regex.Replace(appropDesc, @"\s\s+", ""); appropDesc = Regex.Replace(appropDesc, @"^\s+", ""); appropDesc = Regex.Replace(appropDesc, @"\s+$", ""); appropDesc = new CultureInfo("en-US").TextInfo.ToTitleCase(appropDesc); Tbl_FMApprop_AppropriationSource checkApprop = (from a in BOSSDB.Tbl_FMApprop_AppropriationSource where (a.Description == model.AppropSourceList.Description) select a).FirstOrDefault(); if (model.ActionID == 1) { if (checkApprop == null) { Tbl_FMApprop_AppropriationSource appropS = new Tbl_FMApprop_AppropriationSource(); appropS.Description = appropDesc; appropS.FundSourceID = model.FundSourceID; appropS.BudgetYearID = model.BudgetYearID; BOSSDB.Tbl_FMApprop_AppropriationSource.Add(appropS); BOSSDB.SaveChanges(); isExist = "false"; } else if (checkApprop != null) { isExist = "true"; } } else if (model.ActionID == 2) { Tbl_FMApprop_AppropriationSource approp = (from a in BOSSDB.Tbl_FMApprop_AppropriationSource where a.AppropriationID == model.AppropSourceList.AppropriationID select a).FirstOrDefault(); List <Tbl_FMApprop_AppropriationSource> appropDescription = (from e in BOSSDB.Tbl_FMApprop_AppropriationSource where e.Description == appropDesc select e).ToList(); if (checkApprop != null) { if (approp.Description == appropDesc) { isExist = "justUpdate"; } else { if (approp.Description != appropDesc && appropDescription.Count >= 1) { isExist = "true"; } else { isExist = "justUpdate"; } } } else if (checkApprop == null) { isExist = "justUpdate"; } if (isExist == "justUpdate") { approp.Description = appropDesc; approp.FundSourceID = model.FundSourceID; approp.BudgetYearID = model.BudgetYearID; BOSSDB.Entry(approp); BOSSDB.SaveChanges(); } } } return(new JsonResult() { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { isExist = isExist } }); }
public ActionResult onChangeFundSource(AppropSourceModel model, int AppropSourceTypeID) { var FoundSourceClass = (from a in BOSSDB.Tbl_FMApprop_FundSource where a.AppropSourceTypeID == AppropSourceTypeID select a).ToList(); return(Json(new SelectList(FoundSourceClass, "FundSourceID", "FundSourceTitle"), JsonRequestBehavior.AllowGet)); }
public ActionResult FileAppropFundSource() { AppropSourceModel model = new AppropSourceModel(); return(View()); }