private void loadPCBDDL()
{
core_petty_cash_book objPCB = new core_petty_cash_book();
DataSet ds = objPCB.SelectMethod(@"SELECT PCB.Id_Petty_Cash_Book,PCB.Petty_Cash_Book_Name,PCB.Petty_Cash_Book_Code FROM core_petty_cash_book AS PCB WHERE PCB.Is_Active='0';", "core_petty_cash_book");
DataRow dr = ds.Tables["core_petty_cash_book"].NewRow();
dr[0] = "0";
dr[1] = "Select";
dr[2] = "Select";
ds.Tables["core_petty_cash_book"].Rows.InsertAt(dr, 0);
ddlPCBName.DataSource = ds.Tables["core_petty_cash_book"];
ddlPCBName.DataValueField = "Id_Petty_Cash_Book";
ddlPCBName.DataTextField = "Petty_Cash_Book_Name";
ddlPCBName.DataBind();
ddlPCBCode.DataSource = ds.Tables["core_petty_cash_book"];
ddlPCBCode.DataValueField = "Id_Petty_Cash_Book";
ddlPCBCode.DataTextField = "Petty_Cash_Book_Code";
ddlPCBCode.DataBind();
}
private void loadPCBAvailableBalance()
{
core_petty_cash_book pcbObj = new core_petty_cash_book();
DataSet ds = pcbObj.SelectMethod(@"SELECT
pcb.Id_Petty_Cash_Book,
pcb.Petty_Cash_Book_Name,
pcb.Petty_Cash_Book_Code,
pcb.Available_Balance_Amount
FROM core_petty_cash_book AS pcb
WHERE pcb.Is_Active='0' AND pcb.Id_Petty_Cash_Book='"+ddlPCBName.SelectedValue+"' OR pcb.Id_Petty_Cash_book='"+ddlPCBCode.SelectedValue+"';","core_petty_cash_book");
if (ds.Tables["core_petty_cash_book"] != null && ds.Tables["core_petty_cash_book"].Rows.Count > 0)
PCBAvailableBalance.Text = ds.Tables["core_petty_cash_book"].Rows[0]["Available_Balance_Amount"].ToString();
else
PCBAvailableBalance.Text="0.00";
}
private void RetrievePCBDetails()
{
core_petty_cash_book pcbObj = new core_petty_cash_book();
core_petty_cash_book_Objects ObjPCB = new core_petty_cash_book_Objects();
DataSet ds = pcbObj.SelectMethod(@"SELECT
PCB.Id_Petty_Cash_Book,
PCB.Petty_Cash_Book_Name,
PCB.Petty_Cash_Book_Code,
PCB.Petty_Cash_Book_Max_Amount,
PCB.Available_Balance_Amount,
PCB.Petty_Cash_Book_Remark,
PCB.Created_Date,
PCB.Created_User,
PCB.Edited_Date,
PCB.Edited_User,
PCB.Is_Active
FROM core_petty_cash_book as PCB WHERE PCB.Is_Active='0';", "core_petty_cash_book");
GridView1.DataSource = ds.Tables["core_petty_cash_book"];
GridView1.DataBind();
}
private void loadMaxAmount()
{
core_petty_cash_book pcbObj = new core_petty_cash_book();
DataSet ds = pcbObj.SelectMethod(@"SELECT
pcb.Id_Petty_Cash_Book,
pcb.Petty_Cash_Book_Max_Amount
FROM core_petty_cash_book AS pcb
WHERE pcb.Is_Active='0' AND pcb.Id_Petty_Cash_Book='" + ddlPCBName.SelectedValue + "' OR pcb.Id_Petty_Cash_book='" + ddlPCBCode.SelectedValue + "';", "core_petty_cash_book");
if (ds.Tables["core_petty_cash_book"] != null && ds.Tables["core_petty_cash_book"].Rows.Count > 0)
PCBMaxAmount.Text = ds.Tables["core_petty_cash_book"].Rows[0]["Petty_Cash_Book_Max_Amount"].ToString();
else
{
PCBMaxAmount.Text = "";
//AmountToBeReimbursed.Text = "0.00";
}
}