public DataSet GetMCRequestFillData(string MCID)
{
DataSet ds = new DataSet();
clsMCWB mc = new clsMCWB();
ds = mc.GetMCRequestFillData(MCID);
return(ds);
}
public void FillEDLoanData(string LoanVal)
{
clsMCWB mc = new clsMCWB();
DataSet ds = mc.getLoanTADetails(int.Parse(LoanVal), "Pipeline");
DataTable dt = ds.Tables[0];
prjno.Text = dt.Rows[0][0].ToString();
prj_name.Text = dt.Rows[0][1].ToString();
lblLoanDetail.Text = dt.Rows[0][0].ToString() + "-" + dt.Rows[0][1].ToString();
prjSize.Text = dt.Rows[0][3].ToString();
prjClosingDate.Text = string.IsNullOrEmpty(dt.Rows[0][2].ToString())?"": Convert.ToDateTime(dt.Rows[0][2].ToString()).ToString("dd MMM yyyy");
}
public void BindMCMEmberGrid()
{
clsMCWB MCObj = new clsMCWB();
StringBuilder sb = new StringBuilder();
DataSet ds = MCObj.LoadMCGrid(Convert.ToInt32(hdnedMCID.Value));
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
sb.AppendLine("<tr>");
sb.AppendLine("<td style='width:350px;'>" + ds.Tables[0].Rows[i][1].ToString() + " " + ds.Tables[0].Rows[i][2].ToString() + "</td>");
sb.AppendLine("<td style='width:452px;'>" + ds.Tables[0].Rows[i][3].ToString() + "</td></tr>");
}
PDFMemName.InnerHtml = sb.ToString();
}
public void FillEDProjectData(string PrjID)
{
clsMCWB mc = new clsMCWB();
DataSet ds = mc.getLoanTADetails(int.Parse(PrjID), "Portfolio");
DataTable dt = ds.Tables[0];
prjno.Text = dt.Rows[0][0].ToString();
prj_name.Text = dt.Rows[0][1].ToString();
lblTaDetail.Text = dt.Rows[0][0].ToString() + "-" + dt.Rows[0][1].ToString();
prjSize.Text = dt.Rows[0][2].ToString();
DateTime dt1;
DateTime.TryParse(dt.Rows[0][3].ToString(), out dt1);
prjClosingDate.Text = (dt1 != Convert.ToDateTime("1/1/0001 12:00:00 AM") ? dt1.ToString("dd MMM yyyy") : "N/A");
}
public void FillEDTAData(string TAID)
{
clsMCWB mc = new clsMCWB();
DataSet ds = mc.getLoanTADetails(int.Parse(TAID), "AAA");
DataTable dt = ds.Tables[0];
prjno.Text = dt.Rows[0][0].ToString();
prj_name.Text = dt.Rows[0][1].ToString();
lblRetaDetail.Text = prjno.Text + "-" + prj_name.Text;
decimal result;
decimal.TryParse(dt.Rows[0][3].ToString(), out result);
prjSize.Text = Math.Round(result, 2).ToString();
DateTime dt1;
DateTime.TryParse(dt.Rows[0][2].ToString(), out dt1);
prjClosingDate.Text = (dt1 != Convert.ToDateTime("1/1/0001 12:00:00 AM") ? dt1.ToString("dd MMM yyyy") : "N/A");
}