/// <summary>
/// Function to reset form
/// </summary>
///
public void invoiceNumberfill()
{
decimal decVoucherTypeId = 0;
DataTable dtblc = new DataTable();
try
{
if (cmpvoucherType.SelectedIndex > -1)
{
if (cmpvoucherType.SelectedValue.ToString() != "System.Data.DataRowView" && cmpvoucherType.Text != "System.Data.DataRowView")
{
SalesReturnMasterSP mastersp = new SalesReturnMasterSP();
decVoucherTypeId = Convert.ToDecimal(cmpvoucherType.SelectedValue.ToString());
dtblc = mastersp.invoicenumberviewallforvouchertypeIdforSR(decVoucherTypeId);
DataRow drow = dtblc.NewRow();
drow["invoiceNo"] = "All";
dtblc.Rows.InsertAt(drow, 0);
cmbInvoiceNo.DataSource = dtblc;
cmbInvoiceNo.ValueMember = "salesReturnMasterId";
cmbInvoiceNo.DisplayMember = "invoiceNo";
}
}
}
catch (Exception ex)
{
MessageBox.Show("SRR16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to reset form
/// </summary>
///
public void invoiceNumberfill()
{
decimal decVoucherTypeId = 0;
DataTable dtblc = new DataTable();
try
{
if (cmpvoucherType.SelectedIndex > -1)
{
if (cmpvoucherType.SelectedValue.ToString() != "System.Data.DataRowView" && cmpvoucherType.Text != "System.Data.DataRowView")
{
SalesReturnMasterSP mastersp = new SalesReturnMasterSP();
decVoucherTypeId = Convert.ToDecimal(cmpvoucherType.SelectedValue.ToString());
dtblc = mastersp.invoicenumberviewallforvouchertypeIdforSR(decVoucherTypeId);
DataRow drow = dtblc.NewRow();
drow["invoiceNo"] = "All";
dtblc.Rows.InsertAt(drow, 0);
cmbInvoiceNo.DataSource = dtblc;
cmbInvoiceNo.ValueMember = "salesReturnMasterId";
cmbInvoiceNo.DisplayMember = "invoiceNo";
}
}
}
catch (Exception ex)
{
MessageBox.Show("SRR16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to generate Voucher number as per settings
/// </summary>
public void VoucherNumberGeneration()
{
try
{
TransactionsGeneralFill obj = new TransactionsGeneralFill();
SalesReturnMasterSP spSalesReturn = new SalesReturnMasterSP();
string strPrefix = string.Empty;
string strSuffix = string.Empty;
string strReturnNo = string.Empty;
string tableName = "SalesReturnMaster";
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decSalesReturnVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
if (Convert.ToDecimal(strVoucherNo) != spSalesReturn.SalesReturnMasterGetMaxPlusOne(decSalesReturnVoucherTypeId))
{
strVoucherNo = spSalesReturn.SalesReturnMasterGetMax(decSalesReturnVoucherTypeId).ToString();
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decSalesReturnVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
if (spSalesReturn.SalesReturnMasterGetMax(decSalesReturnVoucherTypeId) == "0")
{
strVoucherNo = "0";
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decSalesReturnVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
}
}
if (isAutomatic)
{
SuffixPrefixSP spSuffisprefix = new SuffixPrefixSP();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = spSuffisprefix.GetSuffixPrefixDetails(decSalesReturnVoucherTypeId, dtpDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
decSalesReturnSuffixPrefixId = infoSuffixPrefix.SuffixprefixId;
strReturnNo = strPrefix + strVoucherNo + strSuffix;
txtReturnNo.Text = strReturnNo;
txtReturnNo.ReadOnly = true;
}
}
catch (Exception ex)
{
MessageBox.Show("SR69:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the SalesReturn VoucherType ComboFill
/// </summary>
/// <param name="ledgerIdFromCashOrPartyCombo"></param>
public void SalesReturnVoucherTypeComboFill(decimal ledgerIdFromCashOrPartyCombo)
{
try
{
SalesReturnMasterSP salesReturnMasterSP = new SalesReturnMasterSP();
DataTable dtbl = new DataTable();
dtbl = salesReturnMasterSP.SalesReturnVoucherTypeComboFill(ledgerIdFromCashOrPartyCombo);
cmbVoucherType.DataSource = dtbl;
if (cmbVoucherType.DataSource != null)
{
DataRow dr = dtbl.NewRow();
dr["voucherTypeId"] = 0;
dr["voucherTypeName"] = "NA";
dtbl.Rows.InsertAt(dr, 0);
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DisplayMember = "voucherTypeName";
cmbVoucherType.SelectedIndex = -1;
}
}
catch (Exception ex)
{
MessageBox.Show("SR56:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// FunctionforVouchertypecombofill
/// </summary>
public void VoucherTypeCombofill()
{
try
{
DataTable dtbl = new DataTable();
SalesReturnMasterSP spmaster = new SalesReturnMasterSP();
dtbl = spmaster.vouchertypecompofill();
cmbVoucherType.DataSource = dtbl;
cmbVoucherType.ValueMember = "voucherTypeId";
cmbVoucherType.DisplayMember = "voucherTypeName";
}
catch (Exception ex)
{
MessageBox.Show("SR:67" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the Combo Selection By using InvoiceNo
/// </summary>
public void ComboSelectionByInvoiceNo()
{
DataTable dtblComboSelection = new DataTable();
SalesReturnMasterSP spSalesReturnMaster = new SalesReturnMasterSP();
try
{
if (!isEnterIntoComboSelectn == false)
{
if (cmbInvoiceNo.SelectedIndex != -1)
{
if (cmbInvoiceNo.SelectedValue.ToString() != "System.Data.DataRowView" && cmbInvoiceNo.Text != "System.Data.DataRowView")
{
DGVGodownComboFill();
DGVUnitComboFill();
decTotalAmounForSaveCheck = 0;
SalesMasterSP spSaleMaster = new SalesMasterSP();
dgvSalesReturn.Rows.Clear();
dtblComboSelection = spSaleMaster.SalesMasterViewByInvoiceNoForComboSelection(Convert.ToDecimal(cmbInvoiceNo.SelectedValue.ToString()));
if (dtblComboSelection != null)
{
cmbPricingLevel.SelectedValue = dtblComboSelection.Rows[0]["pricingLevelId"];
cmbSalesAccount.SelectedValue = dtblComboSelection.Rows[0]["salesAccount"];
cmbSalesAccount.Enabled = true;
txtTransportationComp.Text = dtblComboSelection.Rows[0]["transportationCompany"].ToString();
txtLRNo.Text = dtblComboSelection.Rows[0]["lrNo"].ToString();
}
DataTable dtblSalesReturnGrideFill = spSalesDetails.SalesDetailsViewForSalesReturnGrideFill(Convert.ToDecimal(cmbInvoiceNo.SelectedValue.ToString()), salesReturnMasterId);
dtblSalesInvoice = dtblSalesReturnGrideFill;
foreach (DataRow drowDetails in dtblSalesReturnGrideFill.Rows)
{
decimal decproductId = Convert.ToDecimal(drowDetails["productId"].ToString());
TaxGridFill();
dgvSalesReturn.Rows.Add();
if (drowDetails["S.No"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvSNo"].Value = drowDetails["S.No"].ToString();
}
if (drowDetails["salesDetailsId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["salesDetailsId"].Value = drowDetails["salesDetailsId"].ToString();
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["salesDetailsId"].Value = 0;
}
if (drowDetails["productId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["productId"].Value = drowDetails["productId"].ToString();
DataTable dtbl = spSalesDetails.SalesDetailsViewForSalesReturnGrideFill1(Convert.ToDecimal(drowDetails["productId"].ToString()));
foreach (DataRow drowDetails1 in dtbl.Rows)
{
if (dtblComboSelection.Rows[0]["voucherTypeId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["voucherTypeId"].Value = Convert.ToDecimal(dtblComboSelection.Rows[0]["voucherTypeId"].ToString());
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["voucherTypeId"].Value = 0;
}
if (dtblComboSelection.Rows[0]["voucherNo"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["voucherNo"].Value = dtblComboSelection.Rows[0]["voucherNo"].ToString();
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["voucherNo"].Value = 0;
}
if (dtblComboSelection.Rows[0]["invoiceNo"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["invoiceNo"].Value = dtblComboSelection.Rows[0]["invoiceNo"].ToString();
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["invoiceNo"].Value = 0;
}
if (drowDetails1["barcode"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextBarcode"].Value = drowDetails1["barcode"].ToString();
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextBarcode"].ReadOnly = true;
}
if (drowDetails1["productCode"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextProductCode"].Value = drowDetails1["productCode"].ToString();
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextProductCode"].ReadOnly = true;
}
if (drowDetails1["productName"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextProductName"].Value = drowDetails1["productName"].ToString();
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextProductName"].ReadOnly = true;
}
if (drowDetails["unitId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbUnit"].Value = Convert.ToDecimal(drowDetails["unitId"].ToString());
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbUnit"].ReadOnly = true;
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbUnit"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbUnit"].Value = 1;
}
if (drowDetails["goDownId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbGodown"].Value = Convert.ToDecimal(drowDetails["goDownId"].ToString());
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbGodown"].ReadOnly = false;
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbGodown"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbGodown"].Value = 1;
}
RackComboFill(Convert.ToDecimal(dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbGodown"].Value), dgvSalesReturn.Rows.Count - 2, dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbRack"].ColumnIndex);
if (drowDetails["rackId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbRack"].Value = Convert.ToDecimal(drowDetails["rackId"].ToString());
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbRack"].Value = 1;
}
BatchComboFill(Convert.ToDecimal(dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["productId"].Value), dgvSalesReturn.Rows.Count - 2, dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbBatch"].ColumnIndex);
if (drowDetails["batchId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbBatch"].Value = Convert.ToDecimal(drowDetails["batchId"].ToString());
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbBatch"].ReadOnly = true;
}
if (drowDetails["unitConversionId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["unitConversionId"].Value = drowDetails["unitConversionId"].ToString();
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["unitConversionId"].Value = 0;
}
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["conversionRate"].Value = drowDetails["conversionRate"].ToString();
if (drowDetails["taxId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTaxId"].Value = 0;
if (Convert.ToDecimal(drowDetails["taxId"].ToString()) != 0)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTaxId"].Value = Convert.ToDecimal(drowDetails["taxId"].ToString());
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbTax"].Value = Convert.ToDecimal(drowDetails["taxId"].ToString());
strTaxRate = spSalesReturnMaster.TaxRateFindForTaxAmmountCalByTaxId(Convert.ToDecimal(drowDetails["taxId"].ToString()));
}
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbTax"].Value = 1;
}
if (drowDetails["qty"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextQty"].Value = Math.Round(Convert.ToDecimal(drowDetails["qty"].ToString()), PublicVariables._inNoOfDecimalPlaces);
decQty = Math.Round(Convert.ToDecimal(drowDetails["qty"].ToString()), PublicVariables._inNoOfDecimalPlaces);
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextQty"].Value = 0;
decQty = 0;
}
if (drowDetails["rate"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextRate"].Value = Convert.ToDecimal(drowDetails["rate"].ToString());
decRate = Convert.ToDecimal(drowDetails["rate"].ToString());
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextRate"].Value = 0.00;
decRate = 0;
}
if (drowDetails["grossAmount"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].Value = Math.Round(Convert.ToDecimal(drowDetails["grossAmount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].ReadOnly = true;
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].Value = 0.00;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].ReadOnly = true;
}
if (drowDetails["discount"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextDiscountPercentage"].Value = 0.00;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextDiscountAmount"].Value = Math.Round(Convert.ToDecimal(drowDetails["discount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextDiscountAmount"].Value = 0.00;
}
if (drowDetails["netAmount"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].Value = Math.Round(Convert.ToDecimal(drowDetails["netAmount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].ReadOnly = true;
txtBillDiscount.Text = "0.00";
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].Value = 0.00;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].ReadOnly = true;
}
if (drowDetails["taxAmount"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].Value = Math.Round(Convert.ToDecimal(drowDetails["taxAmount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].Value = 0.00;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].ReadOnly = true;
}
if (drowDetails["amount"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextAmount1"].Value = Math.Round(Convert.ToDecimal(drowDetails["amount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextAmount1"].ReadOnly = true;
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextAmount1"].Value = 0.00;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextAmount1"].ReadOnly = true;
}
if (cmbInvoiceNo.Visible == true)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextBarcode"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextProductCode"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextProductName"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextQty"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvCmbUnit"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvCmbGodown"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvCmbRack"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvCmbBatch"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextRate"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextDiscountPercentage"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvCmbTax"].ReadOnly = true;
}
foreach (DataGridViewRow item1 in dgvSalesReturn2.Rows)
{
if (item1.Cells["dgvTextTaxId"].Value != null)
{
if (dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbTax"].Value != null && dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbTax"].Value.ToString() != string.Empty)
{
if (dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbTax"].Value.ToString() == item1.Cells["dgvTextTaxId"].Value.ToString())
{
item1.Cells["dgvTextAmount"].Value = dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].Value;
}
}
}
}
}
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["productId"].Value = 0;
}
}
txtNarration.Text = dtblComboSelection.Rows[0]["narration"].ToString();
GrossValueCalculation(dgvSalesReturn.Rows.Count - 2);
DiscountCalculationfordiscountpercentage(dgvSalesReturn.Rows.Count - 2, 12);
DiscountCalculation(dgvSalesReturn.Rows.Count - 2, 13);
TaxAmountCalculation(dgvSalesReturn.Rows.Count - 2);
TotalAmtCalculation();
TotalBillTaxCalculation();
GrandTotalCalculation();
taxamountfill();
taxAndGridTotalAmountCalculation(dgvSalesReturn.Rows.Count - 2);
CessTaxamountCalculation();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("SR46:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the SalesReturn InvoiceNo ComboFill
/// </summary>
/// <param name="decVoucherTypeId"></param>
/// <param name="salesReturnMasterId"></param>
/// <param name="decledgerId"></param>
public void SalesReturnInvoiceNoComboFill(decimal decVoucherTypeId, decimal salesReturnMasterId, decimal decledgerId)
{
try
{
SalesReturnMasterSP salesReturnMasterSP = new SalesReturnMasterSP();
DataTable dtbl = new DataTable();
dtbl = salesReturnMasterSP.SalesReturnInvoiceNoComboFill(decVoucherTypeId, salesReturnMasterId, decledgerId);
cmbInvoiceNo.DataSource = dtbl;
if (cmbInvoiceNo.DataSource != null)
{
cmbInvoiceNo.ValueMember = "salesMasterId";
cmbInvoiceNo.DisplayMember = "invoiceNo";
cmbInvoiceNo.SelectedIndex = -1;
}
isEnterIntoComboSelectn = true;
}
catch (Exception ex)
{
MessageBox.Show("SR55:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// FunctionToRemoveIncmpletedRow
/// </summary>
/// <returns></returns>
public bool RemoveIncompleteRowsFromGrid()
{
SalesReturnMasterSP spSalesReturnMaster = new SalesReturnMasterSP();
bool isOk = true;
try
{
string strMessage = "Rows";
int inC = 0, inForFirst = 0;
int inRowcount = dgvSalesReturn.RowCount;
int inLastRow = 1;
if (inRowcount <= 2)
{
if (dgvSalesReturn.Rows[0].Cells["dgvTextProductName"].Value == null || dgvSalesReturn.Rows[0].Cells["dgvTextProductName"].Value.ToString() == string.Empty ||
dgvSalesReturn.Rows[0].Cells["dgvTextProductCode"].Value == null || dgvSalesReturn.Rows[0].Cells["dgvTextProductCode"].Value.ToString() == string.Empty ||
dgvSalesReturn.Rows[0].Cells["dgvTextQty"].Value == null || dgvSalesReturn.Rows[0].Cells["dgvTextQty"].Value.ToString().Trim() == string.Empty ||
Convert.ToDecimal(dgvSalesReturn.Rows[0].Cells["dgvTextQty"].Value.ToString()) == 0 || dgvSalesReturn.Rows[0].Cells["dgvTextRate"].Value == null || dgvSalesReturn.Rows[0].Cells["dgvTextRate"].Value.ToString().Trim() == string.Empty ||
(spSettings.SettingsStatusCheck("AllowZeroValueEntry") == "No" && Convert.ToDecimal(dgvSalesReturn.CurrentRow.Cells["dgvTextRate"].Value) == 0))
{
MessageBox.Show("Can't save purchase return without atleast one product with complete details", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgvSalesReturn.ClearSelection();
dgvSalesReturn.Focus();
isOk = false;
}
}
else
{
foreach (DataGridViewRow dgvrowCur in dgvSalesReturn.Rows)
{
if (inLastRow < inRowcount)
{
if (dgvrowCur.HeaderCell.Value != null)
{
if (dgvrowCur.HeaderCell.Value.ToString() == "X" || dgvrowCur.Cells["dgvTextProductName"].Value == null)
{
isOk = false;
if (inC == 0)
{
strMessage = strMessage + Convert.ToString(dgvrowCur.Index + 1);
inForFirst = dgvrowCur.Index;
inC++;
}
else
{
strMessage = strMessage + ", " + Convert.ToString(dgvrowCur.Index + 1);
}
}
}
}
inLastRow++;
}
inLastRow = 1;
if (!isOk)
{
strMessage = strMessage + " contains invalid entries. Do you want to continue?";
if (MessageBox.Show(strMessage, "OpenMiracle", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
isOk = true;
for (int inK = 0; inK < dgvSalesReturn.Rows.Count; inK++)
{
if (dgvSalesReturn.Rows[inK].HeaderCell.Value != null && dgvSalesReturn.Rows[inK].HeaderCell.Value.ToString() == "X")
{
if (!dgvSalesReturn.Rows[inK].IsNewRow)
{
dgvSalesReturn.Rows.RemoveAt(inK);
inK--;
}
}
}
}
else
{
isOk = false;
dgvSalesReturn.Rows[inForFirst].Cells["dgvTextProductName"].Selected = true;
dgvSalesReturn.CurrentCell = dgvSalesReturn.Rows[inForFirst].Cells["dgvTextProductName"];
dgvSalesReturn.Focus();
}
}
}
//SerialNo();
}
catch (Exception ex)
{
MessageBox.Show("SR:4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return isOk;
}
/// <summary>
/// Function to save an item into table
/// </summary>
public void Save()
{
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
SalesReturnMasterSP spSalesReturnMaster = new SalesReturnMasterSP();
SalesReturnDetailsSP spSalesReturnDetails = new SalesReturnDetailsSP();
StockPostingSP spStockPosting = new StockPostingSP();
LedgerPostingSP spLedgerPosting = new LedgerPostingSP();
PartyBalanceSP spPartyBalance = new PartyBalanceSP();
UnitConvertionSP spUnitConvertion = new UnitConvertionSP();
UnitSP spUnit = new UnitSP();
try
{
if (txtReturnNo.Text.Trim() == string.Empty)
{
MessageBox.Show("Enter return no", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtReturnNo.Focus();
}
else if (spSalesReturnMaster.SalesReturnNumberCheckExistence(txtReturnNo.Text.Trim(), 0, decSalesReturnVoucherTypeId) == true && btnSave.Text == "Save")
{
Messages.InformationMessage("Return number already exist");
txtReturnNo.Focus();
}
//else if ((txtReturnNo .Text!=ManualReturnNo)&&(spSalesReturnMaster.SalesReturnNumberCheckExistence(txtReturnNo.Text.Trim(), 0, decSalesReturnVoucherTypeId) == true && btnSave.Text == "Update"))
//{
// Messages.InformationMessage("Return number already exist");
// txtReturnNo.Focus();
//}
else if (txtDate.Text == "")
{
MessageBox.Show("Select a date in between financial year", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtDate.Focus();
}
else if (cmbCashOrParty.SelectedValue == null)
{
MessageBox.Show("Select cash/party", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbCashOrParty.Focus();
}
else if (cmbSalesAccount.SelectedValue == null)
{
MessageBox.Show("Select sales account", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbSalesAccount.Focus();
}
else if (cmbCurrency.SelectedValue == null)
{
MessageBox.Show("Select currency", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbCurrency.Focus();
}
else
{
if (isAutomatic)
{
if (strVoucherNo != string.Empty)
{
infoSalesReturnMaster.VoucherNo = strVoucherNo;
}
if (txtReturnNo.Text != string.Empty)
{
infoSalesReturnMaster.InvoiceNo = txtReturnNo.Text;
}
}
else
{
infoSalesReturnMaster.VoucherNo = txtReturnNo.Text;
infoSalesReturnMaster.InvoiceNo = txtReturnNo.Text;
}
if (decSalesReturnVoucherTypeId != 0)
{
infoSalesReturnMaster.VoucherTypeId = decSalesReturnVoucherTypeId;
}
if (decSalesReturnSuffixPrefixId != 0)
{
infoSalesReturnMaster.SuffixPrefixId = decSalesReturnSuffixPrefixId;
}
if (cmbCashOrParty.SelectedValue != null)
{
infoSalesReturnMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
}
if (cmbInvoiceNo.SelectedValue != null)
{
infoSalesReturnMaster.SalesMasterId = Convert.ToDecimal(cmbInvoiceNo.SelectedValue.ToString());
}
else
{
infoSalesReturnMaster.SalesMasterId = 0;
}
if (cmbSalesAccount.SelectedValue != null)
{
infoSalesReturnMaster.SalesAccount = Convert.ToDecimal(cmbSalesAccount.SelectedValue.ToString());
}
if (cmbPricingLevel.SelectedValue != null)
{
infoSalesReturnMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
}
else
{
infoSalesReturnMaster.PricinglevelId = 0;
}
if (cmbSalesMan.SelectedValue != null)
{
infoSalesReturnMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
else
{
infoSalesReturnMaster.EmployeeId = 0;
}
if (cmbCurrency.SelectedValue != null)
{
infoSalesReturnMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
decExchangeRate = spExchangeRate.ExchangeRateViewByExchangeRateId(infoSalesReturnMaster.ExchangeRateId);
}
infoSalesReturnMaster.Narration = txtNarration.Text.Trim();
infoSalesReturnMaster.UserId = PublicVariables._decCurrentUserId;
infoSalesReturnMaster.LrNo = txtLRNo.Text.Trim();
infoSalesReturnMaster.TransportationCompany = txtTransportationComp.Text.Trim();
infoSalesReturnMaster.Date = Convert.ToDateTime(txtDate.Text);
if (txtTotalAmount.Text != string.Empty)
{
infoSalesReturnMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
}
if (txtGrandTotal.Text != string.Empty)
{
infoSalesReturnMaster.grandTotal = Convert.ToDecimal(txtGrandTotal.Text);
}
if (lblTaxAmount.Text != string.Empty)
{
infoSalesReturnMaster.TaxAmount = Convert.ToDecimal(lblTaxAmount.Text);
}
infoSalesReturnMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoSalesReturnMaster.Extra1 = string.Empty;
infoSalesReturnMaster.Extra2 = string.Empty;
if (txtBillDiscount.Text != string.Empty)
{
infoSalesReturnMaster.Discount = Convert.ToDecimal(txtBillDiscount.Text);
}
else
{
infoSalesReturnMaster.Discount = 0;
}
decimal decNetTotal = 0;
decimal decGrandTotal = 0;
string strQuantities = string.Empty;
if (btnSave.Text == "Update")
{
infoSalesReturnMaster.SalesReturnMasterId = decSalesReturnMasterId;
spSalesReturnMaster.SalesReturnMasterEdit(infoSalesReturnMaster);
spLedgerPosting.LedgerPostingAndPartyBalanceDeleteByVoucherTypeIdAndLedgerIdAndVoucherNo(decSalesReturnVoucherTypeId, strVoucherNo, txtReturnNo.Text);
spLedgerPosting.LedgerPostingAndPartyBalanceDeleteByVoucherTypeIdAndLedgerIdAndVoucherNo(decSalesReturnVoucherTypeId, strVoucherNo, txtReturnNo.Text);
spStockPosting.StockPostingDeleteByVoucherTypeAndVoucherNo(strVoucherNo, decSalesReturnVoucherTypeId);
spSalesReturnBillTax.SalesReturnBillTaxDeleteBySalesReturnMasterId(decSalesReturnMasterId);
}
else
{
decSalesReturnMasterId = spSalesReturnMaster.SalesReturnMasterAdd(infoSalesReturnMaster);
}
SalesReturnDetailsInfo infoSalesReturnDetailsInfo = new SalesReturnDetailsInfo();
infoSalesReturnDetailsInfo.Extra1 = string.Empty;
infoSalesReturnDetailsInfo.Extra2 = string.Empty;
if (btnSave.Text == "Update")
{
foreach (var strId in lstArrOfRemove)
{
decimal decDeleteId = Convert.ToDecimal(strId);
spSalesReturnDetails.SalesReturnDetailsDelete(decDeleteId);
}
}
foreach (DataGridViewRow DGVSalesReturn in dgvSalesReturn.Rows)
{
if (DGVSalesReturn.Cells["productId"].Value != null && DGVSalesReturn.Cells["productId"].Value.ToString() != string.Empty)
{
infoSalesReturnDetailsInfo.SalesReturnMasterId = decSalesReturnMasterId;
infoSalesReturnDetailsInfo.ProductId = Convert.ToDecimal(DGVSalesReturn.Cells["productId"].Value.ToString());
if (DGVSalesReturn.Cells["dgvTextQty"].Value != null)
{
infoSalesReturnDetailsInfo.Qty = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextQty"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvTextRate"].Value != null)
{
infoSalesReturnDetailsInfo.Rate = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextRate"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvCmbUnit"].Value != null)
{
infoSalesReturnDetailsInfo.UnitId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbUnit"].Value.ToString());
}
if (DGVSalesReturn.Cells["unitConversionId"].Value != null)
{
infoSalesReturnDetailsInfo.UnitConversionId = Convert.ToDecimal(DGVSalesReturn.Cells["unitConversionId"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvTextDiscountAmount"].Value != null)
{
infoSalesReturnDetailsInfo.Discount = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextDiscountAmount"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvCmbTax"].Value != null)
{
infoSalesReturnDetailsInfo.TaxId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbTax"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.TaxId = 0;
}
if (DGVSalesReturn.Cells["dgvCmbBatch"].Value != null)
{
infoSalesReturnDetailsInfo.BatchId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbBatch"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.BatchId = 0;
}
if (DGVSalesReturn.Cells["dgvCmbBatch"].Value != null)
{
infoSalesReturnDetailsInfo.BatchId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbBatch"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.BatchId = 0;
}
if (DGVSalesReturn.Cells["dgvCmbGodown"].Value != null)
{
infoSalesReturnDetailsInfo.GodownId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbGodown"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.GodownId = 0;
}
if (DGVSalesReturn.Cells["dgvCmbRack"].Value != null)
{
infoSalesReturnDetailsInfo.RackId = Convert.ToDecimal(DGVSalesReturn.Cells["dgvCmbRack"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.RackId = 0;
}
if (DGVSalesReturn.Cells["dgvTextTaxAmount"].Value != null)
{
infoSalesReturnDetailsInfo.TaxAmount = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextTaxAmount"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvTextGrossValue"].Value != null)
{
infoSalesReturnDetailsInfo.GrossAmount = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextGrossValue"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvTextNetValue"].Value != null)
{
infoSalesReturnDetailsInfo.NetAmount = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextNetValue"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvTextAmount1"].Value != null)
{
infoSalesReturnDetailsInfo.Amount = Convert.ToDecimal(DGVSalesReturn.Cells["dgvTextAmount1"].Value.ToString());
}
if (DGVSalesReturn.Cells["dgvSNo"].Value != null)
{
infoSalesReturnDetailsInfo.SlNo = Convert.ToInt32(DGVSalesReturn.Cells["dgvSNo"].Value.ToString());
}
if (DGVSalesReturn.Cells["salesDetailsId"].Value != null && cmbInvoiceNo.SelectedValue != null)
{
infoSalesReturnDetailsInfo.SalesDetailsId = Convert.ToDecimal(DGVSalesReturn.Cells["salesDetailsId"].Value.ToString());
}
else
{
infoSalesReturnDetailsInfo.SalesDetailsId = 0;
}
if (DGVSalesReturn.Cells["salesReturnDetailsId"].Value != null)
{
infoSalesReturnDetailsInfo.SalesReturnDetailsId = Convert.ToDecimal(DGVSalesReturn.Cells["salesReturnDetailsId"].Value.ToString());
spSalesReturnDetails.SalesReturnDetailsEdit(infoSalesReturnDetailsInfo);
}
else
{
decSalesReturnDetailId = spSalesReturnDetails.SalesReturnDetailsAdd(infoSalesReturnDetailsInfo);
}
StockPostingInfo infoStockPosting = new StockPostingInfo();
infoStockPosting.Date = infoSalesReturnMaster.Date;
if (DGVSalesReturn.Cells["voucherTypeId"].Value != null)
{
infoStockPosting.VoucherTypeId = Convert.ToDecimal(DGVSalesReturn.Cells["voucherTypeId"].Value.ToString());
decAgainstVoucherTypeId = infoStockPosting.VoucherTypeId;
infoStockPosting.AgainstVoucherTypeId = decSalesReturnVoucherTypeId;
}
else
{
infoStockPosting.VoucherTypeId = decSalesReturnVoucherTypeId;
infoStockPosting.AgainstVoucherTypeId = 0;
}
if (DGVSalesReturn.Cells["voucherNo"].Value != null)
{
infoStockPosting.VoucherNo = DGVSalesReturn.Cells["voucherNo"].Value.ToString();
strAgainstVoucherNo = infoStockPosting.VoucherNo;
infoStockPosting.AgainstVoucherNo = strVoucherNo;
}
else
{
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.AgainstVoucherNo = "NA";
}
if (DGVSalesReturn.Cells["invoiceNo"].Value != null)
{
infoStockPosting.InvoiceNo = DGVSalesReturn.Cells["invoiceNo"].Value.ToString();
strAgainstInvoiceNo = infoStockPosting.InvoiceNo;
infoStockPosting.AgainstInvoiceNo = txtReturnNo.Text.Trim();
}
else
{
infoStockPosting.InvoiceNo = txtReturnNo.Text;
infoStockPosting.AgainstInvoiceNo = "NA";
}
infoStockPosting.ProductId = infoSalesReturnDetailsInfo.ProductId;
infoStockPosting.BatchId = infoSalesReturnDetailsInfo.BatchId;
infoStockPosting.UnitId = infoSalesReturnDetailsInfo.UnitId;
infoStockPosting.GodownId = infoSalesReturnDetailsInfo.GodownId;
infoStockPosting.RackId = infoSalesReturnDetailsInfo.RackId;
if (infoSalesReturnDetailsInfo.ProductId != 0 && infoSalesReturnDetailsInfo.UnitId != 0)
{
decimal decUnitConvertionRate = 0;
infoProduct = spProduct.ProductView(infoSalesReturnDetailsInfo.ProductId);
DataTable dtbl = spUnitConvertion.DGVUnitConvertionRateByUnitId(infoSalesReturnDetailsInfo.UnitId, infoProduct.ProductName);
foreach (DataRow drowDetails in dtbl.Rows)
{
decUnitConvertionRate = Convert.ToDecimal(drowDetails["conversionRate"].ToString());
}
strQuantities = spUnit.UnitConversionCheck(infoSalesReturnDetailsInfo.UnitId, infoSalesReturnDetailsInfo.ProductId);
if (strQuantities != string.Empty)
{
infoStockPosting.InwardQty = infoSalesReturnDetailsInfo.Qty / decUnitConvertionRate;
}
else
{
infoStockPosting.InwardQty = infoSalesReturnDetailsInfo.Qty;
}
}
infoStockPosting.OutwardQty = 0;
infoStockPosting.Rate = infoSalesReturnDetailsInfo.Rate;
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
spStockPosting.StockPostingAdd(infoStockPosting);
}
}
decGrandTotal = Convert.ToDecimal(txtGrandTotal.Text);
decNetTotal = TotalNetAmountForLedgerPosting();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
infoLedgerPosting.Date = infoSalesReturnMaster.Date;
infoLedgerPosting.ChequeDate = infoSalesReturnMaster.Date;
infoLedgerPosting.ChequeNo = String.Empty;
infoLedgerPosting.VoucherTypeId = infoSalesReturnMaster.VoucherTypeId;
infoLedgerPosting.VoucherNo = infoSalesReturnMaster.VoucherNo;
infoLedgerPosting.LedgerId = infoSalesReturnMaster.LedgerId;
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = (decGrandTotal * decExchangeRate);
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.InvoiceNo = infoSalesReturnMaster.InvoiceNo;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
infoLedgerPosting.LedgerId = infoSalesReturnMaster.SalesAccount;
infoLedgerPosting.Debit = (decNetTotal * decExchangeRate);
infoLedgerPosting.Credit = 0;
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
if (Convert.ToDecimal(txtBillDiscount.Text == string.Empty ? "0" : txtBillDiscount.Text) > 0)
{
infoLedgerPosting.LedgerId = 8;
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = (Convert.ToDecimal(txtBillDiscount.Text) * decExchangeRate);
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
LedegrPostingForTax();
PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo();
infoPartyBalance.Date = infoSalesReturnMaster.Date;
infoPartyBalance.LedgerId = infoSalesReturnMaster.LedgerId;
if (decAgainstVoucherTypeId != 0)
{
infoPartyBalance.VoucherTypeId = decAgainstVoucherTypeId;
infoPartyBalance.VoucherNo = strAgainstVoucherNo;
infoPartyBalance.InvoiceNo = strAgainstInvoiceNo;
infoPartyBalance.AgainstVoucherTypeId = infoSalesReturnMaster.VoucherTypeId;
infoPartyBalance.AgainstVoucherNo = infoSalesReturnMaster.VoucherNo;
infoPartyBalance.AgainstInvoiceNo = infoSalesReturnMaster.InvoiceNo;
infoPartyBalance.ReferenceType = "Against";
}
else
{
infoPartyBalance.VoucherTypeId = infoSalesReturnMaster.VoucherTypeId;
infoPartyBalance.VoucherNo = infoSalesReturnMaster.VoucherNo;
infoPartyBalance.InvoiceNo = infoSalesReturnMaster.InvoiceNo;
infoPartyBalance.AgainstVoucherTypeId = 0;
infoPartyBalance.AgainstVoucherNo = "NA";
infoPartyBalance.AgainstInvoiceNo = "NA";
infoPartyBalance.ReferenceType = "New";
}
infoPartyBalance.Credit = infoSalesReturnMaster.TotalAmount;
infoPartyBalance.Debit = 0;
infoPartyBalance.CreditPeriod = 0;
infoPartyBalance.ExchangeRateId = infoSalesReturnMaster.ExchangeRateId;
infoPartyBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPartyBalance.Extra1 = string.Empty;
infoPartyBalance.Extra2 = string.Empty;
spPartyBalance.PartyBalanceAdd(infoPartyBalance);
SalesReturnBillTaxInfo infoSalesReturnBillTax = new SalesReturnBillTaxInfo();
foreach (DataGridViewRow item in dgvSalesReturn2.Rows)
{
if (item.Cells["dgvTextTaxId"].Value != null)
{
infoSalesReturnBillTax.SalesReturnMasterId = decSalesReturnMasterId;
infoSalesReturnBillTax.TaxId = Convert.ToDecimal(item.Cells["dgvTextTaxId"].Value.ToString());
infoSalesReturnBillTax.TaxAmount = Convert.ToDecimal(item.Cells["dgvTextAmount"].Value.ToString());
infoSalesReturnBillTax.Extra1 = string.Empty;
infoSalesReturnBillTax.Extra2 = string.Empty;
spSalesReturnBillTax.SalesReturnBillTaxAdd(infoSalesReturnBillTax);
}
}
if (btnSave.Text == "Save")
{
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked == true)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesReturnMasterId);
}
else
{
Print(decSalesReturnMasterId);
}
}
clear();
}
else
{
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked == true)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesReturnMasterId);
}
else
{
Print(decSalesReturnMasterId);
}
}
this.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show("SR36:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// print function
/// </summary>
/// <param name="decSalesReturnMasterId"></param>
public void Print(decimal decSalesReturnMasterId)
{
try
{
SalesReturnMasterSP spSalesReturnMaster = new SalesReturnMasterSP();
DataSet dsSalesReturn = spSalesReturnMaster.SalesReturnPrinting(decSalesReturnMasterId);
frmReport frmReport = new frmReport();
frmReport.MdiParent = formMDI.MDIObj;
frmReport.SalesReturnPrinting(dsSalesReturn);
}
catch (Exception ex)
{
MessageBox.Show("SR31:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to delete an item from database
/// </summary>
public void Delete()
{
try
{
SalesReturnMasterSP spSalesReturnMaster = new SalesReturnMasterSP();
spSalesReturnMaster.SalesReturnDelete(salesReturnMasterId, decSalesReturnVoucherTypeId, strVoucherNo);
Messages.DeletedMessage();
if (objFromSalesReturnRegister != null)
{
if (isFromOther)
{
this.Close();
objFromSalesReturnRegister.Enabled = true;
objFromSalesReturnRegister.SalesReturnGrideFill();
}
}
else if (objFromSalesReturnReport != null)
{
if (isFromOther)
{
this.Close();
objFromSalesReturnReport.Enabled = true;
objFromSalesReturnReport.SalesReturnReportGrideFill();
}
}
else if (objVoucherSearch != null)
{
objVoucherSearch.GridFill();
this.Close();
}
else if (frmDayBookObj != null)
{
this.Close();
}
else
{
clear();
}
if (frmLedgerDetailsObj != null)
{
this.Close();
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("SR30:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// FunctionToreturn fromregisterclick
/// </summary>
public void FillRegisterOrReport()
{
SalesReturnMasterSP spSalesReturnMaster = new SalesReturnMasterSP();
SalesReturnDetailsSP spSalesReturnDetails = new SalesReturnDetailsSP();
try
{
isFromOther = true;
btnSave.Text = "Update";
btnDelete.Enabled = true;
CashOrPartyUnderSundryDebitorComboFill(cmbCashOrParty);
DataTable dtblSalesMaster = new DataTable();
DataTable dtblSalesReturnMaster = new DataTable();
dtblSalesReturnMaster = spSalesReturnMaster.SalesReturnMasterViewBySalesReturnMasterId(salesReturnMasterId);
decSalesReturnMasterId = salesReturnMasterId;
DecSalesReturnVoucherTypeId = Convert.ToDecimal(dtblSalesReturnMaster.Rows[0]["voucherTypeId"].ToString());
VoucherTypeInfo infoVoucherType = new VoucherTypeInfo();
infoVoucherType = spVoucherType.VoucherTypeView(DecSalesReturnVoucherTypeId);
this.Text = infoVoucherType.VoucherTypeName;
if (infoVoucherType.MethodOfVoucherNumbering == "Manual")
{
txtReturnNo.Text = dtblSalesReturnMaster.Rows[0]["invoiceNo"].ToString();
ManualReturnNo = dtblSalesReturnMaster.Rows[0]["invoiceNo"].ToString();
txtReturnNo.Enabled = true;
}
else
{
txtReturnNo.Text = dtblSalesReturnMaster.Rows[0]["invoiceNo"].ToString();
txtReturnNo.Enabled = false;
}
if (dtblSalesReturnMaster.Rows.Count > 0)
{
txtDate.Text = dtblSalesReturnMaster.Rows[0]["date"].ToString();
dtpDate.Value = Convert.ToDateTime(txtDate.Text);
if (dtblSalesReturnMaster.Rows[0]["grandTotal"].ToString() != string.Empty)
{
txtGrandTotal.Text = dtblSalesReturnMaster.Rows[0]["grandTotal"].ToString();
}
strVoucherNo = dtblSalesReturnMaster.Rows[0]["voucherNo"].ToString();
if (dtblSalesReturnMaster.Rows[0]["ledgerId"].ToString() != string.Empty)
{
cmbCashOrParty.SelectedValue = dtblSalesReturnMaster.Rows[0]["ledgerId"].ToString();
}
cmbVoucherTypeComboFill();
if (dtblSalesReturnMaster.Rows[0]["SMVoucherTypeId"].ToString() != string.Empty)
{
cmbVoucherType.SelectedValue = dtblSalesReturnMaster.Rows[0]["SMVoucherTypeId"].ToString();
}
else
{
cmbVoucherType.SelectedValue = 0;
}
cmbInvoiceComboFill();
if (dtblSalesReturnMaster.Rows[0]["pricingLevelId"].ToString() != string.Empty)
{
cmbPricingLevel.SelectedValue = dtblSalesReturnMaster.Rows[0]["pricingLevelId"].ToString();
}
if (dtblSalesReturnMaster.Rows[0]["salesAccount"].ToString() != string.Empty)
{
cmbSalesAccount.SelectedValue = dtblSalesReturnMaster.Rows[0]["salesAccount"].ToString();
}
if (dtblSalesReturnMaster.Rows[0]["employeeId"].ToString() != string.Empty)
{
cmbSalesMan.SelectedValue = dtblSalesReturnMaster.Rows[0]["employeeId"].ToString();
}
if (dtblSalesReturnMaster.Rows[0]["exchangeRateId"].ToString() != string.Empty)
{
cmbCurrency.SelectedValue = dtblSalesReturnMaster.Rows[0]["exchangeRateId"].ToString();
}
txtNarration.Text = dtblSalesReturnMaster.Rows[0]["narration"].ToString();
txtLRNo.Text = dtblSalesReturnMaster.Rows[0]["lrNo"].ToString();
txtTransportationComp.Text = dtblSalesReturnMaster.Rows[0]["transportationCompany"].ToString();
if (dtblSalesReturnMaster.Rows[0]["salesMasterId"].ToString() != string.Empty && Convert.ToDecimal(dtblSalesReturnMaster.Rows[0]["salesMasterId"].ToString()) != 0)
{
cmbInvoiceNo.SelectedValue = dtblSalesReturnMaster.Rows[0]["salesMasterId"].ToString();
decinvoiceno = Convert.ToDecimal(cmbInvoiceNo.SelectedValue.ToString());
dtblSalesReturnMasterViewBySMID = spSalesReturnMaster.SalesReturnMasterViewBySalesMasterId(Convert.ToDecimal(dtblSalesReturnMaster.Rows[0]["salesMasterId"].ToString()));
}
isInvoiceFill = false;
if (dtblSalesReturnMaster.Rows[0]["voucherTypeId"].ToString() != string.Empty)
{
decSalesReturnVoucherTypeId = Convert.ToDecimal(dtblSalesReturnMaster.Rows[0]["voucherTypeId"].ToString());
}
TaxGridFill();
if (cmbInvoiceNo.SelectedValue != null)
{
infoSalesMaster = spSalesMaster.SalesMasterViewBySalesMasterId(Convert.ToDecimal(cmbInvoiceNo.SelectedValue.ToString()));
}
DataTable dtblSalesReturnDetails = new DataTable();
dtblSalesReturnDetails = spSalesReturnDetails.SalesReturnDetailsViewBySalesReturnMasterId(salesReturnMasterId);
dtblSalesInvoice = dtblSalesReturnDetails;
foreach (DataRow drowDetails in dtblSalesReturnDetails.Rows)
{
dgvSalesReturn.Rows.Add();
if (drowDetails["salesReturnDetailsId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["salesReturnDetailsId"].Value = Convert.ToDecimal(drowDetails["salesReturnDetailsId"].ToString());
}
if (drowDetails["salesDetailsId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["salesDetailsId"].Value = drowDetails["salesDetailsId"].ToString();
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["salesDetailsId"].Value = 0;
}
if (drowDetails["productId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["productId"].Value = drowDetails["productId"].ToString();
DataTable dtbl = spSalesDetails.SalesReturnGrideFillNewByProductId(Convert.ToDecimal(drowDetails["productId"].ToString()));
foreach (DataRow drowDetails1 in dtbl.Rows)
{
if (drowDetails1["barcode"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextBarcode"].Value = drowDetails1["barcode"].ToString();
}
if (drowDetails1["productCode"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextProductCode"].Value = drowDetails1["productCode"].ToString();
}
if (drowDetails1["productName"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextProductName"].Value = drowDetails1["productName"].ToString();
}
if (cmbInvoiceNo.Visible == true)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbUnit"].ReadOnly = true;
}
if (drowDetails["unitId"].ToString() != string.Empty)
{
decProductId = decimal.Parse(dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["productId"].Value.ToString());
UnitComboFill(decProductId, dgvSalesReturn.Rows.Count - 2, dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbUnit"].ColumnIndex);
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbUnit"].Value = Convert.ToDecimal(drowDetails["unitId"].ToString());
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbUnit"].Value = 1;
}
if (drowDetails["goDownId"].ToString() != string.Empty)
{
DGVGodownComboFill();
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbGodown"].Value = Convert.ToDecimal(drowDetails["goDownId"].ToString());
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbGodown"].Value = 1;
}
if (drowDetails["rackId"].ToString() != string.Empty)
{
RackComboFill(Convert.ToDecimal(dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbGodown"].Value.ToString()), dgvSalesReturn.Rows.Count - 2, dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbRack"].ColumnIndex);
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbRack"].Value = Convert.ToDecimal(drowDetails["rackId"].ToString());
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbRack"].Value = 1;
}
if (drowDetails["batchId"].ToString() != string.Empty)
{
BatchComboFill(decProductId, dgvSalesReturn.Rows.Count - 2, dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbBatch"].ColumnIndex);
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbBatch"].Value = Convert.ToDecimal(drowDetails["batchId"].ToString());
}
if (drowDetails["unitConversionId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["unitConversionId"].Value = drowDetails["unitConversionId"].ToString();
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["unitConversionId"].Value = 0;
}
if (dtblSalesReturnMaster.Rows[0]["SMVoucherTypeId"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbBatch"].ReadOnly = true;
}
if (drowDetails["taxId"].ToString() != string.Empty)
{
if (Convert.ToDecimal(drowDetails["taxId"].ToString()) != 0)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTaxId"].Value = Convert.ToDecimal(drowDetails["taxId"].ToString());
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbTax"].Value = Convert.ToDecimal(drowDetails["taxId"].ToString());
strTaxRate = spSalesReturnMaster.TaxRateFindForTaxAmmountCalByTaxId(Convert.ToDecimal(drowDetails["taxId"].ToString()));
}
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbTax"].Value = 1;
}
if (drowDetails["qty"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextQty"].Value = Math.Round(Convert.ToDecimal(drowDetails["qty"].ToString()), PublicVariables._inNoOfDecimalPlaces);
decQty = Math.Round(Convert.ToDecimal(drowDetails["qty"].ToString()), PublicVariables._inNoOfDecimalPlaces);
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextQty"].Value = 0.00;
decQty = 0;
}
if (drowDetails["rate"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextRate"].Value = Math.Round(Convert.ToDecimal(drowDetails["rate"].ToString()), PublicVariables._inNoOfDecimalPlaces);
decRate = Convert.ToDecimal(drowDetails["rate"].ToString());
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextRate"].Value = 0.00;
decRate = 0;
}
if (drowDetails["grossAmount"].ToString() != string.Empty)
{
//dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].Value = Math.Round(Convert.ToDecimal(drowDetails["grossAmount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
// dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].ReadOnly = true;
}
else
{
//dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].Value = 0.00;
//dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextGrossValue"].ReadOnly = true;
}
if (drowDetails["discount"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextDiscountPercentage"].Value = 0.00;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextDiscountAmount"].Value = Math.Round(Convert.ToDecimal(drowDetails["discount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextDiscountAmount"].Value = 0.00;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextDiscountPercentage"].Value = 0.00;
}
if (drowDetails["netAmount"].ToString() != string.Empty)
{
// dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].Value = Math.Round(Convert.ToDecimal(drowDetails["netAmount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
// dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].ReadOnly = true;
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].Value = 0.00;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextNetValue"].ReadOnly = true;
}
if (drowDetails["taxAmount"].ToString() != string.Empty)
{
//dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].ReadOnly = false;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].Value = Math.Round(Convert.ToDecimal(drowDetails["taxAmount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
//dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].ReadOnly = true;
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].Value = 0.00;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].ReadOnly = true;
}
if (drowDetails["amount"].ToString() != string.Empty)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextAmount1"].Value = Math.Round(Convert.ToDecimal(drowDetails["amount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextAmount1"].ReadOnly = true;
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextAmount1"].Value = 0.00;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextAmount1"].ReadOnly = true;
}
if (cmbInvoiceNo.Visible == true)
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextBarcode"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextProductCode"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextProductName"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextQty"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvCmbUnit"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvCmbGodown"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvCmbRack"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvCmbBatch"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextRate"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvTextDiscountPercentage"].ReadOnly = true;
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 1].Cells["dgvCmbTax"].ReadOnly = true;
}
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["conversionRate"].Value = drowDetails["conversionRate"].ToString();
foreach (DataGridViewRow item1 in dgvSalesReturn2.Rows)
{
if (item1.Cells["dgvTextTaxId"].Value != null)
{
if (dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvCmbTax"].Value.ToString() == item1.Cells["dgvTextTaxId"].Value.ToString())
{
item1.Cells["dgvTextAmount"].Value = dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["dgvTextTaxAmount"].Value;
}
}
}
}
}
else
{
dgvSalesReturn.Rows[dgvSalesReturn.Rows.Count - 2].Cells["productId"].Value = 0;
}
TotalAmountCalculation();
}
if (!isSalesReturnFormActive)
{
dtblTaxGride = spSalesReturnBillTax.TaxDetailsViewBySalesReturnMasterId(salesReturnMasterId);
foreach (DataRow item1 in dtblTaxGride.Rows)
{
dgvSalesReturn2.Rows.Add();
dgvSalesReturn2.Rows[dgvSalesReturn2.Rows.Count - 2].Cells["dgvTextTaxName"].Value = item1["taxName"].ToString();
dgvSalesReturn2.Rows[dgvSalesReturn2.Rows.Count - 2].Cells["dgvTextAmount"].Value = Math.Round(Convert.ToDecimal(item1["taxAmount"].ToString()), PublicVariables._inNoOfDecimalPlaces);
dgvSalesReturn2.Rows[dgvSalesReturn2.Rows.Count - 2].Cells["dgvRate"].Value = item1["rate"].ToString();
dgvSalesReturn2.Rows[dgvSalesReturn2.Rows.Count - 2].Cells["dgvTextTaxId"].Value = item1["taxId"].ToString();
}
}
txtBillDiscount.Text = Convert.ToString(Math.Round(Convert.ToDecimal(dtblSalesReturnMaster.Rows[0]["discount"].ToString()), PublicVariables._inNoOfDecimalPlaces));
SerialNo2();
TotalBillTaxCalculation();
CessTaxamountCalculation();
TotalTaxAmtCalculation();
if (txtBillDiscount.Text != string.Empty)
{
decimal decDiscount = Convert.ToDecimal(txtBillDiscount.Text);
decimal decTotalAmt = Convert.ToDecimal(txtTotalAmount.Text);
if (decTotalAmt > decDiscount)
{
decimal decGrandTotal = decTotalAmt + decTotalBillTaxAmount + decTotalCessTaxamount - decDiscount;
decGrandTotal = Math.Round(decGrandTotal, PublicVariables._inNoOfDecimalPlaces);
txtGrandTotal.Text = decGrandTotal.ToString();
}
}
// SerialNo();
}
else
{
MessageBox.Show("No record exists", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("SR28:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}