public void DeliveryNoteMasterEdit(DeliveryNoteMasterInfo deliverynotemasterinfo)
{
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("DeliveryNoteMasterEdit", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam19 = new SqlParameter();
sprmparam19 = sccmd.Parameters.Add("@deliveryNoteMasterId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.DeliveryNoteMasterId;
sprmparam19 = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar);
sprmparam19.Value = deliverynotemasterinfo.VoucherNo;
sprmparam19 = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar);
sprmparam19.Value = deliverynotemasterinfo.InvoiceNo;
sprmparam19 = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.VoucherTypeId;
sprmparam19 = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.SuffixPrefixId;
sprmparam19 = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam19.Value = deliverynotemasterinfo.Date;
sprmparam19 = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.LedgerId;
sprmparam19 = sccmd.Parameters.Add("@orderMasterId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.OrderMasterId;
sprmparam19 = sccmd.Parameters.Add("@pricinglevelId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.PricinglevelId;
sprmparam19 = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.EmployeeId;
sprmparam19 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam19.Value = deliverynotemasterinfo.Narration;
sprmparam19 = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.ExchangeRateId;
sprmparam19 = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.TotalAmount;
sprmparam19 = sccmd.Parameters.Add("@userId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.UserId;
sprmparam19 = sccmd.Parameters.Add("@lrNo", SqlDbType.VarChar);
sprmparam19.Value = deliverynotemasterinfo.LrNo;
sprmparam19 = sccmd.Parameters.Add("@transportationCompany", SqlDbType.VarChar);
sprmparam19.Value = deliverynotemasterinfo.TransportationCompany;
sprmparam19 = sccmd.Parameters.Add("@quotationMasterId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.QuotationMasterId;
sprmparam19 = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal);
sprmparam19.Value = deliverynotemasterinfo.FinancialYearId;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
base.sqlcon.Close();
}
}
public void DeliveryNoteMasterEdit(DeliveryNoteMasterInfo deliverynotemasterinfo)
{
try
{
spDeliveryNoteMaster.DeliveryNoteMasterEdit(deliverynotemasterinfo);
}
catch (Exception ex)
{
MessageBox.Show("DNBLL:15" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public DeliveryNoteMasterInfo DeliveryNoteMasterView(decimal deliveryNoteMasterId)
{
DeliveryNoteMasterInfo deliverynotemasterinfo = new DeliveryNoteMasterInfo();
try
{
deliverynotemasterinfo = spDeliveryNoteMaster.DeliveryNoteMasterView(deliveryNoteMasterId);
}
catch (Exception ex)
{
MessageBox.Show("DNBLL:22" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(deliverynotemasterinfo);
}
public decimal DeliveryNoteMasterAdd(DeliveryNoteMasterInfo deliverynotemasterinfo)
{
decimal decDeliveryNoteMasterId = 0;
try
{
decDeliveryNoteMasterId = spDeliveryNoteMaster.DeliveryNoteMasterAdd(deliverynotemasterinfo);
}
catch (Exception ex)
{
MessageBox.Show("DNBLL:14" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(decDeliveryNoteMasterId);
}
public DeliveryNoteMasterInfo DeliveryNoteMasterViewAllByMasterId(decimal decDeliveryNoteMasterId)
{
DeliveryNoteMasterInfo infoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
try
{
infoDeliveryNoteMaster = spDeliveryNoteMaster.DeliveryNoteMasterViewAllByMasterId(decDeliveryNoteMasterId);
}
catch (Exception ex)
{
MessageBox.Show("DNBLL:12" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(infoDeliveryNoteMaster);
}
public DeliveryNoteMasterInfo DeliveryNoteMasterView(decimal deliveryNoteMasterId)
{
DeliveryNoteMasterInfo deliverynotemasterinfo = new DeliveryNoteMasterInfo();
SqlDataReader sdrreader = null;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("DeliveryNoteMasterView", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam2 = new SqlParameter();
sprmparam2 = sccmd.Parameters.Add("@deliveryNoteMasterId", SqlDbType.Decimal);
sprmparam2.Value = deliveryNoteMasterId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
deliverynotemasterinfo.DeliveryNoteMasterId = decimal.Parse(((DbDataReader)sdrreader)[0].ToString());
deliverynotemasterinfo.VoucherNo = ((DbDataReader)sdrreader)[1].ToString();
deliverynotemasterinfo.InvoiceNo = ((DbDataReader)sdrreader)[2].ToString();
deliverynotemasterinfo.VoucherTypeId = decimal.Parse(((DbDataReader)sdrreader)[3].ToString());
deliverynotemasterinfo.SuffixPrefixId = decimal.Parse(((DbDataReader)sdrreader)[4].ToString());
deliverynotemasterinfo.Date = DateTime.Parse(((DbDataReader)sdrreader)[5].ToString());
deliverynotemasterinfo.LedgerId = decimal.Parse(((DbDataReader)sdrreader)[6].ToString());
deliverynotemasterinfo.OrderMasterId = decimal.Parse(((DbDataReader)sdrreader)[7].ToString());
deliverynotemasterinfo.PricinglevelId = decimal.Parse(((DbDataReader)sdrreader)[8].ToString());
deliverynotemasterinfo.EmployeeId = decimal.Parse(((DbDataReader)sdrreader)[9].ToString());
deliverynotemasterinfo.Narration = ((DbDataReader)sdrreader)[10].ToString();
deliverynotemasterinfo.ExchangeRateId = decimal.Parse(((DbDataReader)sdrreader)[11].ToString());
deliverynotemasterinfo.TotalAmount = decimal.Parse(((DbDataReader)sdrreader)[12].ToString());
deliverynotemasterinfo.UserId = decimal.Parse(((DbDataReader)sdrreader)[13].ToString());
deliverynotemasterinfo.LrNo = ((DbDataReader)sdrreader)[14].ToString();
deliverynotemasterinfo.TransportationCompany = ((DbDataReader)sdrreader)[15].ToString();
deliverynotemasterinfo.QuotationMasterId = decimal.Parse(((DbDataReader)sdrreader)[16].ToString());
deliverynotemasterinfo.FinancialYearId = decimal.Parse(((DbDataReader)sdrreader)[17].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
base.sqlcon.Close();
}
return(deliverynotemasterinfo);
}
public DeliveryNoteMasterInfo DeliveryNoteMasterViewAllByMasterId(decimal decDeliveryNoteMasterId)
{
DeliveryNoteMasterInfo infoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
SqlDataReader sdrReader2 = null;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sqlcmd = new SqlCommand("DeliveryNoteMasterViewAllByMasterId", base.sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
SqlParameter param2 = new SqlParameter();
param2 = sqlcmd.Parameters.Add("@deliveryNoteMasterId", SqlDbType.Decimal);
param2.Value = decDeliveryNoteMasterId;
sdrReader2 = sqlcmd.ExecuteReader();
while (sdrReader2.Read())
{
infoDeliveryNoteMaster.DeliveryNoteMasterId = decimal.Parse(((DbDataReader)sdrReader2)["deliveryNoteMasterId"].ToString());
infoDeliveryNoteMaster.VoucherNo = ((DbDataReader)sdrReader2)["voucherNo"].ToString();
infoDeliveryNoteMaster.InvoiceNo = ((DbDataReader)sdrReader2)["invoiceNo"].ToString();
infoDeliveryNoteMaster.VoucherTypeId = Convert.ToDecimal(((DbDataReader)sdrReader2)["voucherTypeId"].ToString());
infoDeliveryNoteMaster.SuffixPrefixId = Convert.ToDecimal(((DbDataReader)sdrReader2)["suffixPrefixId"].ToString());
infoDeliveryNoteMaster.Date = Convert.ToDateTime(((DbDataReader)sdrReader2)["date"].ToString());
infoDeliveryNoteMaster.LedgerId = Convert.ToDecimal(((DbDataReader)sdrReader2)["ledgerId"].ToString());
infoDeliveryNoteMaster.PricinglevelId = Convert.ToDecimal(((DbDataReader)sdrReader2)["pricingLevelId"].ToString());
infoDeliveryNoteMaster.EmployeeId = Convert.ToDecimal(((DbDataReader)sdrReader2)["employeeId"].ToString());
infoDeliveryNoteMaster.Narration = ((DbDataReader)sdrReader2)["narration"].ToString();
infoDeliveryNoteMaster.SuffixPrefixId = Convert.ToDecimal(((DbDataReader)sdrReader2)["suffixPrefixId"].ToString());
infoDeliveryNoteMaster.ExchangeRateId = Convert.ToDecimal(((DbDataReader)sdrReader2)["exchangeRateId"].ToString());
infoDeliveryNoteMaster.TotalAmount = Convert.ToDecimal(((DbDataReader)sdrReader2)["totalAmount"].ToString());
infoDeliveryNoteMaster.UserId = Convert.ToDecimal(((DbDataReader)sdrReader2)["userId"].ToString());
infoDeliveryNoteMaster.TransportationCompany = ((DbDataReader)sdrReader2)["transportationCompany"].ToString();
infoDeliveryNoteMaster.LrNo = ((DbDataReader)sdrReader2)["lrNo"].ToString();
infoDeliveryNoteMaster.OrderMasterId = Convert.ToDecimal(((DbDataReader)sdrReader2)["orderMasterId"].ToString());
infoDeliveryNoteMaster.QuotationMasterId = Convert.ToDecimal(((DbDataReader)sdrReader2)["quotationMasterId"].ToString());
}
}
catch (Exception)
{
throw;
}
finally
{
base.sqlcon.Close();
}
return(infoDeliveryNoteMaster);
}
public DeliveryNoteMasterInfo DeliveryNoteMasterViewSalesManAndPricing(decimal deliveryNoteMasterId)
{
DeliveryNoteMasterInfo deliverynotemasterinfo = new DeliveryNoteMasterInfo();
SqlDataReader sdrreader = null;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("DeliveryNoteMasterViewSalesManAndPricing", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam2 = new SqlParameter();
sprmparam2 = sccmd.Parameters.Add("@deliveryNoteMasterId", SqlDbType.Decimal);
sprmparam2.Value = deliveryNoteMasterId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
deliverynotemasterinfo.DeliveryNoteMasterId = decimal.Parse(((DbDataReader)sdrreader)["deliveryNoteMasterId"].ToString());
deliverynotemasterinfo.PricinglevelId = decimal.Parse(((DbDataReader)sdrreader)["pricinglevelId"].ToString());
deliverynotemasterinfo.EmployeeId = decimal.Parse(((DbDataReader)sdrreader)["employeeId"].ToString());
deliverynotemasterinfo.ExchangeRateId = decimal.Parse(((DbDataReader)sdrreader)["exchangeRateId"].ToString());
deliverynotemasterinfo.UserId = decimal.Parse(((DbDataReader)sdrreader)["userId"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
base.sqlcon.Close();
}
return(deliverynotemasterinfo);
}
/// <summary>
/// To fill the grid according to the pending Sales Quotation Invoice number
/// </summary>
public void FillQuotationDetails()
{
SerialNo();
try
{
SalesQuotationBll bllQuotation = new SalesQuotationBll();
DeliveryNoteMasterInfo infoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
//DeliveryNoteMasterSP spDeliveryNoteMaster = new DeliveryNoteMasterSP();
DeliveryNoteBll bllDeliveryNote = new DeliveryNoteBll();
decimal decOrderNo = 0;
decimal DefaultRate = 0;
string strSalesManId;
inMaxCount = 0;
decOrderNo = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
dgvProduct.Rows.Clear();
List<DataTable> ListObj = bllQuotation.SalesQuotationMasterViewByQuotationMasterId(Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString()));
if (ListObj[0].Rows.Count > 0)
{
cmbPricingLevel.SelectedValue = ListObj[0].Rows[0]["pricingLevelId"].ToString();
if (ListObj[0].Rows[0]["employeeId"].ToString() != string.Empty)
{
strSalesManId = ListObj[0].Rows[0]["employeeId"].ToString();
cmbSalesMan.SelectedValue = strSalesManId;
SalesManComboFill();
cmbSalesMan.SelectedValue = ListObj[0].Rows[0]["employeeId"].ToString();
}
CurrencyComboFill();
cmbCurrency.SelectedValue = ListObj[0].Rows[0]["exchangeRateId"].ToString();
List<DataTable> ListObjDelivery = bllQuotation.SalesQuotationDetailsViewByquotationMasterIdWithRemainingByNotInCurrDN(Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString()), decDeliveryNoteMasterId);
int inRowIndex = 0;
isValueChange = false;
isDoAfterGridFill = false;
foreach (DataRow drowDetails in ListObjDelivery[0].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);
}
}
/// <summary>
/// Save Function
/// </summary>
public void SaveFunction()
{
try
{
DeliveryNoteMasterInfo infoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
DeliveryNoteDetailsInfo infoDeliveryNoteDetails = new DeliveryNoteDetailsInfo();
StockPostingInfo infoStockPosting = new StockPostingInfo();
StockPostingBll BllStockPosting = new StockPostingBll();
// StockPostingSP spStockPosting = new StockPostingSP();
//DeliveryNoteMasterSP spDeliveryNoteMaster = new DeliveryNoteMasterSP();
//DeliveryNoteDetailsSP spDeliveryNoteDetails = new DeliveryNoteDetailsSP();
DeliveryNoteBll bllDeliveryNote = new DeliveryNoteBll();
SalesOrderMasterInfo infoSalesOrderMaster = new SalesOrderMasterInfo();
SalesOrderBll bllSalesOrder = new SalesOrderBll();
SalesQuotationMasterInfo infoSalesQuotationMaster = new SalesQuotationMasterInfo();
SalesQuotationBll bllSalesQuotation = new SalesQuotationBll();
infoDeliveryNoteMaster.InvoiceNo = txtDeliveryNoteNo.Text;
infoDeliveryNoteMaster.VoucherTypeId = decDeliveryNoteVoucherTypeId;
infoDeliveryNoteMaster.Date = Convert.ToDateTime(txtDate.Text);
infoDeliveryNoteMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoDeliveryNoteMaster.VoucherNo = strVoucherNo;
infoDeliveryNoteMaster.SuffixPrefixId = decDeliveryNoteSuffixPrefixId;
if (btnSave.Text == "Save")
{
if (cmbOrderNo.SelectedValue != null)
{
if (cmbDeliveryMode.Text == "Against Order")
{
infoDeliveryNoteMaster.OrderMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
infoSalesOrderMaster = bllSalesOrder.SalesOrderMasterView(infoDeliveryNoteMaster.OrderMasterId);
}
else if (cmbDeliveryMode.Text == "Against Quotation")
{
infoDeliveryNoteMaster.QuotationMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
infoSalesQuotationMaster = bllSalesQuotation.SalesQuotationMasterView(infoDeliveryNoteMaster.QuotationMasterId);
}
else if (cmbDeliveryMode.Text == "NA")
{
infoDeliveryNoteMaster.OrderMasterId = 0; infoDeliveryNoteMaster.QuotationMasterId = 0;
}
}
else
{
infoDeliveryNoteMaster.OrderMasterId = 0;
infoDeliveryNoteMaster.QuotationMasterId = 0;
}
infoDeliveryNoteMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
if (cmbSalesMan.SelectedIndex != -1)
{
infoDeliveryNoteMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
else
{
infoDeliveryNoteMaster.EmployeeId = 0;
}
infoDeliveryNoteMaster.Narration = txtNarration.Text;
infoDeliveryNoteMaster.TotalAmount = Convert.ToDecimal(txtTotalAmnt.Text);
infoDeliveryNoteMaster.UserId = PublicVariables._decCurrentUserId;
infoDeliveryNoteMaster.LrNo = txtLRNo.Text;
infoDeliveryNoteMaster.TransportationCompany = txtTraspotationCompany.Text;
infoDeliveryNoteMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoDeliveryNoteMaster.Extra1 = string.Empty;
infoDeliveryNoteMaster.Extra2 = string.Empty;
infoDeliveryNoteMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
if (decDelivryNoteIdToEdit == 0)
{
decDeliveryNoteMasterId = Convert.ToDecimal(bllDeliveryNote.DeliveryNoteMasterAdd(infoDeliveryNoteMaster));
}
int inRowcount = dgvProduct.Rows.Count;
for (int inI = 0; inI < inRowcount - 1; inI++)
{
if (dgvProduct.Rows[inI].Cells["dgvtxtDetailsId"].Value == null)
{
if (cmbDeliveryMode.Text == "Against Order")
{
if (dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value != null)
{
infoDeliveryNoteDetails.OrderDetails1Id = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value == null ? string.Empty : dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value.ToString());
}
else
{
infoDeliveryNoteDetails.OrderDetails1Id = 0;
infoDeliveryNoteDetails.QuotationDetails1Id = 0;
}
}
else if (cmbDeliveryMode.Text == "Against Quotation")
{
if (dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value != null)
{
infoDeliveryNoteDetails.QuotationDetails1Id = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value == null ? string.Empty : dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value.ToString());
}
else
{
infoDeliveryNoteDetails.OrderDetails1Id = 0;
infoDeliveryNoteDetails.QuotationDetails1Id = 0;
}
}
else if (cmbDeliveryMode.Text == "NA")
{
infoDeliveryNoteDetails.OrderDetails1Id = 0;
infoDeliveryNoteDetails.QuotationDetails1Id = 0;
}
}
else
{
if (cmbOrderNo.SelectedText != string.Empty)
{
if (cmbDeliveryMode.Text == "Against Order")
{
infoDeliveryNoteDetails.OrderDetails1Id = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value.ToString());
}
else if (cmbDeliveryMode.Text == "Against Quotation")
{
infoDeliveryNoteDetails.QuotationDetails1Id = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtOrderDetailsId"].Value.ToString());
}
else if (cmbDeliveryMode.Text == "NA")
{
infoDeliveryNoteDetails.OrderDetails1Id = 0;
infoDeliveryNoteDetails.QuotationDetails1Id = 0;
}
}
else
{
infoDeliveryNoteDetails.OrderDetails1Id = 0;
infoDeliveryNoteDetails.QuotationDetails1Id = 0;
}
}
infoDeliveryNoteDetails.ProductId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtProductId"].Value.ToString());
infoDeliveryNoteDetails.Qty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
infoDeliveryNoteDetails.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoDeliveryNoteDetails.UnitId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
infoDeliveryNoteDetails.Amount = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoDeliveryNoteDetails.UnitConversionId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString());
infoDeliveryNoteDetails.RackId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbRack"].Value.ToString());
infoDeliveryNoteDetails.BatchId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString());
infoDeliveryNoteDetails.GodownId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbGodown"].Value.ToString());
infoDeliveryNoteDetails.SlNo = Convert.ToInt32(dgvProduct.Rows[inI].Cells["Col"].Value.ToString());
infoDeliveryNoteDetails.Extra1 = string.Empty;
infoDeliveryNoteDetails.Extra2 = string.Empty;
if (decDelivryNoteIdToEdit == 0)
{
infoDeliveryNoteDetails.DeliveryNoteMasterId = decDeliveryNoteMasterId;
bllDeliveryNote.DeliveryNoteDetailsAdd(infoDeliveryNoteDetails);
}
else
{
infoDeliveryNoteDetails.DeliveryNoteMasterId = decDelivryNoteIdToEdit;
bllDeliveryNote.DeliveryNoteDetailsEdit(infoDeliveryNoteDetails);
}
infoStockPosting.Date = Convert.ToDateTime(txtDate.Text);
if (dgvProduct.Rows[inI].Cells["dgvtxtVoucherTypeId"].Value != null)
{
if (cmbDeliveryMode.SelectedItem.ToString() != "NA")
{
if (dgvProduct.Rows[inI].Cells["dgvtxtVoucherTypeId"].Value != null)
{
infoStockPosting.VoucherTypeId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtVoucherTypeId"].Value);
}
else
{
infoStockPosting.VoucherTypeId = 0;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtVoucherNo"].Value != null)
{
infoStockPosting.VoucherNo = dgvProduct.Rows[inI].Cells["dgvtxtVoucherNo"].Value.ToString();
}
else
{
infoStockPosting.VoucherNo = string.Empty;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtInvoiceNo"].Value != null)
{
infoStockPosting.InvoiceNo = dgvProduct.Rows[inI].Cells["dgvtxtInvoiceNo"].Value.ToString();
}
else
{
infoStockPosting.InvoiceNo = string.Empty;
}
if (decDeliveryNoteVoucherTypeId != 0)
{
infoStockPosting.AgainstVoucherTypeId = decDeliveryNoteVoucherTypeId;
}
else
{
infoStockPosting.AgainstVoucherTypeId = 0;
}
if (strVoucherNo != string.Empty)
{
infoStockPosting.AgainstVoucherNo = strVoucherNo;
}
else
{
infoStockPosting.AgainstVoucherNo = string.Empty;
}
if (txtDeliveryNoteNo.Text != string.Empty)
{
infoStockPosting.AgainstInvoiceNo = txtDeliveryNoteNo.Text;
}
else
{
infoStockPosting.AgainstInvoiceNo = string.Empty;
}
}
}
else
{
infoStockPosting.InvoiceNo = txtDeliveryNoteNo.Text;
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.VoucherTypeId = decDeliveryNoteVoucherTypeId;
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstInvoiceNo = "NA";
}
infoStockPosting.ProductId = infoDeliveryNoteDetails.ProductId;
infoStockPosting.BatchId = infoDeliveryNoteDetails.BatchId;
infoStockPosting.UnitId = infoDeliveryNoteDetails.UnitId;
infoStockPosting.GodownId = infoDeliveryNoteDetails.GodownId;
infoStockPosting.RackId = infoDeliveryNoteDetails.RackId;
infoStockPosting.OutwardQty = infoDeliveryNoteDetails.Qty;
infoStockPosting.Rate = infoDeliveryNoteDetails.Rate;
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
BllStockPosting.StockPostingAdd(infoStockPosting);
}
Messages.SavedMessage();
if (cbxPrint.Checked)
{
SettingsBll BllSettings = new SettingsBll();
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decDeliveryNoteMasterId);
}
else
{
Print(decDeliveryNoteMasterId);
}
}
}
if (btnSave.Text == "Update")
{
SettingsBll BllSettings = new SettingsBll();
infoDeliveryNoteMaster.DeliveryNoteMasterId = decDelivryNoteIdToEdit;
infoDeliveryNoteMaster.SuffixPrefixId = Convert.ToDecimal(decDeliveryNoteSuffixPrefixId);
infoDeliveryNoteMaster.VoucherNo = strVoucherNo;
infoDeliveryNoteMaster.UserId = PublicVariables._decCurrentUserId;//by default current userid used as current employeeid
infoDeliveryNoteMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
if (cmbSalesMan.SelectedIndex != -1)
{
infoDeliveryNoteMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
else
{
infoDeliveryNoteMaster.EmployeeId = 0;
}
infoDeliveryNoteMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
if (cmbOrderNo.SelectedValue != null)
{
if (cmbDeliveryMode.Text == "Against Order")
{
infoDeliveryNoteMaster.OrderMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
infoSalesOrderMaster = bllSalesOrder.SalesOrderMasterView(infoDeliveryNoteMaster.OrderMasterId);
}
else if (cmbDeliveryMode.Text == "Against Quotation")
{
infoDeliveryNoteMaster.QuotationMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
infoSalesQuotationMaster = bllSalesQuotation.SalesQuotationMasterView(infoDeliveryNoteMaster.QuotationMasterId);
}
else if (cmbDeliveryMode.Text == "NA")
{
infoDeliveryNoteMaster.OrderMasterId = 0; infoDeliveryNoteMaster.QuotationMasterId = 0;
}
}
else
{
infoDeliveryNoteMaster.OrderMasterId = 0;
infoDeliveryNoteMaster.QuotationMasterId = 0;
}
infoDeliveryNoteMaster.Narration = txtNarration.Text.Trim();
infoDeliveryNoteMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoDeliveryNoteMaster.TotalAmount = Convert.ToDecimal(txtTotalAmnt.Text);
infoDeliveryNoteMaster.TransportationCompany = txtTraspotationCompany.Text;
infoDeliveryNoteMaster.LrNo = txtLRNo.Text;
infoDeliveryNoteMaster.Extra1 = string.Empty;
infoDeliveryNoteMaster.Extra2 = string.Empty;
bllDeliveryNote.DeliveryNoteMasterEdit(infoDeliveryNoteMaster);
RemoveDeliveryNoteDetails();
infoDeliveryNoteMaster.VoucherTypeId = decDeliveryNoteVoucherTypeId;
bllDeliveryNote.StockPostDeletingForDeliveryNote(decDeliveryNoteVoucherTypeId, strVoucherNo, txtDeliveryNoteNo.Text);
DeliveryNoteDetails();
Messages.UpdatedMessage();
if (frmDeliveryNoteRegisterObj != null)
{
if (cbxPrint.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decDelivryNoteIdToEdit);
}
else
{
Print(decDelivryNoteIdToEdit);
}
}
frmDeliveryNoteRegisterObj.GridFill();
}
if (frmDeliveryNoteReportObj != null)
{
if (cbxPrint.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decDelivryNoteIdToEdit);
}
else
{
Print(decDelivryNoteIdToEdit);
}
}
frmDeliveryNoteReportObj.GridFill();
}
this.Close();
}
Clear();
}
catch (Exception ex)
{
MessageBox.Show("DN35:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to Print
/// </summary>
/// <param name="decDeliveryNoteMasterId"></param>
public void Print(decimal decDeliveryNoteMasterId)
{
try
{
DeliveryNoteMasterInfo infoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
//DeliveryNoteMasterSP spDeliveryNoteMaster = new DeliveryNoteMasterSP();
DeliveryNoteBll bllDeliveryNote = new DeliveryNoteBll();
DataSet dsDeliveryNote = bllDeliveryNote.DeliveryNotePrinting(decDeliveryNoteMasterId, 1, infoDeliveryNoteMaster.OrderMasterId, infoDeliveryNoteMaster.QuotationMasterId);
frmReport frmReport = new frmReport();
frmReport.MdiParent = formMDI.MDIObj;
frmReport.DeliveryNotePrinting(dsDeliveryNote);
}
catch (Exception ex)
{
MessageBox.Show("DN40:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// To fill the details according to the DeliveryNote master Id from frmDeliveryNoteRegister and frmDeliveryNoteReport
/// </summary>
public void FillRegisterOrReport()
{
try
{
DeliveryNoteMasterInfo infoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
VoucherTypeInfo infoVoucherType = new VoucherTypeInfo();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
//DeliveryNoteMasterSP spDeliveryNoteMaster = new DeliveryNoteMasterSP();
//DeliveryNoteDetailsSP spDeliveryNoteDetails = new DeliveryNoteDetailsSP();
DeliveryNoteBll bllDeliveryNote = new DeliveryNoteBll();
SalesOrderMasterInfo infoSalesOrderMaster = new SalesOrderMasterInfo();
SalesOrderBll bllSalesOrder = new SalesOrderBll();
SalesQuotationMasterInfo infoSalesQuotationMaster = new SalesQuotationMasterInfo();
SalesQuotationBll bllSalesQuotatin = new SalesQuotationBll();
dgvProduct.Rows.Clear();
isRegisterReportFill = true;
btnSave.Text = "Update";
int inRowIndex = 0;
btnDelete.Enabled = true;
txtDeliveryNoteNo.ReadOnly = true;
if (txtDeliveryNoteNo.ReadOnly == true)
{
txtDate.Focus();
}
else
{
txtDeliveryNoteNo.Focus();
}
infoDeliveryNoteMaster = bllDeliveryNote.DeliveryNoteMasterViewAllByMasterId(decDelivryNoteIdToEdit);
txtDeliveryNoteNo.Text = infoDeliveryNoteMaster.InvoiceNo;
strVoucherNo = infoDeliveryNoteMaster.VoucherNo.ToString();
decDeliveryNoteSuffixPrefixId = Convert.ToDecimal(infoDeliveryNoteMaster.SuffixPrefixId);
decDeliveryNoteVoucherTypeId = Convert.ToDecimal(infoDeliveryNoteMaster.VoucherTypeId);
isAutomatic = BllVoucherType.CheckMethodOfVoucherNumbering(decDeliveryNoteVoucherTypeId);
decDeliveryNoteTypeId = decDeliveryNoteVoucherTypeId;
cmbCashOrParty.SelectedValue = infoDeliveryNoteMaster.LedgerId;
txtDate.Text = infoDeliveryNoteMaster.Date.ToString("dd-MMM-yyyy");
cmbPricingLevel.SelectedValue = infoDeliveryNoteMaster.PricinglevelId;
infoVoucherType = BllVoucherType.VoucherTypeView(decDeliveryNoteVoucherTypeId);
this.Text = infoVoucherType.VoucherTypeName;
if (infoDeliveryNoteMaster.OrderMasterId != 0)
{
cmbDeliveryMode.Text = "Against Order";
infoSalesOrderMaster = bllSalesOrder.SalesOrderMasterView(infoDeliveryNoteMaster.OrderMasterId);
cmbType.SelectedValue = infoSalesOrderMaster.VoucherTypeId;
AgainstOrderComboFill();
cmbOrderNo.SelectedValue = infoDeliveryNoteMaster.OrderMasterId;
}
else if (infoDeliveryNoteMaster.QuotationMasterId != 0)
{
cmbDeliveryMode.Text = "Against Quotation";
infoSalesQuotationMaster = bllSalesQuotatin.SalesQuotationMasterView(infoDeliveryNoteMaster.QuotationMasterId);
cmbType.SelectedValue = infoSalesQuotationMaster.VoucherTypeId;
AgainstQuotationComboFill();
cmbOrderNo.SelectedValue = infoDeliveryNoteMaster.QuotationMasterId;
}
CurrencyComboFill();
cmbSalesMan.SelectedValue = infoDeliveryNoteMaster.EmployeeId;
cmbCurrency.SelectedValue = infoDeliveryNoteMaster.ExchangeRateId;
txtTraspotationCompany.Text = infoDeliveryNoteMaster.TransportationCompany;
txtNarration.Text = infoDeliveryNoteMaster.Narration;
txtLRNo.Text = infoDeliveryNoteMaster.LrNo;
txtTotalAmnt.Text = infoDeliveryNoteMaster.TotalAmount.ToString("00.00");
List<DataTable> listObjDetails = bllDeliveryNote.DeliveryNoteDetailsViewByDeliveryNoteMasterId(decDelivryNoteIdToEdit);
foreach (DataRow drowDetails in listObjDetails[0].Rows)
{
dgvProduct.Rows.Add();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtBarcode"].ReadOnly = true;
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtBarcode"].Value = drowDetails["barcode"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtDetailsId"].Value = drowDetails["deliveryNoteDetailsId"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtVoucherNo"].Value = drowDetails["VoucherNo"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtInvoiceNo"].Value = drowDetails["OrderNoOrQuotationNo"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtVoucherTypeId"].Value = drowDetails["VoucherTypeId"].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["Col"].Value = drowDetails["slNo"].ToString();
if (Convert.ToDecimal(drowDetails["orderDetails1Id"].ToString()) == 0)
{
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtOrderDetailsId"].Value = 0;
}
else
{
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtOrderDetailsId"].Value = Convert.ToDecimal(drowDetails["orderDetails1Id"].ToString());
}
if (Convert.ToDecimal(drowDetails["quotationDetails1Id"].ToString()) != 0)
{
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtOrderDetailsId"].Value = Convert.ToDecimal(drowDetails["quotationDetails1Id"].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());
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());
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["dgvtxtQty"].Value = drowDetails["qty"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtRate"].Value = drowDetails["rate"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtUnitConversionId"].Value = drowDetails["unitConversionId"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtConversionRate"].Value = drowDetails["conversionRate"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtAmount"].Value = drowDetails["amount"].ToString();
if (cmbOrderNo.Visible == true)
{
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbUnit"].ReadOnly = true;
}
if (bllDeliveryNote.DeliveryNoteMasterReferenceCheckRejectionIn(decDelivryNoteIdToEdit))
{
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtBarcode"].ReadOnly = true;
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtProductCode"].ReadOnly = true;
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtProductName"].ReadOnly = true;
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbBatch"].ReadOnly = true;
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbGodown"].ReadOnly = true;
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbRack"].ReadOnly = true;
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtRate"].ReadOnly = true;
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvcmbUnit"].ReadOnly = true;
}
dgvProduct.Rows[dgvProduct.Rows.Count - 2].HeaderCell.Value = "";
AmountCalculation("dgvtxtQty", inRowIndex);
TotalAmountCalculation();
}
if (!isAutomatic)
{
txtDeliveryNoteNo.ReadOnly = false;
txtDeliveryNoteNo.Focus();
}
isRegisterReportFill = false;
isDoAfterGridFill = true;
}
catch (Exception ex)
{
MessageBox.Show("DN19: " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Edit Function
/// </summary>
public void EditFunction()
{
try
{
removeSalesInvoiceDetails();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
SalesMasterInfo InfoSalesMaster = new SalesMasterInfo();
InfoSalesMaster = BllSalesInvoice.SalesMasterView(decSalesInvoiceIdToEdit);
if (InfoSalesMaster.DeliveryNoteMasterId != 0)
{
DeliveryNoteMasterInfo infoDeliveryNote = new DeliveryNoteMasterInfo();
infoDeliveryNote = new DeliveryNoteBll().DeliveryNoteMasterView(InfoSalesMaster.DeliveryNoteMasterId);
new StockPostingBll().StockPostingDeleteForSalesInvoiceAgainstDeliveryNote
(InfoSalesMaster.VoucherTypeId, InfoSalesMaster.VoucherNo,
infoDeliveryNote.VoucherNo, infoDeliveryNote.VoucherTypeId);
}
new StockPostingBll().StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType
(0, "NA", InfoSalesMaster.VoucherNo, InfoSalesMaster.VoucherTypeId);
InfoSalesMaster.SalesMasterId = decSalesInvoiceIdToEdit;
InfoSalesMaster.AdditionalCost = Convert.ToDecimal(lblLedgerTotalAmount.Text);
InfoSalesMaster.BillDiscount = Convert.ToDecimal(txtBillDiscount.Text.Trim());
InfoSalesMaster.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text.Trim().ToString());
InfoSalesMaster.CustomerName = txtCustomer.Text.Trim();
InfoSalesMaster.Date = Convert.ToDateTime(txtDate.Text.ToString());
InfoSalesMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
InfoSalesMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
InfoSalesMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoSalesMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text.Trim());
InfoSalesMaster.InvoiceNo = txtInvoiceNo.Text.Trim();
InfoSalesMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
InfoSalesMaster.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
InfoSalesMaster.VoucherNo = strVoucherNo;
if (isAutomatic)
{
InfoSalesMaster.SuffixPrefixId = decSalseInvoiceSuffixPrefixId;
}
else
{
InfoSalesMaster.SuffixPrefixId = 0;
}
if (cmbSalesMode.Text == "Against SalesOrder")
{
InfoSalesMaster.OrderMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.OrderMasterId = 0;
}
if (cmbSalesMode.Text == "Against Delivery Note")
{
InfoSalesMaster.DeliveryNoteMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.DeliveryNoteMasterId = 0;
}
if (cmbSalesMode.Text == "Against Quotation")
{
InfoSalesMaster.QuotationMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.QuotationMasterId = 0;
}
InfoSalesMaster.Narration = txtNarration.Text.Trim();
InfoSalesMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
InfoSalesMaster.SalesAccount = Convert.ToDecimal(cmbSalesAccount.SelectedValue.ToString());
InfoSalesMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text.Trim());
if (dgvSalesInvoice.Columns["dgvcmbSalesInvoiceTaxName"].Visible)
{
InfoSalesMaster.TaxAmount = Convert.ToDecimal(lblTaxTotalAmount.Text.Trim());
}
else
{
InfoSalesMaster.TaxAmount = 0;
}
InfoSalesMaster.UserId = PublicVariables._decCurrentUserId;
InfoSalesMaster.LrNo = txtVehicleNo.Text;
InfoSalesMaster.TransportationCompany = txtTransportCompany.Text.Trim();
InfoSalesMaster.POS = false;
InfoSalesMaster.CounterId = 0;
InfoSalesMaster.ExtraDate = DateTime.Now;
InfoSalesMaster.Extra1 = string.Empty;
InfoSalesMaster.Extra2 = string.Empty;
BllSalesInvoice.SalesMasterEdit(InfoSalesMaster);
removeSalesInvoiceDetails();
SalesInvoiceDetailsEditFill();
if (cmbCashOrParty.Enabled)
{
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
BllLedgerPosting.LedgerPostDelete(strVoucherNo, DecSalesInvoiceVoucherTypeId);
ledgerPostingAdd();
}
else
{
ledgerPostingEdit();
}
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
SettingsBll BllSettings = new SettingsBll();
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesInvoiceIdToEdit);
}
else
{
Print(decSalesInvoiceIdToEdit);
}
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("SI: 78" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// function to Rejection In updation
/// </summary>
public void RejectionInview()
{
decimal decRejectioInMasterId = 0;
try
{
btnSave.Text = "Update";
btnDelete.Enabled = true;
isFromRejectionInRegister = true;
// RejectionInMasterSP SpRejectionInMaster = new RejectionInMasterSP();
RejectionInBll bllRejectionIn = new RejectionInBll();
RejectionInMasterInfo InfoRejectionInMaster = new RejectionInMasterInfo();
InfoRejectionInMaster = bllRejectionIn.RejectionInMasterView(decRejectionInIdToEdit);
//DeliveryNoteMasterSP SpDeliveryNoteMaster = new DeliveryNoteMasterSP();
DeliveryNoteBll bllDeliveryNote = new DeliveryNoteBll();
DeliveryNoteMasterInfo InfoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
InfoDeliveryNoteMaster = bllDeliveryNote.DeliveryNoteMasterView(InfoRejectionInMaster.DeliveryNoteMasterId);
strRejectionInVoucherNo = bllRejectionIn.GetRejectionInVoucherNo(InfoRejectionInMaster.RejectionInMasterId);
decRejectionInVoucherTypeId = InfoRejectionInMaster.VoucherTypeId;
decRejectionInSuffixPrefixId = InfoRejectionInMaster.SuffixPrefixId;
strVoucherNo = InfoRejectionInMaster.VoucherNo;
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
isAutomatic = BllVoucherType.CheckMethodOfVoucherNumbering(decRejectionInVoucherTypeId);
if (!isAutomatic)
{
txtRejectionInNo.ReadOnly = false;
txtRejectionInNo.Focus();
}
else
{
txtRejectionInNo.ReadOnly = true;
txtDate.Focus();
}
txtRejectionInNo.Text = InfoRejectionInMaster.InvoiceNo;
txtDate.Text = InfoRejectionInMaster.Date.ToString("dd-MMM-yyyy");
dtpDate.Value = Convert.ToDateTime(txtDate.Text);
cmbCashorParty.SelectedValue = InfoRejectionInMaster.LedgerId;
cmbVoucherType.SelectedValue = InfoDeliveryNoteMaster.VoucherTypeId;
cmbPricingLevel.SelectedValue = InfoRejectionInMaster.PricinglevelId;
cmbDeliveryNoteNo.SelectedValue = InfoRejectionInMaster.DeliveryNoteMasterId;
cmbSalesMan.SelectedValue = InfoRejectionInMaster.EmployeeId;
cmbCurrency.SelectedValue = InfoRejectionInMaster.ExchangeRateId;
txtTransportationCompany.Text = InfoRejectionInMaster.TransportationCompany;
txtNarration.Text = InfoRejectionInMaster.Narration;
txtLRNo.Text = InfoRejectionInMaster.LrNo;
txtTotalAmount.Text = Convert.ToString(InfoRejectionInMaster.TotalAmount);
RejectionInBll bllRejectionInBll = new RejectionInBll();
List<DataTable> listRejectionInDetails = bllRejectionInBll.RejectionInDetailsViewByRejectionInMasterId(decRejectionInIdToEdit);
decRejectioInMasterId = Convert.ToDecimal(listRejectionInDetails[0].Rows[0]["voucherTypeId"].ToString());
VoucherTypeInfo infoVoucherType = new VoucherTypeInfo();
infoVoucherType = BllVoucherType.VoucherTypeView(decRejectioInMasterId);
this.Text = infoVoucherType.VoucherTypeName;
foreach (DataRow drRejectionInDetails in listRejectionInDetails[0].Rows)
{
isDoCellValueChange = false;
DGVGodownComboFill();
dgvProduct.Rows.Add();
dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtProductId"].Value = drRejectionInDetails["productId"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxDeliveryNoteDetailsId"].Value = drRejectionInDetails.ItemArray[2].ToString();
AssignProductDefaultValues(dgvProduct.Rows.Count - 1, Convert.ToDecimal(drRejectionInDetails.ItemArray[3].ToString()));
DGVBatchComboFill(dgvProduct.Rows.Count - 1, Convert.ToDecimal(drRejectionInDetails.ItemArray[3].ToString()));
dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtQuantity"].Value = drRejectionInDetails["qty"].ToString();
isDoCellValueChange = true;
dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(drRejectionInDetails["unitId"].ToString());
dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drRejectionInDetails["unitconversionId"].ToString());
dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbGodown"].Value = Convert.ToDecimal(drRejectionInDetails["godownId"].ToString());
dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbRack"].Value = Convert.ToDecimal(drRejectionInDetails["rackId"].ToString());
dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(drRejectionInDetails["batchId"].ToString());
dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtRate"].Value = drRejectionInDetails["rate"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 1].Cells["dgvtxtAmount"].Value = drRejectionInDetails["amount"].ToString();
dgvProduct.CurrentCell = null;
}
SerialNo();
CalcTotalAmt();
isDoCellValueChange = true;
isDoAfterGridFill = true;
isFromRejectionInRegister = false;
}
catch (Exception ex)
{
MessageBox.Show("RI:35" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save or edit function
/// </summary>
public void SaveOrEdit()
{
SettingsBll BllSettings = new SettingsBll();
try
{
decimal decIdentity = 0;
DeliveryNoteBll bllDeliveryNote = new DeliveryNoteBll();
DeliveryNoteMasterInfo InfoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
InfoDeliveryNoteMaster = bllDeliveryNote.DeliveryNoteMasterView(Convert.ToDecimal(cmbDeliveryNoteNo.SelectedValue));
RejectionInMasterInfo InfoRejectionInMaster = new RejectionInMasterInfo();
RejectionInDetailsInfo InfoRejectionInDetails = new RejectionInDetailsInfo();
RejectionInBll bllRejectionIn = new RejectionInBll();
StockPostingInfo InfoStockPosting = new StockPostingInfo();
StockPostingBll BllStockPosting = new StockPostingBll();
if (isAutomatic)
{
InfoRejectionInMaster.VoucherNo = strVoucherNo;
InfoRejectionInMaster.InvoiceNo = txtRejectionInNo.Text;
}
else
{
InfoRejectionInMaster.VoucherNo = txtRejectionInNo.Text;
InfoRejectionInMaster.InvoiceNo = txtRejectionInNo.Text;
}
InfoRejectionInMaster.VoucherTypeId = decRejectionInVoucherTypeId;
InfoRejectionInMaster.SuffixPrefixId = decRejectionInSuffixPrefixId;
InfoRejectionInMaster.Date = DateTime.Parse(txtDate.Text);
InfoRejectionInMaster.LedgerId = Convert.ToDecimal(cmbCashorParty.SelectedValue.ToString());
InfoRejectionInMaster.PricinglevelId = cmbPricingLevel.SelectedValue == null ? 0 : Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
InfoRejectionInMaster.EmployeeId = cmbSalesMan.SelectedValue == null ? 1 : Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
InfoRejectionInMaster.Narration = txtNarration.Text.Trim();
InfoRejectionInMaster.ExchangeRateId = cmbCurrency.SelectedValue == null ? 0 : Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
InfoRejectionInMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
InfoRejectionInMaster.UserId = PublicVariables._decCurrentUserId;
InfoRejectionInMaster.LrNo = txtLRNo.Text.Trim();
InfoRejectionInMaster.TransportationCompany = txtTransportationCompany.Text.Trim();
InfoRejectionInMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoRejectionInMaster.Extra1 = string.Empty;
InfoRejectionInMaster.Extra2 = string.Empty;
InfoRejectionInMaster.DeliveryNoteMasterId = Convert.ToDecimal(cmbDeliveryNoteNo.SelectedValue == null ? "" : cmbDeliveryNoteNo.SelectedValue.ToString());
if (decRejectionInIdToEdit == 0)
{
decIdentity = bllRejectionIn.RejectionInMasterAdd(InfoRejectionInMaster);
}
else
{
InfoRejectionInMaster.RejectionInMasterId = decRejectionInIdToEdit;
bllRejectionIn.RejectionInMasterEdit(InfoRejectionInMaster);
}
if (decRejectionInIdToEdit == 0)
{
InfoRejectionInDetails.RejectionInMasterId = decIdentity;
}
else
{
bllRejectionIn.DeleteRejectionInDetailsByRejectionInMasterId(decRejectionInIdToEdit);
BllStockPosting.DeleteStockPostingByAgnstVouTypeIdAndAgnstVouNo(decRejectionInVoucherTypeId, strVoucherNo);
InfoRejectionInDetails.RejectionInMasterId = decRejectionInIdToEdit;
}
foreach (DataGridViewRow dgvrow in dgvProduct.Rows)
{
InfoRejectionInDetails.DeliveryNoteDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxDeliveryNoteDetailsId"].Value.ToString());
InfoRejectionInDetails.ProductId = Convert.ToDecimal(dgvrow.Cells["dgvtxtProductId"].Value.ToString());
InfoRejectionInDetails.Qty = Convert.ToDecimal(dgvrow.Cells["dgvtxtQuantity"].Value.ToString());
InfoRejectionInDetails.Rate = Convert.ToDecimal(dgvrow.Cells["dgvtxtRate"].Value.ToString());
InfoRejectionInDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
InfoRejectionInDetails.UnitConversionId = Convert.ToDecimal(dgvrow.Cells["dgvtxtUnitConversionId"].Value.ToString());//0;//check
InfoRejectionInDetails.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value.ToString());
InfoRejectionInDetails.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value.ToString());
InfoRejectionInDetails.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value.ToString());
InfoRejectionInDetails.Amount = Convert.ToDecimal(dgvrow.Cells["dgvtxtAmount"].Value.ToString());
InfoRejectionInDetails.SlNo = Convert.ToInt32(dgvrow.Cells["dgvtxtSlNo"].Value.ToString());
InfoRejectionInDetails.Extra1 = string.Empty;
InfoRejectionInDetails.Extra2 = string.Empty;
bllRejectionInBll.RejectionInDetailsAdd(InfoRejectionInDetails);
InfoStockPosting.Date = Convert.ToDateTime(txtDate.Text);
InfoStockPosting.VoucherTypeId = InfoDeliveryNoteMaster.VoucherTypeId;
InfoStockPosting.VoucherNo = InfoDeliveryNoteMaster.VoucherNo;
InfoStockPosting.InvoiceNo = InfoDeliveryNoteMaster.InvoiceNo;
InfoStockPosting.ProductId = Convert.ToDecimal(dgvrow.Cells["dgvtxtProductId"].Value.ToString());
InfoStockPosting.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value.ToString());
InfoStockPosting.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
InfoStockPosting.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value.ToString());
InfoStockPosting.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value.ToString());
InfoStockPosting.AgainstVoucherTypeId = decRejectionInVoucherTypeId;
if (isAutomatic)
{
InfoStockPosting.AgainstInvoiceNo = txtRejectionInNo.Text;
InfoStockPosting.AgainstVoucherNo = strVoucherNo;
}
else
{
InfoStockPosting.AgainstInvoiceNo = txtRejectionInNo.Text;
InfoStockPosting.AgainstVoucherNo = txtRejectionInNo.Text;
}
InfoStockPosting.InwardQty = Convert.ToDecimal(dgvrow.Cells["dgvtxtQuantity"].Value.ToString());
InfoStockPosting.OutwardQty = 0;
InfoStockPosting.Rate = Convert.ToDecimal(dgvrow.Cells["dgvtxtRate"].Value.ToString());
InfoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoStockPosting.Extra1 = string.Empty;
InfoStockPosting.Extra2 = string.Empty;
BllStockPosting.StockPostingAdd(InfoStockPosting);
}
if (decRejectionInIdToEdit == 0)
{
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decIdentity);
}
else
{
Print(decIdentity);
}
}
}
else
{
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decRejectionInIdToEdit);
}
else
{
Print(decRejectionInIdToEdit);
}
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("RI:23" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}