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