//Table Fund public ActionResult Get_FundTable() { FM_Fund model = new FM_Fund(); List <FundList> tbl_Fund = new List <FundList>(); var SQLQuery = "SELECT * FROM DB_TOSS.dbo.Fund"; //SQLQuery += " WHERE (IsActive != 0)"; using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString())) { Connection.Open(); using (SqlCommand command = new SqlCommand("[dbo].[SP_FundsList]", Connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery)); SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { tbl_Fund.Add(new FundList() { FundID = GlobalFunction.ReturnEmptyInt(dr[0]), FundName = GlobalFunction.ReturnEmptyString(dr[1]), FundCode = GlobalFunction.ReturnEmptyString(dr[2]), }); } } Connection.Close(); } model.getFundList = tbl_Fund.ToList(); return(PartialView("Fund/_FundTable", model.getFundList)); }
//Dropdown Fund public ActionResult GetDynamicFund() { FM_Fund model = new FM_Fund(); model.SubFundList = new SelectList((from s in TOSSDB.Funds.ToList() select new { FundID = s.FundID, FundName = s.FundName }), "FundID", "FundName"); return(PartialView("SubFund/_DynamiccDDFundName", model)); }
//Delete SubFund public ActionResult DeleteSubFunds(FM_Fund model, int SubFundID) { SubFund tblSubFund = (from e in TOSSDB.SubFunds where e.SubFundID == SubFundID select e).FirstOrDefault(); TOSSDB.SubFunds.Remove(tblSubFund); TOSSDB.SaveChanges(); return(RedirectToAction("Index")); }
//Get Update Fund public ActionResult Get_UpdateFund(FM_Fund model, int FundID) { Fund tblFund = (from e in TOSSDB.Funds where e.FundID == FundID select e).FirstOrDefault(); model.getFundcolumns.FundID = tblFund.FundID; model.getFundcolumns.FundName = tblFund.FundName; model.getFundcolumns.FundCode = tblFund.FundCode; return(PartialView("Fund/_UpdateFunds", model)); }
//Get Update SubFund public ActionResult Get_UpdateSubFund(FM_Fund model, int SubFundID) { SubFund tblFund = (from e in TOSSDB.SubFunds where e.SubFundID == SubFundID select e).FirstOrDefault(); model.getSubFundcolumns.SubFundID = tblFund.SubFundID; model.SubFundNameTempID = Convert.ToInt32(tblFund.FundID); model.getSubFundcolumns.SubFundName = tblFund.SubFundName; return(PartialView("SubFund/_UpdateSubFund", model)); }
//Update Fund public ActionResult UpdateFunds(FM_Fund model) { Fund tblFund = (from e in TOSSDB.Funds where e.FundID == model.getFundcolumns.FundID select e).FirstOrDefault(); tblFund.FundName = model.getFundcolumns.FundName; tblFund.FundCode = model.getFundcolumns.FundCode; TOSSDB.Entry(tblFund); TOSSDB.SaveChanges(); return(PartialView("Fund/_UpdateFunds", model)); }
//Add Fund public JsonResult AddFunds(FM_Fund model) { Fund tblFund = new Fund(); tblFund.FundName = model.getFundcolumns.FundName; tblFund.FundCode = model.getFundcolumns.FundCode; TOSSDB.Funds.Add(tblFund); TOSSDB.SaveChanges(); return(Json(tblFund)); }
//Add SubFund public JsonResult AddSubFunds(FM_Fund model) { SubFund tblSubFund = new SubFund(); tblSubFund.FundID = model.SubFundNameID; tblSubFund.SubFundName = model.getSubFundcolumns.SubFundName; TOSSDB.SubFunds.Add(tblSubFund); TOSSDB.SaveChanges(); return(Json(tblSubFund)); }
//Get Add Fund Partial View public ActionResult Get_AddFund() { FM_Fund model = new FM_Fund(); return(PartialView("Fund/_AddFunds", model)); }
public ActionResult SubFundTab() { FM_Fund model = new FM_Fund(); return(PartialView("SubFund/SubFundIndex", model)); }