//-----------------Select data on Budget DDL selection on Budget Sanction form
public void BdgtSanc_SelectB(String flag, Int32 InstID, Int32 Budget_Id, ref List <DataMember.Budget> BdgtListItms, DBManager ObjDb)
{
BdgtAllc_Select_(flag, InstID, Budget_Id, ref ObjDb);
if (ObjDb.DataReader.Read())
{
var Item = new DataMember.Budget();
Item.Applied_Amt = Decimal.Parse(ObjDb.DataReader["Applied_Amt"].ToString());
Item.Allocated_Amt = Decimal.Parse(ObjDb.DataReader["Allocated_Amt"].ToString());
Item.Ledger_Id = Int32.Parse(ObjDb.DataReader["Ledger_Id"].ToString());
BdgtListItms.Add(Item);
}
ObjDb.DataReader.Close();
ObjDb.Command.Parameters.Clear();
}
//------------------Budget Sanction Fill Grid--------------------------
public void BdgtSanc_FillGrid(String flag, Int32 InstID, Int32 Budget_Id, ref List <DataMember.Budget> BdgtListItms, DBManager ObjDb)
{
BdgtAllc_Select_(flag, InstID, Budget_Id, ref ObjDb);
while (ObjDb.DataReader.Read())
{
var Item = new DataMember.Budget();
Item.Budget_Id = Int32.Parse(ObjDb.DataReader["Budget_Id"].ToString());
Item.Budget_name = ObjDb.DataReader["Budget_name"].ToString();
Item.Sanction_Date = DateTime.Parse(ObjDb.DataReader["Sanction_Date"].ToString());
Item.Sanction_Amt = Decimal.Parse(ObjDb.DataReader["Sanction_Amt"].ToString());
Item.FileName = ObjDb.DataReader["FileName"].ToString();
Item.sanctioned_Doc_name = ObjDb.DataReader["sanctioned_Doc_name"].ToString();
Item.FType = ObjDb.DataReader["FType"].ToString();
BdgtListItms.Add(Item);
}
ObjDb.DataReader.Close();
ObjDb.Command.Parameters.Clear();
}
public void BdgtMst_Select(String flag, Int32 InstID, Int32 Budget_Id, ref List <DataMember.Budget> BdgtListItms, DBManager ObjDb)
{
BdgtAllc_Select_(flag, InstID, Budget_Id, ref ObjDb);
if (ObjDb.DataReader.Read())
{
var Item = new DataMember.Budget();
Item.Budget_Id = Int32.Parse(ObjDb.DataReader["Budget_Id"].ToString());
Item.Budget_name = ObjDb.DataReader["Budget_name"].ToString();
Item.Applied_date = DateTime.Parse(ObjDb.DataReader["Applied_date"].ToString());
Item.Applied_Amt = Decimal.Parse(ObjDb.DataReader["Applied_Amt"].ToString());
Item.Budget_For = ObjDb.DataReader["Budget_For"].ToString();
Item.Ledger_Id = Int32.Parse(ObjDb.DataReader["Ledger_Id"].ToString());
Item.FileName = ObjDb.DataReader["Applied_Doc_Id"].ToString();
Item.Applied_Doc_Name = ObjDb.DataReader["Applied_Doc_Name"].ToString();
BdgtListItms.Add(Item);
}
ObjDb.DataReader.Close();
ObjDb.Command.Parameters.Clear();
}
//-----------------Select data on GridRow selection on Budget Sanction form
public void BdgtSanc_SelectG(String flag, Int32 InstID, Int32 Budget_Id, ref List <DataMember.Budget> BdgtListItms, DBManager ObjDb)
{
BdgtAllc_Select_(flag, InstID, Budget_Id, ref ObjDb);
if (ObjDb.DataReader.Read())
{
var Item = new DataMember.Budget();
Item.Budget_Id = Int32.Parse(ObjDb.DataReader["Budget_Id"].ToString());
Item.Budget_name = ObjDb.DataReader["Budget_name"].ToString();
Item.Applied_Amt = Decimal.Parse(ObjDb.DataReader["Applied_Amt"].ToString());
Item.Allocated_Amt = Decimal.Parse(ObjDb.DataReader["Allocated_Amt"].ToString());
Item.Ledger_Id = Int32.Parse(ObjDb.DataReader["Ledger_Id"].ToString());
Item.Sanction_Date = DateTime.Parse(ObjDb.DataReader["Sanction_Date"].ToString());
Item.Sanction_Amt = Decimal.Parse(ObjDb.DataReader["Sanction_Amt"].ToString());
Item.FileName = ObjDb.DataReader["Sanctioned_Doc_Id"].ToString();
Item.sanctioned_Doc_name = ObjDb.DataReader["sanctioned_Doc_name"].ToString();
Item.Fund_Source_Id = Int32.Parse(ObjDb.DataReader["Fund_Source_Id"].ToString());
Item.Balance = Decimal.Parse(ObjDb.DataReader["Balance"].ToString());
Item.Sanction_Number = ObjDb.DataReader["Sanction_Number"].ToString();
BdgtListItms.Add(Item);
}
ObjDb.DataReader.Close();
ObjDb.Command.Parameters.Clear();
}