/// <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); }