/// <summary>
/// To fill the grid according to the pending Sales Quotation Invoice number
/// </summary>
public void FillQuotationDetails()
{
SerialNo();
try
{
SalesQuotationMasterSP spQuotationMaster = new SalesQuotationMasterSP();
SalesQuotationDetailsSP spQuotationDetails = new SalesQuotationDetailsSP();
DeliveryNoteMasterInfo infoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
DeliveryNoteMasterSP spDeliveryNoteMaster = new DeliveryNoteMasterSP();
decimal decOrderNo = 0;
decimal DefaultRate = 0;
string strSalesManId;
inMaxCount = 0;
decOrderNo = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
dgvProduct.Rows.Clear();
DataTable dtblMaster = spQuotationMaster.SalesQuotationMasterViewByQuotationMasterId(Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString()));
if (dtblMaster.Rows.Count > 0)
{
cmbPricingLevel.SelectedValue = dtblMaster.Rows[0]["pricingLevelId"].ToString();
if (dtblMaster.Rows[0]["employeeId"].ToString() != string.Empty)
{
strSalesManId = dtblMaster.Rows[0]["employeeId"].ToString();
cmbSalesMan.SelectedValue = strSalesManId;
SalesManComboFill();
cmbSalesMan.SelectedValue = dtblMaster.Rows[0]["employeeId"].ToString();
}
CurrencyComboFill();
cmbCurrency.SelectedValue = dtblMaster.Rows[0]["exchangeRateId"].ToString();
DataTable dtblQuotationDetails = spQuotationDetails.SalesQuotationDetailsViewByquotationMasterIdWithRemainingByNotInCurrDN(Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString()), decDeliveryNoteMasterId);
int inRowIndex = 0;
isValueChange = false;
isDoAfterGridFill = false;
foreach (DataRow drowDetails in dtblQuotationDetails.Rows)
{
dgvProduct.Rows.Add();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtBarcode"].Value = drowDetails["barcode"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtProductId"].Value = drowDetails["productId"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtProductCode"].Value = drowDetails["productCode"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtProductName"].Value = drowDetails["productName"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtQty"].Value = drowDetails["Qty"].ToString();
UnitComboFill1(Convert.ToDecimal(drowDetails["productId"].ToString()), dgvProduct.Rows.Count - 2, dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbUnit"].ColumnIndex);
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(drowDetails["unitId"].ToString());
BatchComboFill(Convert.ToDecimal(drowDetails["productId"].ToString()), dgvProduct.Rows.Count - 2, dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbBatch"].ColumnIndex);
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(drowDetails["batchId"].ToString());
GridGodownComboFill(Convert.ToDecimal(drowDetails["productId"].ToString()), dgvProduct.Rows.Count - 2, dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbGodown"].ColumnIndex);
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbGodown"].Value = Convert.ToDecimal(drowDetails["godownId"].ToString());
RackComboFill1(Convert.ToDecimal(drowDetails["godownId"].ToString()), dgvProduct.Rows.Count - 2, dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbRack"].ColumnIndex);
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbRack"].Value = Convert.ToDecimal(drowDetails["rackId"].ToString());
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtRate"].Value = drowDetails["Rate"].ToString();
DefaultRate = Convert.ToDecimal(dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtRate"].Value.ToString());
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtOrderDetailsId"].Value = drowDetails["quotationDetailsId"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtVoucherTypeId"].Value = drowDetails["voucherTypeId"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtVoucherNo"].Value = drowDetails["voucherNo"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtInvoiceNo"].Value = drowDetails["invoiceNo"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drowDetails["unitConversionId"].ToString());
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtConversionRate"].Value = drowDetails["conversionRate"].ToString();
if (cmbOrderNo.Visible == true)
{
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbUnit"].ReadOnly = true;
}
dgvProduct.Rows[dgvProduct.Rows.Count - 2].HeaderCell.Value = "";
AmountCalculation("dgvtxtQty", inRowIndex);
int inIndex = 0;
int.TryParse(drowDetails["extra1"].ToString(), out inIndex);
if (inMaxCount < inIndex)
inMaxCount = inIndex;
inRowIndex++;
isValueChange = true;
}
for (int i = inRowIndex; i < dgvProduct.Rows.Count; ++i)
dgvProduct["inRowIndex", i].Value = GetNextinRowIndex().ToString();
SerialNo();
TotalAmountCalculation();
isDoAfterGridFill = true;
}
}
catch (Exception ex)
{
MessageBox.Show("DN28 :" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
