private List <SupplierPaymentMOE> getSavedSupplierPaymentMOEs()
{
List <SupplierPaymentMOE> lstPayment = new List <SupplierPaymentMOE>();
string strConnection = ConfigurationManager.ConnectionStrings["UsedConnection"].ConnectionString;
using (var conn = new SqlConnection(strConnection))
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT " +
"* " +
" FROM " +
" SupplierPayment_MOE_Header ";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
SupplierPaymentMOE row = new SupplierPaymentMOE();
row.PaymentNo = Convert.ToString(dr["PaymentID"]);
row.PaymentDate = Convert.ToString(dr["PaymentDate"]);
row.Year = Convert.ToInt32(dr["Year"]);
row.Month = Convert.ToString(dr["Month"]);
row.Amount = Convert.ToDecimal(dr["Amount"]);
row.ChequeNumber = Convert.ToString(dr["ChequeNumber"]);
row.ChequeDate = Convert.ToDateTime(dr["ChequeDate"]);
lstPayment.Add(row);
}
return(lstPayment);
}
}
public ActionResult Index()
{
SupplierPaymentMOE model = new SupplierPaymentMOE();
List <SupplierPaymentMOE> paymentRequestList = getSavedSupplierPaymentMOEs();
ViewBag.SupplierPaymentRequestList = paymentRequestList;
ViewBag.Month = GetMonthsString();
ViewBag.Year = GetResentYears(model.Year.ToString());
ViewBag.Banks = GetBanks();
ViewBag.GrantTotal = (from od in model.PaymentSummary select od.TotalAmount).Sum();
return(View(model));
}
