/// <summary>
/// Saves a record to the core_petty_cash_payment_voucher table.
/// </summary>
public void Insert(core_petty_cash_payment_voucher_Objects objCls)
{
MySqlConnection scon = Connectivity.Cls_Connection.getConnection();
MySqlCommand scom = new MySqlCommand("core_petty_cash_payment_voucherInsert", scon);
scom.CommandType = CommandType.StoredProcedure;
scom.Parameters.Add("COL_Id_Petty_Cash_Voucher", MySqlDbType.Int32, 0);
scom.Parameters.Add("COL_Id_Petty_Cash_Book", MySqlDbType.Int32, 0);
scom.Parameters.Add("COL_Id_Petty_Cash_Category", MySqlDbType.Int32, 0);
scom.Parameters.Add("COL_Available_Balance_Amount", MySqlDbType.Double, 0);
scom.Parameters.Add("COL_Business_Purpose", MySqlDbType.Text, 65535);
scom.Parameters.Add("COL_Cash_Out_Amount", MySqlDbType.Double, 0);
scom.Parameters.Add("COL_Received_By", MySqlDbType.VarChar, 45);
scom.Parameters.Add("COL_Petty_Cash_Voucher_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.Add("COL_Post_Payment", MySqlDbType.Int32, 0);
scom.Parameters["COL_Id_Petty_Cash_Voucher"].Value = objCls.Id_Petty_Cash_Voucher;
scom.Parameters["COL_Id_Petty_Cash_Book"].Value = objCls.Id_Petty_Cash_Book;
scom.Parameters["COL_Id_Petty_Cash_Category"].Value = objCls.Id_Petty_Cash_Category;
scom.Parameters["COL_Available_Balance_Amount"].Value = objCls.Available_Balance_Amount;
scom.Parameters["COL_Business_Purpose"].Value = objCls.Business_Purpose;
scom.Parameters["COL_Cash_Out_Amount"].Value = objCls.Cash_Out_Amount;
scom.Parameters["COL_Received_By"].Value = objCls.Received_By;
scom.Parameters["COL_Petty_Cash_Voucher_Remark"].Value = objCls.Petty_Cash_Voucher_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;
scom.Parameters["COL_Post_Payment"].Value = objCls.Post_Payment;
scon.Open();
scom.ExecuteNonQuery();
scon.Close();
}
/// <summary>
/// Saves a record to the core_petty_cash_payment_voucher table.
/// </summary>
public void Insert(core_petty_cash_payment_voucher_Objects objCls)
{
MySqlConnection scon = Connectivity.Cls_Connection.getConnection();
MySqlCommand scom = new MySqlCommand("core_petty_cash_payment_voucherInsert", scon);
scom.CommandType = CommandType.StoredProcedure;
scom.Parameters.Add("COL_Id_Petty_Cash_Voucher", MySqlDbType.Int32,0);
scom.Parameters.Add("COL_Id_Petty_Cash_Book", MySqlDbType.Int32,0);
scom.Parameters.Add("COL_Id_Petty_Cash_Category", MySqlDbType.Int32,0);
scom.Parameters.Add("COL_Available_Balance_Amount", MySqlDbType.Double,0);
scom.Parameters.Add("COL_Business_Purpose", MySqlDbType.Text,65535);
scom.Parameters.Add("COL_Cash_Out_Amount", MySqlDbType.Double,0);
scom.Parameters.Add("COL_Received_By", MySqlDbType.VarChar,45);
scom.Parameters.Add("COL_Petty_Cash_Voucher_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.Add("COL_Post_Payment", MySqlDbType.Int32,0);
scom.Parameters["COL_Id_Petty_Cash_Voucher"].Value = objCls.Id_Petty_Cash_Voucher;
scom.Parameters["COL_Id_Petty_Cash_Book"].Value = objCls.Id_Petty_Cash_Book;
scom.Parameters["COL_Id_Petty_Cash_Category"].Value = objCls.Id_Petty_Cash_Category;
scom.Parameters["COL_Available_Balance_Amount"].Value = objCls.Available_Balance_Amount;
scom.Parameters["COL_Business_Purpose"].Value = objCls.Business_Purpose;
scom.Parameters["COL_Cash_Out_Amount"].Value = objCls.Cash_Out_Amount;
scom.Parameters["COL_Received_By"].Value = objCls.Received_By;
scom.Parameters["COL_Petty_Cash_Voucher_Remark"].Value = objCls.Petty_Cash_Voucher_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;
scom.Parameters["COL_Post_Payment"].Value = objCls.Post_Payment;
scon.Open();
scom.ExecuteNonQuery();
scon.Close();
}
private void insertPCVDetails()
{
int payment_Type;
if (selectedPost.Selected == true)
{
payment_Type = 0;
}
else if (selectedPre.Selected == true)
{
payment_Type = 1;
}
else
{
payment_Type = 2;
MessageBox.Show("Error! Please Select a Payment Type");
}
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 = Convert.ToInt32(ddlPCCName.SelectedValue);
double result;
if(double.TryParse(PCBAvailableBalance.Text,out result))
objPCV.Available_Balance_Amount = Convert.ToDouble(PCBAvailableBalance.Text);
objPCV.Business_Purpose=businessPurpose.Text;
objPCV.Cash_Out_Amount=Convert.ToDouble(cashOutAmount.Text);
objPCV.Received_By=receivedBy.Text;
objPCV.Petty_Cash_Voucher_Remark=PCV_Remark.Text;
objPCV.Created_Date=DateTime.Now;
objPCV.Edited_Date = DateTime.Now;
objPCV.Post_Payment= payment_Type;
pcvObj.Insert(objPCV);
}
if (cmdSubmit.CommandName.ToLower() == "SAVE".ToLower())
{
double availableBalance;
double cashoutamount;
availableBalance = 0.00;
cashoutamount = 0.00;
availableBalance =Convert.ToDouble(PCBAvailableBalance.Text);
cashoutamount = Convert.ToDouble(cashOutAmount.Text.Trim());
double newAmount = Convert.ToDouble(availableBalance - cashoutamount);
core_petty_cash_book pcbObj = new core_petty_cash_book();
pcbObj.UpdateMethod(@"UPDATE `core_petty_cash_book`
SET
`Available_Balance_Amount` = '" + newAmount + @"'
WHERE `Id_Petty_Cash_Book` = '" + Convert.ToInt32(ddlPCBName.SelectedValue) + @"';");
}
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 = Convert.ToInt32(ddlPCCName.SelectedValue);
objLE.Id_Ledger_Account = Convert.ToInt32(hfIDLedgerAccount.Value);
objLE.Id_Petty_Cash_Voucher = Convert.ToInt32(PCV_Id.Text);
objLE.Business_Purpose = businessPurpose.Text;
//double x = Convert.ToDouble(hfIDLedgerAccountBCF.Value);
//////
double x = Convert.ToDouble(PCBAvailableBalance.Text);
//////
double y = Convert.ToDouble(cashOutAmount.Text);
objLE.Debit_Amount = Convert.ToDouble(cashOutAmount.Text);
objLE.Balance_Carried_Forward = (x-y);
//double z = (x + y);
objLE.Created_Date = DateTime.Now;
objLE.Post_Payment = payment_Type;
leObj.Insert(objLE);
//core_ledger_account laObj = new core_ledger_account();
//laObj.UpdateMethod(@"UPDATE `core_ledger_account`
// SET
// `Balance_Carried_Forward` = '" + z + @"'
// WHERE `Id_Ledger_Account` = '" + Convert.ToInt32(hfIDLedgerAccount.Value) + @"';");
}
ScriptManager.RegisterStartupScript(this, GetType(), "insert", "showAlert('success');", true);
//this.clearFields();
//loadGrid();
//Response.Redirect("PettyCashVoucher.aspx", false);
}
