public static bool InsertSalesReturnDetails(SalesReturnDetails objSalesReturnDetails)
        {
            ISalesPOSDBManager dbManager = new SalesPOSDBManager();
            bool isSave = true;

            try
            {
                dbManager.Open();
                IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 7);

                param[0] = dbManager.getparam("@InvoiceNo", objSalesReturnDetails.InvoiceNo);
                param[1] = dbManager.getparam("@SalesReturnNo", objSalesReturnDetails.SalesReturnNo);
                param[2] = dbManager.getparam("@ProductID", objSalesReturnDetails.ProductID);
                param[3] = dbManager.getparam("@Quantity", Convert.ToInt64(objSalesReturnDetails.ReturnQuantity));
                param[4] = dbManager.getparam("@UnitID", Convert.ToInt64(objSalesReturnDetails.UnitID));
                param[5] = dbManager.getparam("@UnitSalesPrice", Convert.ToDouble(objSalesReturnDetails.UnitSalesPrice));
                param[6] = dbManager.getparam("@VatPercentage", Convert.ToDouble(objSalesReturnDetails.VatPerchantage));

                IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "[USP_SalesReturnProcess]", param);
                dbManager.ExecuteQuery(cmd);
            }
            catch (Exception ex)
            {
                isSave = false;
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                dbManager.Dispose();
            }
            return(isSave);
        }
Beispiel #2
0
 public static int addSalesRetrunDetails(SalesReturnDetails sale)
 {
     try
     {
         int i = salesReturnDetailsTempProvider.addSalesRetrunDetails(sale);
         return(i);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Beispiel #3
0
 public static int addSalesRetrunDetails(SalesReturnDetails sale, PusrchaseSaleAccount purchase)
 {
     try
     {
         int i = salesReturnDetailsProvider.addSalesRetrunDetails(sale, purchase);
         return(i);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public static int addDebitNote(SalesReturnDetails DebitNote, PusrchaseSaleAccount purchase)
 {
     try
     {
         int result = 0;
         result = DebitNoteProvider.addDebitNote(DebitNote, purchase);
         return(result);
     }
     catch (Exception ae)
     {
         throw ae;
     }
 }
Beispiel #5
0
        public static int addSalescreditNote(SalesReturnDetails creditNote, PusrchaseSaleAccount sale)
        {
            using (var Conn = new SqlConnection(_connectionString))
            {
                SqlHandler     sqlH  = new SqlHandler();
                SqlTransaction trans = null;
                try
                {
                    Conn.Open();
                    trans = Conn.BeginTransaction();
                    List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
                    parameter.Add(new KeyValuePair <string, object>("@creditNoteId", creditNote.salesReturnId));
                    parameter.Add(new KeyValuePair <string, object>("@creditNoteInvoiceId", creditNote.salesReturnInvoiceId));
                    parameter.Add(new KeyValuePair <string, object>("@financialYearID", creditNote.financialYearID));
                    parameter.Add(new KeyValuePair <string, object>("@creditNoteDate", creditNote.salesReturnDate));
                    parameter.Add(new KeyValuePair <string, object>("@state", creditNote.state));
                    parameter.Add(new KeyValuePair <string, object>("@stateCode", creditNote.stateCode));
                    parameter.Add(new KeyValuePair <string, object>("@customerId", creditNote.customerId));
                    parameter.Add(new KeyValuePair <string, object>("@creditNoteType", creditNote.salesType));
                    parameter.Add(new KeyValuePair <string, object>("@creditNoteAmount", creditNote.totalbillAmount));
                    parameter.Add(new KeyValuePair <string, object>("@naration", creditNote.naration));
                    parameter.Add(new KeyValuePair <string, object>("@paymentType", creditNote.paymentType));
                    parameter.Add(new KeyValuePair <string, object>("@bankName", creditNote.bankName));
                    parameter.Add(new KeyValuePair <string, object>("@bankId", creditNote.bankId));
                    parameter.Add(new KeyValuePair <string, object>("@chequeDate", creditNote.chequeDate));
                    parameter.Add(new KeyValuePair <string, object>("@refNo", creditNote.chequeNo_refNo));
                    parameter.Add(new KeyValuePair <string, object>("@isCustomerRetailer", creditNote.isCustomerRetailer));
                    parameter.Add(new KeyValuePair <string, object>("@isDelete", creditNote.isDelete));
                    //  parameter.Add(new KeyValuePair<string, object>("@AddSaleItem", creditNote.SaleItemTable));

                    int i = sqlH.ExecuteNonQueryTM("[dbo].[Usp_addCreditNoteMaster]", parameter, Conn, trans);
                    if (creditNote.isDelete == false)
                    {
                        List <KeyValuePair <string, object> > parameter2 = new List <KeyValuePair <string, object> >();
                        parameter2.Add(new KeyValuePair <string, object>("@transactionId", sale.transactionId));
                        parameter2.Add(new KeyValuePair <string, object>("@financialYearID", creditNote.financialYearID));
                        parameter2.Add(new KeyValuePair <string, object>("@transactionDate", creditNote.salesReturnDate));
                        parameter2.Add(new KeyValuePair <string, object>("@billId", sale.billId));
                        parameter2.Add(new KeyValuePair <string, object>("@Hamali", sale.Hamali));
                        parameter2.Add(new KeyValuePair <string, object>("@RoundOff", sale.RoundOff));
                        parameter2.Add(new KeyValuePair <string, object>("@discount", sale.discount));
                        parameter2.Add(new KeyValuePair <string, object>("@Igst5", sale.Igst5));
                        parameter2.Add(new KeyValuePair <string, object>("@Igst12", sale.Igst12));
                        parameter2.Add(new KeyValuePair <string, object>("@Igst18", sale.Igst18));
                        parameter2.Add(new KeyValuePair <string, object>("@Igst28", sale.Igst28));
                        parameter2.Add(new KeyValuePair <string, object>("@salePurchaseAccount", sale.salePurchaseAccount));
                        parameter2.Add(new KeyValuePair <string, object>("@issalePurchase", sale.issalePurchase));
                        parameter2.Add(new KeyValuePair <string, object>("@stateCode", sale.stateCode));
                        int s = sqlH.ExecuteNonQueryTM("[dbo].[Usp_addAllCreditNoteAccount]", parameter2, Conn, trans);
                    }
                    int result = 0;
                    for (int k = 0; k < creditNote.SaleRetrunItemTable.Rows.Count; k++)
                    {
                        List <KeyValuePair <string, object> > parameter1 = new List <KeyValuePair <string, object> >();
                        parameter1.Add(new KeyValuePair <string, object>("@creditNoteId", creditNote.salesReturnId));
                        parameter1.Add(new KeyValuePair <string, object>("@creditNoteInvoiceId", creditNote.salesReturnInvoiceId));
                        parameter1.Add(new KeyValuePair <string, object>("@financialYearID", creditNote.financialYearID));
                        parameter1.Add(new KeyValuePair <string, object>("@creditNoteDetailsId", creditNote.SaleRetrunItemTable.Rows[k]["salesReturnItemDetailsId"])); //4
                        parameter1.Add(new KeyValuePair <string, object>("@itemName", creditNote.SaleRetrunItemTable.Rows[k]["itemName"]));                            //8
                        parameter1.Add(new KeyValuePair <string, object>("@quantity", creditNote.SaleRetrunItemTable.Rows[k]["Quantity"]));                            //8
                        parameter1.Add(new KeyValuePair <string, object>("@batchNo", creditNote.SaleRetrunItemTable.Rows[k]["batchNo"]));                              //12
                        parameter1.Add(new KeyValuePair <string, object>("@unitBy", creditNote.SaleRetrunItemTable.Rows[k]["unitBy"]));                                //13
                        parameter1.Add(new KeyValuePair <string, object>("@rate", creditNote.SaleRetrunItemTable.Rows[k]["Rate"]));                                    //5
                        parameter1.Add(new KeyValuePair <string, object>("@IGST", creditNote.SaleRetrunItemTable.Rows[k]["IGST"]));                                    //16
                        parameter1.Add(new KeyValuePair <string, object>("@CGST", creditNote.SaleRetrunItemTable.Rows[k]["CGST"]));                                    //16
                        parameter1.Add(new KeyValuePair <string, object>("@SGST", creditNote.SaleRetrunItemTable.Rows[k]["SGST"]));                                    //16
                        parameter1.Add(new KeyValuePair <string, object>("@totalAmount", creditNote.SaleRetrunItemTable.Rows[k]["totalAmount"]));                      //16
                        parameter1.Add(new KeyValuePair <string, object>("@totalAmtWithGST", creditNote.SaleRetrunItemTable.Rows[k]["totalAmtWithGST"]));              //16
                        parameter1.Add(new KeyValuePair <string, object>("@isDelete", creditNote.isDelete));                                                           //19
                        result = sqlH.ExecuteNonQueryTM("Usp_addCreditNoteDetails", parameter1, Conn, trans);
                    }
                    trans.Commit();
                    return(i);
                }
                catch (Exception ex)
                {
                    if (trans != null)
                    {
                        trans.Rollback();
                    }
                    throw ex;
                }
                finally { Conn.Close(); }
            }
        }
Beispiel #6
0
        //public static DataTable getEmptySaleItem()
        //{
        //    try
        //    {

        //        SqlHandler sqlH = new SqlHandler();
        //        DataTable i = sqlH.ExecuteAsDataTable("[dbo].[Usp_getEmptySaleItem]");
        //        return i;
        //    }
        //    catch (Exception ae)
        //    {
        //        throw ae;
        //    }

        //}

        public static int addSalesRetrunDetails(SalesReturnDetails sale)
        {
            using (var Conn = new SqlConnection(_connectionString))
            {
                SqlHandler     sqlH  = new SqlHandler();
                SqlTransaction trans = null;
                try
                {
                    Conn.Open();
                    trans = Conn.BeginTransaction();
                    List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
                    parameter.Add(new KeyValuePair <string, object>("@salesReturnId", sale.salesReturnId));
                    parameter.Add(new KeyValuePair <string, object>("@salesReturnInvoiceId", sale.salesReturnInvoiceId));
                    parameter.Add(new KeyValuePair <string, object>("@financialYearID", sale.financialYearID));
                    parameter.Add(new KeyValuePair <string, object>("@salesReturnDate", sale.salesReturnDate));
                    parameter.Add(new KeyValuePair <string, object>("@customerId", sale.customerId));
                    parameter.Add(new KeyValuePair <string, object>("@salesType", sale.salesType));
                    parameter.Add(new KeyValuePair <string, object>("@totalbillAmount", sale.totalbillAmount));
                    parameter.Add(new KeyValuePair <string, object>("@paidAmount", sale.paidAmount));
                    parameter.Add(new KeyValuePair <string, object>("@paymentType", sale.paymentType));
                    parameter.Add(new KeyValuePair <string, object>("@bankName", sale.bankName));
                    parameter.Add(new KeyValuePair <string, object>("@bankId", sale.bankId));
                    parameter.Add(new KeyValuePair <string, object>("@chequeDate", sale.chequeDate));
                    parameter.Add(new KeyValuePair <string, object>("@refNo", sale.chequeNo_refNo));
                    parameter.Add(new KeyValuePair <string, object>("@addedBy", sale.addedBy));
                    parameter.Add(new KeyValuePair <string, object>("@addedOn", sale.addedOn));
                    parameter.Add(new KeyValuePair <string, object>("@state", sale.state));
                    parameter.Add(new KeyValuePair <string, object>("@stateCode", sale.stateCode));
                    parameter.Add(new KeyValuePair <string, object>("@isCustomerRetailer", sale.isCustomerRetailer));
                    parameter.Add(new KeyValuePair <string, object>("@isDelete", sale.isDelete));
                    parameter.Add(new KeyValuePair <string, object>("@saleInvoiceNo", sale.saleInvoiceNo));
                    parameter.Add(new KeyValuePair <string, object>("@saleDate", sale.saleDate));

                    //  parameter.Add(new KeyValuePair<string, object>("@AddSaleItem", sale.SaleItemTable));

                    int i      = sqlH.ExecuteNonQueryTM("[dbo].[Usp_addSalesReturnDetailsTemp]", parameter, Conn, trans);
                    int result = 0;
                    for (int k = 0; k < sale.SaleRetrunItemTable.Rows.Count; k++)
                    {
                        List <KeyValuePair <string, object> > parameter1 = new List <KeyValuePair <string, object> >();
                        parameter1.Add(new KeyValuePair <string, object>("@salesReturnInvoiceId", sale.salesReturnInvoiceId));                                        //1
                        parameter1.Add(new KeyValuePair <string, object>("@financialYearID", sale.financialYearID));                                                  //2
                        parameter1.Add(new KeyValuePair <string, object>("@itemId", sale.SaleRetrunItemTable.Rows[k]["itemId"]));                                     //3
                        parameter1.Add(new KeyValuePair <string, object>("@salesReturnItemDetailsId", sale.SaleRetrunItemTable.Rows[k]["salesReturnItemDetailsId"])); //4
                        parameter1.Add(new KeyValuePair <string, object>("@stockId", sale.SaleRetrunItemTable.Rows[k]["stockId"]));                                   //5
                        parameter1.Add(new KeyValuePair <string, object>("@companyId", sale.SaleRetrunItemTable.Rows[k]["companyId"]));                               //6
                        parameter1.Add(new KeyValuePair <string, object>("@categoryId", sale.SaleRetrunItemTable.Rows[k]["categoryId"]));                             //7
                        parameter1.Add(new KeyValuePair <string, object>("@Quantity", sale.SaleRetrunItemTable.Rows[k]["Quantity"]));                                 //8
                        parameter1.Add(new KeyValuePair <string, object>("@IGST", sale.SaleRetrunItemTable.Rows[k]["IGST"]));                                         //9
                        parameter1.Add(new KeyValuePair <string, object>("@CGST", sale.SaleRetrunItemTable.Rows[k]["CGST"]));                                         //10
                        parameter1.Add(new KeyValuePair <string, object>("@SGST", sale.SaleRetrunItemTable.Rows[k]["SGST"]));                                         //11
                        parameter1.Add(new KeyValuePair <string, object>("@batchNo", sale.SaleRetrunItemTable.Rows[k]["batchNo"]));                                   //12
                        parameter1.Add(new KeyValuePair <string, object>("@unitBy", sale.SaleRetrunItemTable.Rows[k]["unitBy"]));                                     //13
                        parameter1.Add(new KeyValuePair <string, object>("@discount", sale.SaleRetrunItemTable.Rows[k]["discount"]));                                 //14
                        parameter1.Add(new KeyValuePair <string, object>("@perQtysalePrice", sale.SaleRetrunItemTable.Rows[k]["Rate"]));                              //5
                        parameter1.Add(new KeyValuePair <string, object>("@salePrice", sale.SaleRetrunItemTable.Rows[k]["totalAmount"]));                             //16
                        parameter1.Add(new KeyValuePair <string, object>("@addedBy", sale.addedBy));                                                                  //17
                        parameter1.Add(new KeyValuePair <string, object>("@addedOn", sale.addedOn));                                                                  //18
                        parameter1.Add(new KeyValuePair <string, object>("@isDelete", sale.isDelete));                                                                //19

                        result = sqlH.ExecuteNonQueryTM("Usp_addSaleReturnStockUpdateTemp", parameter1, Conn, trans);
                    }

                    trans.Commit();
                    return(result);
                }
                catch (Exception ex)
                {
                    if (trans != null)
                    {
                        trans.Rollback();
                    }
                    throw ex;
                }
                finally { Conn.Close(); }
            }
        }
Beispiel #7
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (cmbDealerName.SelectedIndex < 0)
                {
                    if (Utility.Langn == "English")
                    {
                        MessageBox.Show("Please Add /Select customer name");
                    }
                    else
                    {
                        MessageBox.Show("कृपया ग्राहकाचे नाव भरा किवा निवडा..");
                    }
                    cmbDealerName.Focus();
                    return;
                }
                for (int i = 0; i < dgvSaleItems.Rows.Count; i++)
                {
                    if (dgvSaleItems.Rows[i].Cells[1].Value == null)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please Add Item Name in list");
                        }
                        else
                        {
                            MessageBox.Show("कृपया लिस्ट मध्ये वस्तूचे नाव भरा..");
                        }
                        dgvSaleItems.Focus();
                        dgvSaleItems.CurrentCell = dgvSaleItems.Rows[i].Cells[1];
                        return;
                    }
                    if (dgvSaleItems.Rows[i].Cells[2].Value == null)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please Add Batch No in list");
                        }
                        else
                        {
                            MessageBox.Show("कृपया लिस्ट मध्ये बॅच नंबर भरा");
                        }
                        dgvSaleItems.Focus();
                        dgvSaleItems.CurrentCell = dgvSaleItems.Rows[i].Cells[2];
                        return;
                    }
                    if (dgvSaleItems.Rows[i].Cells[3].Value == null)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please Add Quantity in list");
                        }
                        else
                        {
                            MessageBox.Show("कृपया लिस्ट मध्ये नग भरा");
                        }
                        dgvSaleItems.Focus();
                        dgvSaleItems.CurrentCell = dgvSaleItems.Rows[i].Cells[3];
                        return;
                    }
                    if (dgvSaleItems.Rows[i].Cells[4].Value == null)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please Add Paking in list");
                        }
                        else
                        {
                            MessageBox.Show("कृपया लिस्ट मध्ये पॅकींग भरा");
                        }
                        dgvSaleItems.Focus();
                        dgvSaleItems.CurrentCell = dgvSaleItems.Rows[i].Cells[3];
                        return;
                    }
                    if (dgvSaleItems.Rows[i].Cells[5].Value == null)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please Add rate in list");
                        }
                        else
                        {
                            MessageBox.Show("कृपया लिस्ट मध्ये दर भरा");
                        }
                        dgvSaleItems.Focus();
                        dgvSaleItems.CurrentCell = dgvSaleItems.Rows[i].Cells[3];
                        return;
                    }
                    if (dgvSaleItems.Rows[i].Cells[6].Value == null)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please add IGST(%) in list");
                        }
                        else
                        {
                            MessageBox.Show("कृपया लिस्ट मध्ये IGST(%) भरा");
                        }
                        dgvSaleItems.Focus();
                        dgvSaleItems.CurrentCell = dgvSaleItems.Rows[i].Cells[6];
                        return;
                    }
                    if (dgvSaleItems.Rows[i].Cells[7].Value == null)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please add CGST(%) in list");
                        }
                        else
                        {
                            MessageBox.Show("कृपया लिस्ट मध्ये CGST(%) भरा");
                        }
                        dgvSaleItems.Focus();
                        dgvSaleItems.CurrentCell = dgvSaleItems.Rows[i].Cells[7];
                        return;
                    }
                    if (dgvSaleItems.Rows[i].Cells[6].Value == null || Convert.ToDouble(dgvSaleItems.Rows[i].Cells[6].Value) == 0)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please Add Total Amount");
                        }
                        else
                        {
                            MessageBox.Show("कृपया लिस्ट मध्ये एकूण रक्कम भरा.");
                        }
                        dgvSaleItems.Focus();
                        dgvSaleItems.CurrentCell = dgvSaleItems.Rows[i].Cells[6];
                        return;
                    }
                }
                if (cmbPaymentType.Text.Equals("Cheque"))
                {
                    if (cmbBank.Text.Equals("") || cmbBank.Text.Equals("0"))
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please Add bank Name...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                        else
                        {
                            MessageBox.Show("कृपया बँकचे नाव  भरा...!", "त्रुटी", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                        cmbBank.Focus();
                        return;
                    }
                    else if (txtchqDDNo.Text.Equals("") || txtchqDDNo.Text.Equals("0"))
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please Add Cheque/DD Number...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                        else
                        {
                            MessageBox.Show("कृपया चेक / डीडी/रेफ  नंबर भरा...!", "त्रुटी", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                        txtchqDDNo.Focus();
                        return;
                    }
                }
                if (cmbPaymentType.Text.Equals("Card Payment"))
                {
                    if (cmbBank.Text.Equals("") || cmbBank.Text.Equals("0"))
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please Add bank Name...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                        else
                        {
                            MessageBox.Show("कृपया बँकचे नाव  भरा...!", "त्रुटी", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                        cmbBank.Focus();
                        return;
                    }
                    else if (txtchqDDNo.Text.Equals("") || txtchqDDNo.Text.Equals("0"))
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Please Add Cheque/DD Number...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                        else
                        {
                            MessageBox.Show("कृपया चेक / डीडी/रेफ  नंबर भरा...!", "त्रुटी", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                        txtchqDDNo.Focus();
                        return;
                    }
                }
                if (cmbPaymentType.Text.Equals("") || cmbPaymentType.Text.Equals("0"))
                {
                    if (Utility.Langn == "English")
                    {
                        MessageBox.Show("कृपया Payment प्रकार निवडा ..!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    else
                    {
                        MessageBox.Show("कृपया Payment प्रकार निवडा ..!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    cmbPaymentType.Focus();
                    return;
                }
                /// long customerId = 0;

                SalesReturnDetails purch = new SalesReturnDetails();
                purch.customerId = Convert.ToInt64(cmbDealerName.SelectedValue);
                DataTable dtSaleItems = new DataTable();

                foreach (DataGridViewColumn col in dgvSaleItems.Columns)
                {
                    dtSaleItems.Columns.Add(col.Name);
                }

                foreach (DataGridViewRow row in dgvSaleItems.Rows)
                {
                    DataRow dRow = dtSaleItems.NewRow();
                    foreach (DataGridViewCell cell in row.Cells)
                    {
                        if (cell.Value == null)
                        {
                            if (Utility.Langn == "English")
                            {
                                MessageBox.Show("Please Fill All details in List");
                            }
                            else
                            {
                                MessageBox.Show("कृपया लिस्ट मध्ये पूर्ण माहिती भरा");
                            }
                            return;
                        }

                        dRow[cell.ColumnIndex] = cell.Value;
                    }
                    dtSaleItems.Rows.Add(dRow);
                }

                purch.SaleRetrunItemTable = dtSaleItems;
                purch.salesReturnDate     = Convert.ToDateTime(dtpChallenDate.Value.ToShortDateString());
                if (isDelete == false)
                {
                    purch.salesReturnInvoiceId = debitNoteController.getMaxIdDebitNoteId(Utility.FinancilaYearId).ToString();
                }
                else
                {
                    purch.salesReturnInvoiceId = txtInvoiceNo.Text;
                }
                purch.financialYearID = Utility.FinancilaYearId;
                // txtInvoiceNo.Text = salesReturnDetailsController.getMaxIdSaleRetrunInvoiceId().ToString();
                if (rbCash.Checked == true)
                {
                    purch.salesType = "Cash";
                }
                if (rbCredit.Checked == true)
                {
                    purch.salesType = "Credit";
                }
                purch.paymentType     = cmbPaymentType.Text;
                purch.totalbillAmount = Utility.ParseValue(txtNetAmount.Text);
                purch.chequeDate      = dtpchedate.Value;
                purch.bankName        = cmbBank.Text;
                purch.state           = cmbIGST.Text;
                purch.stateCode       = txtStateCode.Text;
                purch.naration        = txtRemark.Text.Trim();
                purch.isDelete        = isDelete;
                if (cmbBank.SelectedIndex > 0)
                {
                    purch.bankId = Convert.ToInt32(cmbBank.SelectedValue);
                }
                else
                {
                    purch.bankId = 0;
                }
                purch.chequeNo_refNo = txtchqDDNo.Text;
                purch.addedBy        = Utility.LoginID;
                PusrchaseSaleAccount purchase = new PusrchaseSaleAccount();
                purchase.RoundOff            = Convert.ToDouble(0);
                purchase.Hamali              = Convert.ToDouble(0);
                purchase.discount            = Convert.ToDouble(0);
                purchase.billId              = Convert.ToInt64(purch.salesReturnInvoiceId);
                purchase.stateCode           = txtStateCode.Text;
                purchase.issalePurchase      = "CreditNote";
                purchase.Igst5               = IGST5;
                purchase.Igst12              = IGST12;
                purchase.Igst18              = IGST18;
                purchase.Igst28              = IGST28;
                purchase.salePurchaseAccount = Math.Round(Convert.ToDouble(txtNetAmount.Text) - (IGST5 + IGST12 + IGST18 + IGST28), 2);

                int ks = debitNoteController.addDebitNote(purch, purchase);
                if (ks > 0)
                {
                    if (purch.isDelete == false)
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Record Saved Successfully", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            MessageBox.Show("माहिती यशस्वीरित्या भरली गेली", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                    else
                    {
                        if (Utility.Langn == "English")
                        {
                            MessageBox.Show("Record Deleted Successfully", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            MessageBox.Show("माहिती यशस्वीरित्या डिलीट केली गेली", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                    }
                    // bill();
                    btnnew_Click(sender, e);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }