public static int addExpensesVoucher(AssetVoucher account)
{
try
{
int i = AssetVoucherProvider.addExpensesVoucher(account);
return(i);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// addExpensesVoucher Data Insert table
/// </summary>
/// <param name="account"></param>
/// <returns></returns>
public static int addExpensesVoucher(AssetVoucher account)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@voucherExpensesID", account.voucherAssetID)); //1
parameter.Add(new KeyValuePair <string, object>("@InvoiceNo", account.InvoiceNo)); //2
parameter.Add(new KeyValuePair <string, object>("@ExpensesDate", account.voucherDate)); //3
parameter.Add(new KeyValuePair <string, object>("@transactionId", account.transactionId)); //4
parameter.Add(new KeyValuePair <string, object>("@naveAccountId", account.naveAccountId)); //5
parameter.Add(new KeyValuePair <string, object>("@jamaAccountId", account.jamaAccountId)); //6
parameter.Add(new KeyValuePair <string, object>("@IGST", account.IGST)); //7
parameter.Add(new KeyValuePair <string, object>("@CGST", account.CGST)); //8
parameter.Add(new KeyValuePair <string, object>("@SGST", account.SGST)); //9
parameter.Add(new KeyValuePair <string, object>("@IGSTAmt", account.IGSTAmt)); //10
parameter.Add(new KeyValuePair <string, object>("@CGSTAmt", account.CGSTAmt)); //10
parameter.Add(new KeyValuePair <string, object>("@SGSTAmt", account.SGSTAmt)); //11
parameter.Add(new KeyValuePair <string, object>("@crAmount", account.crAmount)); //12
parameter.Add(new KeyValuePair <string, object>("@drAmount", account.drAmount)); //13
parameter.Add(new KeyValuePair <string, object>("@GSTRegister", account.GSTRegister)); //14
parameter.Add(new KeyValuePair <string, object>("@isState", account.isState)); //15
parameter.Add(new KeyValuePair <string, object>("@isCash", account.isCash)); //16
parameter.Add(new KeyValuePair <string, object>("@PaymentType", account.PaymentType)); //17
parameter.Add(new KeyValuePair <string, object>("@chqDate", account.chqDate)); //18
parameter.Add(new KeyValuePair <string, object>("@chqDDNo", account.chqDDNo)); //19
parameter.Add(new KeyValuePair <string, object>("@naration", account.naration)); //20
parameter.Add(new KeyValuePair <string, object>("@bankId", account.bankId)); //21
parameter.Add(new KeyValuePair <string, object>("@bankName", account.bankName)); //21
parameter.Add(new KeyValuePair <string, object>("@addedBy", 1)); //22
parameter.Add(new KeyValuePair <string, object>("@addedOn", DateTime.Now)); //23
parameter.Add(new KeyValuePair <string, object>("@isUpdate", account.isUpdate)); //24
parameter.Add(new KeyValuePair <string, object>("@FinancialYearID", account.FinancialYearID)); //25
SqlHandler sqlH = new SqlHandler();
int i = sqlH.ExecuteNonQueryI("[dbo].[Usp_addExpensesVoucher]", parameter);
return(i);
}
catch (Exception ex)
{
throw ex;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (cmbNaveAccountName.SelectedIndex == 0 || cmbNaveAccountName.SelectedValue == null)
{
if (Utility.Langn == "English")
{
MessageBox.Show("Please Select Nave Account Name ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("कृपया नावे खात्याचे नांव निवडा ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
cmbNaveAccountName.Focus();
return;
}
if (cmbAccountSupGroup.SelectedIndex == 0 || cmbAccountSupGroup.SelectedValue == null)
{
if (Utility.Langn == "English")
{
MessageBox.Show("Please Select Account Group SubGroup Type...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("कृपया खाते गट उपप्रकार निवडा ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
cmbAccountSupGroup.Focus();
return;
}
if (cmbJamaAccountName.SelectedIndex == 0 || cmbJamaAccountName.SelectedValue == null)
{
if (Utility.Langn == "English")
{
MessageBox.Show("Please select Jama Account Name ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("कृपया जमा खात्याचे नांव निवडा ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
cmbJamaAccountName.Focus();
return;
}
if (txtCrAmount.Text.Trim() == string.Empty || txtCrAmount.Text.Trim() == "0")
{
if (Utility.Langn == "English")
{
MessageBox.Show("Please Add Nave Amount ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("कृपया नावे रक्कम भरा ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
txtCrAmount.Focus();
return;
}
if (chbCash.Checked == true)
{
if (txtDrAmount.Text.Trim() == string.Empty || txtDrAmount.Text.Trim() == "0")
{
if (Utility.Langn == "English")
{
MessageBox.Show("Please Add Paid Amount ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("कृपया जमा रक्कम भरा:- ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
txtDrAmount.Focus();
return;
}
}
AssetVoucher asset = new AssetVoucher();
asset.voucherAssetID = voucherAssetID1;
asset.transactionId = transactionId1;
asset.FinancialYearID = Utility.FinancilaYearId;
if (txtInvoice.Text == string.Empty)
{
asset.InvoiceNo = "0";
}
else
{
asset.InvoiceNo = txtInvoice.Text.Trim();
}
asset.voucherDate = dtpDate.Value;
asset.naveAccountId = Convert.ToInt64(cmbNaveAccountName.SelectedValue);
asset.jamaAccountId = Convert.ToInt64(cmbJamaAccountName.SelectedValue);
asset.crAmount = Convert.ToDecimal(Utility.ParseValue(txtCrAmount.Text));
if (txtDrAmount.Text == string.Empty)
{
asset.drAmount = 0;
}
else
{
asset.drAmount = Convert.ToDecimal(Utility.ParseValue(txtDrAmount.Text));
}
asset.GSTRegister = chbGSTRegister.Checked;
asset.isState = cnkState.Checked;
asset.isCash = chbCash.Checked;
if (cmbPaymentType.SelectedIndex == 0)
{
asset.bankId = 0;
}
else
{
asset.bankId = Convert.ToInt32(cmbBank.SelectedValue);
}
asset.bankName = cmbBank.Text.Trim();
asset.naration = txtNaration.Text.Trim();
asset.PaymentType = cmbPaymentType.Text.Trim();
asset.chqDDNo = txtchqDDNo.Text.Trim();
asset.chqDate = dtpchedate.Value;
asset.isUpdate = isUpdate;
asset.addedBy = Utility.LoginID;
if (chbGSTRegister.Checked == true)
{
if (txtIGST.SelectedIndex > 0)
{
asset.IGST = Convert.ToDecimal(Utility.ParseValue(txtIGST.Text.Trim()));
asset.CGST = Convert.ToDecimal(Utility.ParseValue(txtIGST.Text.Trim())) / 2;
asset.SGST = Convert.ToDecimal(Utility.ParseValue(txtIGST.Text.Trim())) / 2;
}
else
{
asset.IGST = 0;
asset.CGST = 0;
asset.SGST = 0;
}
if (txtCGSTAmt.Text == string.Empty)
{
txtCGSTAmt.Text = "0";
}
if (txtCGSTAmt.Text == string.Empty)
{
txtSGSTAmt.Text = "0";
}
asset.CGSTAmt = Convert.ToDecimal(Utility.ParseValue(txtCGSTAmt.Text.Trim()));
asset.SGSTAmt = Convert.ToDecimal(Utility.ParseValue(txtSGSTAmt.Text.Trim()));
asset.IGSTAmt = asset.CGSTAmt + asset.SGSTAmt;
}
else
{
asset.IGST = 0;
asset.CGST = 0;
asset.SGST = 0;
asset.CGSTAmt = 0;
asset.SGSTAmt = 0;
asset.IGSTAmt = 0;
}
int s = AssetVoucherController.addAssetVoucher(asset);
if (s > 0)
{
if (Utility.Langn == "English")
{
MessageBox.Show("Record Saved Successfully ...!", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("सदर माहिती यशस्वीरित्या साठवले गेले आहे..", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
btnnew_Click(sender, e);
}
else
{
if (Utility.Langn == "English")
{
MessageBox.Show("Record Does not Saved Successfully ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("सदर माहिती यशस्वीरित्या साठवले गेले नाही आहे ..", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}