/// <summary>
/// Saves a record to the core_petty_cash_reimbursement table.
/// </summary>
public void Insert(core_petty_cash_reimbursement_Objects objCls)
{
MySqlConnection scon = Connectivity.Cls_Connection.getConnection();
MySqlCommand scom = new MySqlCommand("core_petty_cash_reimbursementInsert", scon);
scom.CommandType = CommandType.StoredProcedure;
scom.Parameters.Add("COL_Id_Petty_Cash_Reimbursement", MySqlDbType.Int32,0);
scom.Parameters.Add("COL_Id_Petty_Cash_Book", MySqlDbType.Int32,0);
scom.Parameters.Add("COL_Amount_ThatShouldBe_Reimbursed", MySqlDbType.Double,0);
scom.Parameters.Add("COL_Reimbursement_Amount", MySqlDbType.Double,0);
scom.Parameters.Add("COL_Balance_Carried_Forward", MySqlDbType.Double,0);
scom.Parameters.Add("COL_Petty_Cash_Reimbursement_Remark", MySqlDbType.Text,65535);
scom.Parameters.Add("COL_Created_Date", MySqlDbType.DateTime,0);
scom.Parameters.Add("COL_Created_User", MySqlDbType.Int32,0);
scom.Parameters.Add("COL_Edited_Date", MySqlDbType.DateTime,0);
scom.Parameters.Add("COL_Edited_User", MySqlDbType.Int32,0);
scom.Parameters.Add("COL_Is_Active", MySqlDbType.Bit,0);
scom.Parameters["COL_Id_Petty_Cash_Reimbursement"].Value = objCls.Id_Petty_Cash_Reimbursement;
scom.Parameters["COL_Id_Petty_Cash_Book"].Value = objCls.Id_Petty_Cash_Book;
scom.Parameters["COL_Amount_ThatShouldBe_Reimbursed"].Value = objCls.Amount_ThatShouldBe_Reimbursed;
scom.Parameters["COL_Reimbursement_Amount"].Value = objCls.Reimbursement_Amount;
scom.Parameters["COL_Balance_Carried_Forward"].Value = objCls.Balance_Carried_Forward;
scom.Parameters["COL_Petty_Cash_Reimbursement_Remark"].Value = objCls.Petty_Cash_Reimbursement_Remark;
scom.Parameters["COL_Created_Date"].Value = objCls.Created_Date;
scom.Parameters["COL_Created_User"].Value = objCls.Created_User;
scom.Parameters["COL_Edited_Date"].Value = objCls.Edited_Date;
scom.Parameters["COL_Edited_User"].Value = objCls.Edited_User;
scom.Parameters["COL_Is_Active"].Value = objCls.Is_Active;
scon.Open();
scom.ExecuteNonQuery();
scon.Close();
}
/// <summary>
/// Saves a record to the core_petty_cash_reimbursement table.
/// </summary>
public void Insert(core_petty_cash_reimbursement_Objects objCls)
{
MySqlConnection scon = Connectivity.Cls_Connection.getConnection();
MySqlCommand scom = new MySqlCommand("core_petty_cash_reimbursementInsert", scon);
scom.CommandType = CommandType.StoredProcedure;
scom.Parameters.Add("COL_Id_Petty_Cash_Reimbursement", MySqlDbType.Int32, 0);
scom.Parameters.Add("COL_Id_Petty_Cash_Book", MySqlDbType.Int32, 0);
scom.Parameters.Add("COL_Amount_ThatShouldBe_Reimbursed", MySqlDbType.Double, 0);
scom.Parameters.Add("COL_Reimbursement_Amount", MySqlDbType.Double, 0);
scom.Parameters.Add("COL_Balance_Carried_Forward", MySqlDbType.Double, 0);
scom.Parameters.Add("COL_Petty_Cash_Reimbursement_Remark", MySqlDbType.Text, 65535);
scom.Parameters.Add("COL_Created_Date", MySqlDbType.DateTime, 0);
scom.Parameters.Add("COL_Created_User", MySqlDbType.Int32, 0);
scom.Parameters.Add("COL_Edited_Date", MySqlDbType.DateTime, 0);
scom.Parameters.Add("COL_Edited_User", MySqlDbType.Int32, 0);
scom.Parameters.Add("COL_Is_Active", MySqlDbType.Bit, 0);
scom.Parameters["COL_Id_Petty_Cash_Reimbursement"].Value = objCls.Id_Petty_Cash_Reimbursement;
scom.Parameters["COL_Id_Petty_Cash_Book"].Value = objCls.Id_Petty_Cash_Book;
scom.Parameters["COL_Amount_ThatShouldBe_Reimbursed"].Value = objCls.Amount_ThatShouldBe_Reimbursed;
scom.Parameters["COL_Reimbursement_Amount"].Value = objCls.Reimbursement_Amount;
scom.Parameters["COL_Balance_Carried_Forward"].Value = objCls.Balance_Carried_Forward;
scom.Parameters["COL_Petty_Cash_Reimbursement_Remark"].Value = objCls.Petty_Cash_Reimbursement_Remark;
scom.Parameters["COL_Created_Date"].Value = objCls.Created_Date;
scom.Parameters["COL_Created_User"].Value = objCls.Created_User;
scom.Parameters["COL_Edited_Date"].Value = objCls.Edited_Date;
scom.Parameters["COL_Edited_User"].Value = objCls.Edited_User;
scom.Parameters["COL_Is_Active"].Value = objCls.Is_Active;
scon.Open();
scom.ExecuteNonQuery();
scon.Close();
}
//protected void reimburseAmount_TextChanged(object sender, EventArgs e)
//{
// hfReimburseAmount.Value = reimburseAmount.Text.Trim();
// if (!((hfReimburseAmount.Value) == null || (hfReimburseAmount.Value) == ""))
// {
// double availableBalance = 0.00;
// double reimbursedAmount = 0.00;
// double amountToBeReimbursed = 0.00;
// availableBalance = Convert.ToDouble(PCBAvailableBalance.Text.Trim());
// reimbursedAmount = Convert.ToDouble(hfReimburseAmount.Value);
// amountToBeReimbursed = Convert.ToDouble(AmountToBeReimbursed.Text.Trim());
// if (amountToBeReimbursed >= reimbursedAmount)
// bcf.Text = (availableBalance + reimbursedAmount).ToString();
// //else
// // Message.Text = "You can not Reimburse an amount which will result exceed the Float amount";
// //has to get the Msgbox.dll
// }
// else
// bcf.Text = "";
//}
protected void cmdSubmit_Click(object sender, EventArgs e)
{
hfReimburseAmount.Value = reimburseAmount.Text.Trim();
if (!((hfReimburseAmount.Value) == null || (hfReimburseAmount.Value) == ""))
{
double reimbursedAmount = 0.00;
double amountToBeReimbursed = 0.00;
double balanceCarriedForward = 0.00;
reimbursedAmount = Convert.ToDouble(hfReimburseAmount.Value);
amountToBeReimbursed = Convert.ToDouble(AmountToBeReimbursed.Text.Trim());
balanceCarriedForward = Convert.ToDouble(PCBAvailableBalance.Text.Trim()) + reimbursedAmount;
hfBCF.Value=balanceCarriedForward.ToString();
if (Page.IsPostBack)
{
//insertPCRDetails();
if (cmdSubmit.CommandName.ToLower() == "SAVE".ToLower())
{
core_petty_cash_reimbursement pcrObj = new core_petty_cash_reimbursement();
core_petty_cash_reimbursement_Objects objPCR = new core_petty_cash_reimbursement_Objects();
objPCR.Id_Petty_Cash_Book = Convert.ToInt32(ddlPCBName.SelectedValue);
objPCR.Amount_ThatShouldBe_Reimbursed = Convert.ToDouble(AmountToBeReimbursed.Text.Trim());
objPCR.Reimbursement_Amount = Convert.ToDouble(reimburseAmount.Text.Trim());
objPCR.Balance_Carried_Forward = Convert.ToDouble(hfBCF.Value);
objPCR.Petty_Cash_Reimbursement_Remark = PCR_Remark.Text.Trim();
objPCR.Created_Date = DateTime.Now;
pcrObj.Insert(objPCR);
ScriptManager.RegisterStartupScript(this, GetType(), "insert", "showAlert('success');", true);
}
/////// added code below
if (cmdSubmit.CommandName.ToLower() == "SAVE".ToLower())
{
core_ledger_entry leObj = new core_ledger_entry();
core_ledger_entry_Objects objLE = new core_ledger_entry_Objects();
objLE.Id_Petty_Cash_Book = Convert.ToInt32(ddlPCBName.SelectedValue);
objLE.Id_Petty_Cash_Category = 42;
objLE.Id_Ledger_Account = 6;
//objLE.Id_Petty_Cash_Voucher = 0;
objLE.Business_Purpose = "Reimbursement";
//double x = Convert.ToDouble(hfIDLedgerAccountBCF.Value);
//double y = Convert.ToDouble(cashOutAmount.Text);
objLE.Credit_Amount = Convert.ToDouble(reimburseAmount.Text.Trim());
objLE.Balance_Carried_Forward = Convert.ToDouble(hfBCF.Value);
//double z = (x + y);
objLE.Created_Date = DateTime.Now;
//objLE.Post_Payment = payment_Type;
leObj.Insert(objLE);
}
//////////
/*if (cmdSubmit.CommandName.ToLower() == "SAVE".ToLower())
{
core_petty_cash_payment_voucher pcvObj = new core_petty_cash_payment_voucher();
core_petty_cash_payment_voucher_Objects objPCV = new core_petty_cash_payment_voucher_Objects();
//objPCV.Id_Petty_Cash_Voucher = Convert.ToInt32(PCV_Id.Text);
objPCV.Id_Petty_Cash_Book = Convert.ToInt32(ddlPCBName.SelectedValue);
objPCV.Id_Petty_Cash_Category = 42;
double result;
if (double.TryParse(PCBAvailableBalance.Text, out result))
objPCV.Available_Balance_Amount = Convert.ToDouble(PCBAvailableBalance.Text);
objPCV.Business_Purpose = "Reimbursement";
//objPCV.Cash_Out_Amount = Convert.ToDouble(cashOutAmount.Text);
objPCV.Received_By = "Shan";
//objPCV.Petty_Cash_Voucher_Remark = PCV_Remark.Text;
objPCV.Created_Date = DateTime.Now;
objPCV.Edited_Date = DateTime.Now;
//objPCV.Post_Payment = payment_Type;
objPCV.Is_Active = 1;
pcvObj.Insert(objPCV);
}*/
//////////
/////// added code ends
//updatePCBTable();
core_petty_cash_book pcbObj = new core_petty_cash_book();
pcbObj.UpdateMethod(@"UPDATE `core_petty_cash_book` SET `Available_Balance_Amount` = '" + Convert.ToDouble(hfBCF.Value) + @"' WHERE `Id_Petty_Cash_Book` = '" + Convert.ToInt32(ddlPCBName.SelectedValue) + @"' AND `Is_Active` = '0';");
clearFields();
Response.Redirect("PettyCashReimbursement.aspx", false);
}
}
else
{
//Message.Text
}
clearFields();
loadGrid();
}
