public SalesOrderDetailsInfo QuantityEditingAfterCheckingSalesQuotationForSalesOrder(decimal decSalesOrderId, decimal decProductId)
{
SalesOrderDetailsInfo infoSalesOrderDetails = new SalesOrderDetailsInfo();
SqlDataReader sdrReader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sqlcmd = new SqlCommand("QuantityEditingAfterCheckingSalesQuotationForSalesOrder", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sqlcmd.Parameters.Add("@salesOrderMasterId", SqlDbType.Decimal);
sprmparam.Value = decSalesOrderId;
sprmparam = sqlcmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = decProductId;
sdrReader = sqlcmd.ExecuteReader();
while (sdrReader.Read())
{
infoSalesOrderDetails.Qty = Convert.ToDecimal(sdrReader["Qty"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrReader.Close();
sqlcon.Close();
}
return(infoSalesOrderDetails);
}
/// <summary>
/// Function to Update values in SalesOrderDetails Table
/// </summary>
/// <param name="salesorderdetailsinfo"></param>
public void SalesOrderDetailsEdit(SalesOrderDetailsInfo salesorderdetailsinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("SalesOrderDetailsEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@salesOrderDetailsId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.SalesOrderDetailsId;
sprmparam = sccmd.Parameters.Add("@salesOrderMasterId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.SalesOrderMasterId;
sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.ProductId;
sprmparam = sccmd.Parameters.Add("@qty", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.Qty;
sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.Rate;
sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.UnitId;
sprmparam = sccmd.Parameters.Add("@unitConversionId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.UnitConversionId;
//sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal);
//sprmparam.Value = salesorderdetailsinfo.ExchangeRateId;
sprmparam = sccmd.Parameters.Add("@amount", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.Amount;
sprmparam = sccmd.Parameters.Add("@quotationDetailsId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.QuotationDetailsId;
sprmparam = sccmd.Parameters.Add("@batchId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.BatchId;
sprmparam = sccmd.Parameters.Add("@slNo", SqlDbType.Int);
sprmparam.Value = salesorderdetailsinfo.SlNo;
// sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
// sprmparam.Value = salesorderdetailsinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = salesorderdetailsinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = salesorderdetailsinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to Update values in SalesOrderDetails Table
/// </summary>
/// <param name="salesorderdetailsinfo"></param>
public void SalesOrderDetailsEdit(SalesOrderDetailsInfo salesorderdetailsinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("SalesOrderDetailsEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@salesOrderDetailsId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.SalesOrderDetailsId;
sprmparam = sccmd.Parameters.Add("@salesOrderMasterId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.SalesOrderMasterId;
sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.ProductId;
sprmparam = sccmd.Parameters.Add("@qty", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.Qty;
sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.Rate;
sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.UnitId;
sprmparam = sccmd.Parameters.Add("@unitConversionId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.UnitConversionId;
//sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal);
//sprmparam.Value = salesorderdetailsinfo.ExchangeRateId;
sprmparam = sccmd.Parameters.Add("@amount", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.Amount;
sprmparam = sccmd.Parameters.Add("@quotationDetailsId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.QuotationDetailsId;
sprmparam = sccmd.Parameters.Add("@batchId", SqlDbType.Decimal);
sprmparam.Value = salesorderdetailsinfo.BatchId;
sprmparam = sccmd.Parameters.Add("@slNo", SqlDbType.Int);
sprmparam.Value = salesorderdetailsinfo.SlNo;
// sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
// sprmparam.Value = salesorderdetailsinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = salesorderdetailsinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = salesorderdetailsinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to get particular values from SalesOrderDetails Table based on the parameter
/// </summary>
/// <param name="salesOrderDetailsId"></param>
/// <returns></returns>
public SalesOrderDetailsInfo SalesOrderDetailsView(decimal salesOrderDetailsId)
{
SalesOrderDetailsInfo salesorderdetailsinfo = new SalesOrderDetailsInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("SalesOrderDetailsView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@salesOrderDetailsId", SqlDbType.Decimal);
sprmparam.Value = salesOrderDetailsId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
salesorderdetailsinfo.SalesOrderDetailsId = decimal.Parse(sdrreader[0].ToString());
salesorderdetailsinfo.SalesOrderMasterId = decimal.Parse(sdrreader[1].ToString());
salesorderdetailsinfo.ProductId = decimal.Parse(sdrreader[2].ToString());
salesorderdetailsinfo.Qty = decimal.Parse(sdrreader[3].ToString());
salesorderdetailsinfo.Rate = decimal.Parse(sdrreader[4].ToString());
salesorderdetailsinfo.UnitId = decimal.Parse(sdrreader[5].ToString());
salesorderdetailsinfo.UnitConversionId = decimal.Parse(sdrreader[6].ToString());
salesorderdetailsinfo.Amount = decimal.Parse(sdrreader[7].ToString());
salesorderdetailsinfo.QuotationDetailsId = decimal.Parse(sdrreader[8].ToString());
salesorderdetailsinfo.SlNo = int.Parse(sdrreader[9].ToString());
salesorderdetailsinfo.ExtraDate = DateTime.Parse(sdrreader[10].ToString());
salesorderdetailsinfo.Extra1 = sdrreader[11].ToString();
salesorderdetailsinfo.Extra2 = sdrreader[12].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return(salesorderdetailsinfo);
}
public SalesOrderDetailsInfo QuantityEditingAfterCheckingSalesQuotationForSalesOrder(decimal decSalesOrderId, decimal decProductId)
{
SalesOrderDetailsInfo infoSalesOrderDetails = new SalesOrderDetailsInfo();
SqlDataReader sdrReader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sqlcmd = new SqlCommand("QuantityEditingAfterCheckingSalesQuotationForSalesOrder", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sqlcmd.Parameters.Add("@salesOrderMasterId", SqlDbType.Decimal);
sprmparam.Value = decSalesOrderId;
sprmparam = sqlcmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = decProductId;
sdrReader = sqlcmd.ExecuteReader();
while (sdrReader.Read())
{
infoSalesOrderDetails.Qty = Convert.ToDecimal(sdrReader["Qty"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrReader.Close();
sqlcon.Close();
}
return infoSalesOrderDetails;
}
/// <summary>
/// Function to get particular values from SalesOrderDetails Table based on the parameter
/// </summary>
/// <param name="salesOrderDetailsId"></param>
/// <returns></returns>
public SalesOrderDetailsInfo SalesOrderDetailsView(decimal salesOrderDetailsId)
{
SalesOrderDetailsInfo salesorderdetailsinfo = new SalesOrderDetailsInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("SalesOrderDetailsView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@salesOrderDetailsId", SqlDbType.Decimal);
sprmparam.Value = salesOrderDetailsId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
salesorderdetailsinfo.SalesOrderDetailsId = decimal.Parse(sdrreader[0].ToString());
salesorderdetailsinfo.SalesOrderMasterId = decimal.Parse(sdrreader[1].ToString());
salesorderdetailsinfo.ProductId = decimal.Parse(sdrreader[2].ToString());
salesorderdetailsinfo.Qty = decimal.Parse(sdrreader[3].ToString());
salesorderdetailsinfo.Rate = decimal.Parse(sdrreader[4].ToString());
salesorderdetailsinfo.UnitId = decimal.Parse(sdrreader[5].ToString());
salesorderdetailsinfo.UnitConversionId = decimal.Parse(sdrreader[6].ToString());
salesorderdetailsinfo.Amount = decimal.Parse(sdrreader[7].ToString());
salesorderdetailsinfo.QuotationDetailsId = decimal.Parse(sdrreader[8].ToString());
salesorderdetailsinfo.SlNo = int.Parse(sdrreader[9].ToString());
salesorderdetailsinfo.ExtraDate = DateTime.Parse(sdrreader[10].ToString());
salesorderdetailsinfo.Extra1 = sdrreader[11].ToString();
salesorderdetailsinfo.Extra2 = sdrreader[12].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return salesorderdetailsinfo;
}
/// <summary>
/// Edit Function When update datas in Register or Report
/// </summary>
public void EditFunction()
{
try
{
decimal decSalesOrderSuffixPrefixId = 0;
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
SalesOrderDetailsSP spSalesOrderDetails = new SalesOrderDetailsSP();
SalesOrderMasterInfo infoSalesOrderMaster = new SalesOrderMasterInfo();
SalesOrderDetailsInfo infoSalesOrderDetails = new SalesOrderDetailsInfo();
infoSalesOrderMaster.VoucherTypeId = decSalesVoucherId;
for (int inI = 0; inI < dgvSalesOrder.Rows.Count - 1; inI++)
{
if (Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesOrderDetailsId"].Value) != null && Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesOrderDetailsId"].Value) != 0)
{
//for (int i = 0; i < dgvSalesOrder.Rows.Count - 1; i++)
//{
isEditDetails = Convert.ToString(spSalesOrderDetails.SalesOrderRefererenceCheckForEditDetails(Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesOrderDetailsId"].Value)));
//}
}
}
isEditMaster = Convert.ToString(spSalesOrderMaster.SalesOrderRefererenceCheckForEditMaster(decSalesOrderMasterId));
if (isEditMaster == "False" && isEditDetails == "False")
{
infoSalesOrderMaster.SalesOrderMasterId = decSalesOrderMasterId;
infoSalesOrderMaster.Cancelled = cbxCancelled.Checked;
infoSalesOrderMaster.Date = Convert.ToDateTime(txtDate.Text);
infoSalesOrderMaster.DueDate = Convert.ToDateTime(txtDueDate.Text);
infoSalesOrderMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoSalesOrderMaster.SuffixPrefixId = Convert.ToDecimal(decSalesOrderSuffixPrefixId);
infoSalesOrderMaster.VoucherNo = strVoucherNo;
infoSalesOrderMaster.InvoiceNo = txtOrderNo.Text;
infoSalesOrderMaster.UserId = PublicVariables._decCurrentUserId;
infoSalesOrderMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
infoSalesOrderMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
if (cmbQuotationNo.SelectedIndex == -1)
{
infoSalesOrderMaster.QuotationMasterId = 0;
}
else
{
infoSalesOrderMaster.QuotationMasterId = Convert.ToDecimal(cmbQuotationNo.SelectedValue.ToString());
}
infoSalesOrderMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoSalesOrderMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoSalesOrderMaster.Narration = txtNarration.Text.Trim();
infoSalesOrderMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
infoSalesOrderMaster.Extra1 = string.Empty;
infoSalesOrderMaster.Extra2 = string.Empty;
RemoveSalesOrderDetails();
spSalesOrderMaster.SalesOrderMasterEdit(infoSalesOrderMaster);
SalesOrderDetailsEditFill();
Messages.UpdatedMessage();
if (frmSalesOrderRegisterObj != null)
{
if (cbxPrintAfterSave.Checked == true)
{
if (new SettingsSP().SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesOrderMasterId);
}
else
{
Print(decSalesOrderMasterId);
}
}
this.Close();
frmSalesOrderRegisterObj.GridFill();
}
if (frmSalesOrderReportObj != null)
{
if (cbxPrintAfterSave.Checked == true)
{
if (new SettingsSP().SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesOrderMasterId);
}
else
{
Print(decSalesOrderMasterId);
}
}
this.Close();
frmSalesOrderReportObj.GridFill();
}
if (frmDayBookObj != null)
{
if (cbxPrintAfterSave.Checked == true)
{
if (new SettingsSP().SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesOrderMasterId);
}
else
{
Print(decSalesOrderMasterId);
}
}
this.Close();
}
if (objVoucherSearch != null)
{
if (cbxPrintAfterSave.Checked == true)
{
if (new SettingsSP().SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesOrderMasterId);
}
else
{
Print(decSalesOrderMasterId);
}
}
this.Close();
objVoucherSearch.GridFill();
}
}
else
{
Messages.ReferenceExistsMessageForUpdate();
}
}
catch (Exception ex)
{
MessageBox.Show("SO47:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the SaveItems to table
/// </summary>
public void SaveFunction()
{
try
{
decimal decSalesOrderSuffixPrefixId = 0;
SalesOrderDetailsInfo infoSalesOrderDetails = new SalesOrderDetailsInfo();
SalesOrderMasterInfo infoSalesOrderMaster = new SalesOrderMasterInfo();
SalesOrderDetailsSP spSalesOrderDetails = new SalesOrderDetailsSP();
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
infoSalesOrderMaster.Cancelled = false;
infoSalesOrderMaster.Date = Convert.ToDateTime(txtDate.Text);
infoSalesOrderMaster.DueDate = Convert.ToDateTime(txtDueDate.Text);
infoSalesOrderMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
if (isAutomatic)
{
infoSalesOrderMaster.SuffixPrefixId = decSalesOrderSuffixPrefixId;
infoSalesOrderMaster.VoucherNo = strVoucherNo;
}
else
{
infoSalesOrderMaster.SuffixPrefixId = 0;
infoSalesOrderMaster.VoucherNo = spSalesOrderMaster.VoucherNoMax(decSalesOrderTypeId);
}
infoSalesOrderMaster.VoucherTypeId = decSalesOrderTypeId;
infoSalesOrderMaster.InvoiceNo = txtOrderNo.Text;
infoSalesOrderMaster.UserId = PublicVariables._decCurrentUserId;
if (cmbSalesMan.SelectedIndex == -1)
{
infoSalesOrderMaster.SalesOrderMasterId = 0;
}
else
{
infoSalesOrderMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
infoSalesOrderMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
if (cmbPricingLevel.SelectedIndex == -1)
{
infoSalesOrderMaster.PricinglevelId = 0;
}
else
{
infoSalesOrderMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
}
infoSalesOrderMaster.Narration = txtNarration.Text.Trim();
if (cmbQuotationNo.SelectedIndex == -1)
{
infoSalesOrderMaster.QuotationMasterId = 0;
}
else
{
infoSalesOrderMaster.QuotationMasterId = Convert.ToDecimal(cmbQuotationNo.SelectedValue.ToString());
}
infoSalesOrderMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoSalesOrderMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
infoSalesOrderMaster.Extra1 = string.Empty;
infoSalesOrderMaster.Extra2 = string.Empty;
decSalesOrderMasterIdentity = Convert.ToDecimal(spSalesOrderMaster.SalesOrderMasterAdd(infoSalesOrderMaster));
int inRowcount = dgvSalesOrder.Rows.Count;
for (int inI = 0; inI < inRowcount - 1; inI++)
{
infoSalesOrderDetails.SalesOrderMasterId = decSalesOrderMasterIdentity;
if (dgvSalesOrder.Rows[inI].Cells["dgvtxtProductCode"].Value != null && dgvSalesOrder.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString() != "")
{
infoProduct = new ProductSP().ProductViewByCode(dgvSalesOrder.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoSalesOrderDetails.ProductId = infoProduct.ProductId;
}
if (dgvSalesOrder.Rows[inI].Cells["dgvtxtQty"].Value != null && dgvSalesOrder.Rows[inI].Cells["dgvtxtQty"].Value.ToString() != "")
{
infoSalesOrderDetails.Qty = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
}
if (dgvSalesOrder.Rows[inI].Cells["dgvcmbUnit"].Value != null && dgvSalesOrder.Rows[inI].Cells["dgvcmbUnit"].Value.ToString() != "")
{
infoSalesOrderDetails.UnitId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
infoSalesOrderDetails.UnitConversionId = decConversionId;
}
if (dgvSalesOrder.Rows[inI].Cells["dgvtxtUnitConversionId"].Value != null && dgvSalesOrder.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString() != "")
{
infoSalesOrderDetails.UnitConversionId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString());
}
if (dgvSalesOrder.Rows[inI].Cells["dgvcmbBatch"].Value != null && dgvSalesOrder.Rows[inI].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
infoSalesOrderDetails.BatchId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvcmbBatch"].Value.ToString());
}
if (dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesQuotationDetailsId"].Value == null || dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesQuotationDetailsId"].Value.ToString() == "")
{
infoSalesOrderDetails.QuotationDetailsId = Convert.ToDecimal(0);
}
else
{
infoSalesOrderDetails.QuotationDetailsId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesQuotationDetailsId"].Value);
}
infoSalesOrderDetails.Rate = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoSalesOrderDetails.Amount = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoSalesOrderDetails.SlNo = Convert.ToInt32(dgvSalesOrder.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoSalesOrderDetails.UnitConversionId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString());
infoSalesOrderDetails.Extra1 = string.Empty;
infoSalesOrderDetails.Extra2 = string.Empty;
spSalesOrderDetails.SalesOrderDetailsAdd(infoSalesOrderDetails);
}
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked == true)
{
if (new SettingsSP().SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesOrderMasterIdentity);
}
else
{
Print(decSalesOrderMasterIdentity);
}
}
Clear();
}
catch (Exception ex)
{
MessageBox.Show("SO46:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to Editthe sales order details
/// </summary>
public void SalesOrderDetailsEditFill()
{
try
{
SalesOrderDetailsInfo infoSalesOrderDetails = new SalesOrderDetailsInfo();
SalesOrderMasterInfo infoSalesOrderMaster = new SalesOrderMasterInfo();
SalesOrderDetailsSP spSalesOrderDetails = new SalesOrderDetailsSP();
SalesOrderMasterSP spSalesOrdermaster = new SalesOrderMasterSP();
for (int inI = 0; inI < dgvSalesOrder.Rows.Count - 1; inI++)
{
if (Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesOrderDetailsId"].Value) == 0 || dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesOrderDetailsId"].Value == null)
{
infoSalesOrderDetails.SalesOrderMasterId = decSalesOrderMasterId;
infoSalesOrderDetails.SalesOrderDetailsId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesOrderDetailsId"].Value);
infoProduct = new ProductSP().ProductViewByCode(dgvSalesOrder.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoSalesOrderDetails.ProductId = infoProduct.ProductId;
infoSalesOrderDetails.Qty = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtQty"].Value);
infoSalesOrderDetails.UnitId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
infoSalesOrderDetails.UnitConversionId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString());
infoSalesOrderDetails.BatchId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvcmbBatch"].Value.ToString());
infoSalesOrderDetails.Rate = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoSalesOrderDetails.Amount = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoSalesOrderDetails.SlNo = Convert.ToInt32(dgvSalesOrder.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
if (dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesQuotationDetailsId"].Value != null && dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesQuotationDetailsId"].Value.ToString() != string.Empty)
{
infoSalesOrderDetails.QuotationDetailsId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesQuotationDetailsId"].Value.ToString());
}
else
{
infoSalesOrderMaster.QuotationMasterId = 0;
}
infoSalesOrderDetails.Extra1 = string.Empty;
infoSalesOrderDetails.Extra2 = string.Empty;
spSalesOrderDetails.SalesOrderDetailsAdd(infoSalesOrderDetails);
}
else
{
infoSalesOrderDetails.SalesOrderMasterId = decSalesOrderMasterId;
infoSalesOrderDetails.SalesOrderDetailsId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesOrderDetailsId"].Value);
infoProduct = new ProductSP().ProductViewByCode(dgvSalesOrder.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoSalesOrderDetails.ProductId = infoProduct.ProductId;
infoSalesOrderDetails.Qty = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtQty"].Value);
infoSalesOrderDetails.UnitId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
infoSalesOrderDetails.UnitConversionId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtUnitConversionId"].Value.ToString());
infoSalesOrderDetails.BatchId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvcmbBatch"].Value.ToString());
infoSalesOrderDetails.Rate = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoSalesOrderDetails.Amount = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoSalesOrderDetails.SlNo = Convert.ToInt32(dgvSalesOrder.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
if (dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesQuotationDetailsId"].Value != null && dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesQuotationDetailsId"].Value.ToString() != string.Empty)
{
infoSalesOrderDetails.QuotationDetailsId = Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesQuotationDetailsId"].Value.ToString());
}
else
{
infoSalesOrderMaster.QuotationMasterId = 0;
}
infoSalesOrderDetails.Extra1 = string.Empty;
infoSalesOrderDetails.Extra2 = string.Empty;
spSalesOrderDetails.SalesOrderDetailsEdit(infoSalesOrderDetails);
}
}
}
catch (Exception ex)
{
MessageBox.Show("SO43:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Fill Details Corresponding Quotation No
/// </summary>
public void FillQuotationDetails()
{
SerialNo();
try
{
SalesOrderDetailsInfo infoSalesOrderDetails = new SalesOrderDetailsInfo();
TransactionsGeneralFill TransactionGeneralFillObj = new TransactionsGeneralFill();
decimal decOrderNo = 0;
if (!isEditFill)
{
inMaxCount = 0;
decOrderNo = Convert.ToDecimal(cmbQuotationNo.SelectedValue.ToString());
dgvSalesOrder.Rows.Clear();
DataTable dtblMaster = new SalesQuotationMasterSP().QuotationMasterViewByQuotationMasterId(Convert.ToDecimal(cmbQuotationNo.SelectedValue.ToString()));
if (dtblMaster.Rows.Count > 0)
{
cmbPricingLevel.SelectedValue = dtblMaster.Rows[0]["pricingLevelId"].ToString();
if (dtblMaster.Rows[0]["employeeId"].ToString() != "")
{
strSalesMan = dtblMaster.Rows[0]["employeeId"].ToString();
cmbSalesMan.SelectedValue = strSalesMan;
if (cmbSalesMan.SelectedValue == null)
{
SalesManComboFill();
cmbSalesMan.SelectedValue = dtblMaster.Rows[0]["employeeId"].ToString();
}
}
DGVCurrencyComboFill();
cmbCurrency.SelectedValue = dtblMaster.Rows[0]["exchangeRateId"].ToString();
DataTable dtblDetails = new SalesQuotationDetailsSP().SalesQuotationDetailsViewByquotationMasterIdWithRemainingBySO(Convert.ToDecimal(cmbQuotationNo.SelectedValue.ToString()), decSalesOrderMasterId);
int inRowIndex = 0;
foreach (DataRow drowDetails in dtblDetails.Rows)
{
dgvSalesOrder.Rows.Add();
isValueChange = false;
isDoAfterGridFill = false;
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtSalesOrderDetailsId"].Value = drowDetails.ItemArray[0].ToString();
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtSalesQuotationDetailsId"].Value = drowDetails.ItemArray[0].ToString();
String ProductId = drowDetails.ItemArray[2].ToString();
infoProduct = new ProductSP().ProductView(Convert.ToDecimal(ProductId));
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtBarcode"].Value = drowDetails["barcode"].ToString();
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtProductId"].Value = drowDetails["productId"];
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtProductCode"].Value = infoProduct.ProductCode;
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtProductName"].Value = drowDetails["productName"].ToString();
AssignProductDefaultValues(dgvSalesOrder.Rows.Count - 2, drowDetails["productId"].ToString());
TransactionGeneralFillObj.UnitViewAllByProductId(dgvSalesOrder, infoProduct.ProductId.ToString(), dgvSalesOrder.Rows.Count - 2);
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtQty"].Value = drowDetails["qty"].ToString();
UnitComboFill(Convert.ToDecimal(ProductId), dgvSalesOrder.Rows.Count - 2, dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvcmbUnit"].ColumnIndex);
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(drowDetails["unitId"].ToString());
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtRate"].Value = drowDetails["rate"].ToString();
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtAmount"].Value = drowDetails["amount"].ToString();
BatchComboFill(Convert.ToDecimal(drowDetails["productId"].ToString()), dgvSalesOrder.Rows.Count - 2, dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvcmbBatch"].ColumnIndex);
if (Convert.ToDecimal(drowDetails["batchId"].ToString()) != 0)
{
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(drowDetails["batchId"].ToString());
}
else
{
StockPostingSP spStockPosting = new StockPostingSP();
decimal decBatchId = spStockPosting.BatchViewByProductId(Convert.ToDecimal(ProductId));
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvcmbBatch"].Value = decBatchId;
}
string strBarcode = new BatchSP().ProductBatchBarcodeViewByBatchId(Convert.ToDecimal(dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvcmbBatch"].Value.ToString()));
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtBarcode"].Value = strBarcode.ToString();
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtProductCode"].ReadOnly = true;
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtProductName"].ReadOnly = true;
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtBarcode"].ReadOnly = true;
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["inRowIndex"].Value = drowDetails["extra1"].ToString();
UnitConvertionSP SpUnitConvertion = new UnitConvertionSP();
DataTable dtblUnitByProduct = new DataTable();
dtblUnitByProduct = SpUnitConvertion.UnitConversionIdAndConRateViewallByProductId(dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtProductId"].Value.ToString());
foreach (DataRow drUnitByProduct in dtblUnitByProduct.Rows)
{
if (dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvcmbUnit"].Value.ToString() == drUnitByProduct.ItemArray[0].ToString())
{
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtUnitConversionId"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[2].ToString());
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtConversionRate"].Value = Convert.ToDecimal(drUnitByProduct.ItemArray[3].ToString());
}
}
decCurrentConversionRate = Convert.ToDecimal(dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtConversionRate"].Value.ToString());
decCurrentRate = Convert.ToDecimal(dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvtxtRate"].Value.ToString());
if (cmbQuotationNo.Visible == true)
{
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].Cells["dgvcmbUnit"].ReadOnly = true;
}
dgvSalesOrder.Rows[dgvSalesOrder.Rows.Count - 2].HeaderCell.Value = "";
int intIndex = 0;
int.TryParse(drowDetails["extra1"].ToString(), out intIndex);
if (inMaxCount < intIndex)
inMaxCount = intIndex;
inRowIndex++;
isValueChange = true;
}
for (int i = inRowIndex; i < dgvSalesOrder.Rows.Count; ++i)
dgvSalesOrder["inRowIndex", i].Value = GetNextinRowIndex().ToString();
SerialNo();
TotalAmountCalculation();
isDoAfterGridFill = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show("SO38: " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
