/// <summary>
/// Function to fill AgainstOrder combobox
/// </summary>
public void AgainstOrderComboFill()
{
try
{
bool isEveryComboFill = false;
SalesOrderMasterSP spSalesOrder = new SalesOrderMasterSP();
SalesQuotationMasterSP spQuotationMaster = new SalesQuotationMasterSP();
DataTable dtblOrderFill = new DataTable();
if (cmbCashOrParty.SelectedValue.ToString() != null && cmbDeliveryMode.SelectedValue.ToString() != "System.Data.DataRowView")
{
cmbOrderNo.Text = string.Empty;
if (strTypeOfVoucher == "Sales Order")
{
dtblOrderFill = spSalesOrderMaster.GetSalesOrderInvoiceNumberCorrespondingToLedgerId(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), Convert.ToDecimal(cmbDeliveryMode.SelectedValue.ToString()));
DataRow dr = dtblOrderFill.NewRow();
dr[0] = "0";
dr[1] = string.Empty;
dtblOrderFill.Rows.InsertAt(dr, 0);
cmbOrderNo.DataSource = dtblOrderFill;
if (dtblOrderFill.Rows.Count > 0)
{
cmbOrderNo.DisplayMember = "invoiceNo";
cmbOrderNo.ValueMember = "salesOrderMasterId";
cmbOrderNo.SelectedIndex = 0;
}
}
else if (strTypeOfVoucher == "Sales Quotation")
{
dtblOrderFill = spQuotationMaster.GetSalesQuotationNumberCorrespondingToLedger(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), Convert.ToDecimal(cmbDeliveryMode.SelectedValue.ToString()));
DataRow dr = dtblOrderFill.NewRow();
dr[0] = "0";
dr[1] = string.Empty;
dtblOrderFill.Rows.InsertAt(dr, 0);
cmbOrderNo.DataSource = dtblOrderFill;
if (dtblOrderFill.Rows.Count > 0)
{
cmbOrderNo.DisplayMember = "invoiceNo";
cmbOrderNo.ValueMember = "quotationMasterId";
}
}
else
{
GridFill();
}
}
isEveryComboFill = true;
}
catch (Exception ex)
{
MessageBox.Show("DNREP06: " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
DataTable dtblSalesOrderRegister = new DataTable();
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
if (cmbSalesOrderNo.SelectedIndex == 0 || cmbSalesOrderNo.SelectedIndex == -1)
{
strInvoiceNo = "All";
}
else
{
strInvoiceNo = cmbSalesOrderNo.Text;
}
if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1)
{
decLedgerId = -1;
}
else
{
decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
}
if (rbtnAll.Checked == true)
{
strCondition = "All";
}
if (rbtnPendingOrder.Checked == true)
{
strCondition = "Pending";
}
if (rbtnOverdue.Checked == true)
{
strCondition = "Due";
}
if (rbtnCancelled.Checked == true)
{
strCondition = "Cancelled";
}
DateTime FromDate = this.dtpFromDate.Value;
DateTime ToDate = this.dtpToDate.Value;
dtblSalesOrderRegister = spSalesOrderMaster.SalesOrderRegisterSearch(strInvoiceNo, decLedgerId, FromDate, ToDate, strCondition);
dgvSalesOrderRegister.DataSource = dtblSalesOrderRegister;
if (dgvSalesOrderRegister.Columns.Count > 0)
{
dgvSalesOrderRegister.Columns["dgvtxtBillAmount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "SOREG2:" + ex.Message;
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
DataTable dtblSalesOrderRegister = new DataTable();
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
if (cmbSalesOrderNo.SelectedIndex == 0 || cmbSalesOrderNo.SelectedIndex == -1)
{
strInvoiceNo = "All";
}
else
{
strInvoiceNo = cmbSalesOrderNo.Text;
}
if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1)
{
decLedgerId = -1;
}
else
{
decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
}
if (rbtnAll.Checked == true)
{
strCondition = "All";
}
if (rbtnPendingOrder.Checked == true)
{
strCondition = "Pending";
}
if (rbtnOverdue.Checked == true)
{
strCondition = "Due";
}
if (rbtnCancelled.Checked == true)
{
strCondition = "Cancelled";
}
DateTime FromDate = this.dtpFromDate.Value;
DateTime ToDate = this.dtpToDate.Value;
dtblSalesOrderRegister = spSalesOrderMaster.SalesOrderRegisterSearch(strInvoiceNo, decLedgerId, FromDate, ToDate, strCondition);
dgvSalesOrderRegister.DataSource = dtblSalesOrderRegister;
if (dgvSalesOrderRegister.Columns.Count > 0)
{
dgvSalesOrderRegister.Columns["dgvtxtBillAmount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
}
catch (Exception ex)
{
MessageBox.Show("SOREG2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use print
/// </summary>
/// <param name="decSalesOrderMasterId"></param>
public void Print(decimal decSalesOrderMasterId)
{
try
{
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
DataSet dsSalesOrder = spSalesOrderMaster.SalesOrderPrinting(decSalesOrderMasterId, 1);
frmReport frmReport = new frmReport();
frmReport.MdiParent = formMDI.MDIObj;
frmReport.SalesOrderPrinting(dsSalesOrder);
}
catch (Exception ex)
{
MessageBox.Show("SO36:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Against Sales order combofill function
/// </summary>
public void againstOrderComboFill()
{
try
{
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
DeliveryNoteMasterSP spDeliveryNoteMasterSp = new DeliveryNoteMasterSP();
SalesQuotationMasterSP spSalesQuotationMasterSp = new SalesQuotationMasterSP();
DataTable dtbl = new DataTable();
if (cmbCashOrParty.SelectedValue != null)
{
if (cmbSalesMode.Text == "Against SalesOrder")
{
dtbl = spSalesOrderMaster.GetSalesOrderNoIncludePendingCorrespondingtoLedgerforSI(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), decSalesInvoiceIdToEdit, Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()));
DataRow dr = dtbl.NewRow();
dr["invoiceNo"] = "";
dr["salesOrderMasterId"] = 0;
dtbl.Rows.InsertAt(dr, 0);
isFromEditMode = true;
cmbSalesModeOrderNo.DataSource = dtbl;
cmbSalesModeOrderNo.ValueMember = "salesOrderMasterId";
cmbSalesModeOrderNo.DisplayMember = "invoiceNo";
isFromEditMode = false;
}
if (cmbSalesMode.Text == "Against Delivery Note")
{
dtbl = spDeliveryNoteMasterSp.GetDeleveryNoteNoIncludePendingCorrespondingtoLedgerForSI(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), decSalesInvoiceIdToEdit, Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()));
DataRow dr = dtbl.NewRow();
dr["invoiceNo"] = "";
dr["deliveryNoteMasterId"] = 0;
dtbl.Rows.InsertAt(dr, 0);
isFromEditMode = true;
cmbSalesModeOrderNo.DataSource = dtbl;
cmbSalesModeOrderNo.ValueMember = "deliveryNoteMasterId";
cmbSalesModeOrderNo.DisplayMember = "invoiceNo";
isFromEditMode = false;
}
if (cmbSalesMode.Text == "Against Quotation")
{
dtbl = spSalesQuotationMasterSp.GetSalesQuotationIncludePendingCorrespondingtoLedgerForSI(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), decSalesInvoiceIdToEdit, Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()));
DataRow dr = dtbl.NewRow();
dr["invoiceNo"] = "";
dr["quotationMasterId"] = 0;
dtbl.Rows.InsertAt(dr, 0);
isFromEditMode = true;
cmbSalesModeOrderNo.DataSource = dtbl;
cmbSalesModeOrderNo.ValueMember = "quotationMasterId";
cmbSalesModeOrderNo.DisplayMember = "invoiceNo";
isFromEditMode = false;
}
}
}
catch (Exception ex)
{
MessageBox.Show("SI: 13" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// To fill the grid according to the pending Sales order Invoice number
/// </summary>
public void FillOrderDetails()
{
decimal decOrderNo = 0;
try
{
DeliveryNoteMasterInfo infoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
DeliveryNoteMasterSP spDeliveryNoteMaster = new DeliveryNoteMasterSP();
decOrderNo = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
inMaxCount = 0;
string strSalesManId;
decimal DefaultRate = 0;
dgvProduct.Rows.Clear();
DataTable dtblMaster = new SalesOrderMasterSP().SalesOrderMasterViewBySalesOrderMasterId(Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString()));
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 dtblDetails = new SalesOrderDetailsSP().SalesOrderDetailsViewBySalesOrderMasterIdWithRemaining(decOrderNo, 0);
int inRowIndex = 0;
isValueChange = false;
isDoAfterGridFill = false;
infoDeliveryNoteMaster = spDeliveryNoteMaster.DeliveryNoteMasterViewAllByMasterId(decDelivryNoteIdToEdit);
foreach (DataRow drowDetails in dtblDetails.Rows)
{
dgvProduct.Rows.Add();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtBarcode"].Value = drowDetails["barcode"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtProductCode"].Value = drowDetails["productCode"].ToString();
dgvProduct.Rows[dgvProduct.Rows.Count - 2].Cells["dgvtxtProductId"].Value = drowDetails["productId"].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();
string ProductId = drowDetails.ItemArray[2].ToString();
UnitComboFill1(Convert.ToDecimal(ProductId), 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());
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());
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["dgvtxtOrderDetailsId"].Value = drowDetails["salesOrderDetailsId"].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 = 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("DN27 :" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// To fill the Order combo box based on the sales order numbers
/// </summary>
public void AgainstOrderComboFill()
{
try
{
DataTable dtblOrderFill = new DataTable();
if (cmbType.SelectedValue.ToString() != "System.Data.DataRowView")
{
dtblOrderFill = new SalesOrderMasterSP().GetSalesOrderNoIncludePendingCorrespondingtoLedgerforDN(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), Convert.ToDecimal(cmbType.SelectedValue.ToString()), decDelivryNoteIdToEdit);
DataRow dr = dtblOrderFill.NewRow();
dr[0] = "0";
dr[1] = string.Empty;
dtblOrderFill.Rows.InsertAt(dr, 0);
cmbOrderNo.DataSource = dtblOrderFill;
if (dtblOrderFill.Rows.Count > 0)
{
cmbOrderNo.ValueMember = "salesOrderMasterId";
cmbOrderNo.DisplayMember = "invoiceNo";
cmbOrderNo.SelectedIndex = 0;
}
}
}
catch (Exception ex)
{
MessageBox.Show("DN14: " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
if (txtVoucherNo.Text.Trim() == string.Empty)
{
strInvoiceNo = "-1";
}
else
{
strInvoiceNo = txtVoucherNo.Text;
}
if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1)
{
decLedgerId = -1;
}
else
{
decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
}
if (cmbVoucherType.SelectedIndex == 0 || cmbVoucherType.SelectedIndex == -1)
{
decVoucherTypeId = -1;
}
else
{
decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
}
if (cmbSalesMan.SelectedIndex == 0 || cmbSalesMan.SelectedIndex == -1)
{
decEmployeeId = -1;
}
else
{
decEmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
if (txtProductCode.Text.Trim() == string.Empty)
{
strProductCode = string.Empty;
}
else
{
strProductCode = txtProductCode.Text;
}
if (cmbArea.SelectedIndex == 0 || cmbArea.SelectedIndex == -1)
{
decAreaId = -1;
}
else
{
decAreaId = Convert.ToDecimal(cmbArea.SelectedValue.ToString());
}
if (cmbRoute.SelectedIndex == 0 || cmbRoute.SelectedIndex == -1)
{
decRouteId = -1;
}
else
{
decRouteId = Convert.ToDecimal(cmbRoute.SelectedValue.ToString());
}
if (cmbProductGroup.SelectedIndex == 0 || cmbProductGroup.SelectedIndex == -1)
{
decGroupId = -1;
}
else
{
decGroupId = Convert.ToDecimal(cmbProductGroup.SelectedValue.ToString());
}
if (cmbQuotationNo.SelectedIndex == 0)
{
strSalesQuotationNo = "-1";
}
else
{
strSalesQuotationNo = cmbQuotationNo.SelectedValue.ToString();
}
if (cmbStatus.SelectedIndex == 0 || cmbStatus.SelectedIndex == -1)
{
strStatus = "All";
}
else
{
strStatus = cmbStatus.SelectedItem.ToString();
}
DateTime FromDate = this.dtpFromDate.Value;
DateTime ToDate = this.dtpToDate.Value;
dtblSalesOrderReport = spSalesOrderMaster.SalesOrderReportViewAll(strInvoiceNo, decLedgerId, strProductCode, decVoucherTypeId, FromDate, ToDate, strStatus, decEmployeeId, strSalesQuotationNo, decAreaId, decGroupId, decRouteId);
if (dtblSalesOrderReport.Rows.Count > 0)
{
decimal decTotal = 0;
for (int i = 0; i < dtblSalesOrderReport.Rows.Count; i++)
{
if (dtblSalesOrderReport.Rows[i]["totalAmount"].ToString() != null)
{
decTotal = decTotal + Convert.ToDecimal(dtblSalesOrderReport.Rows[i]["totalAmount"].ToString());
}
}
decTotal = Math.Round(decTotal, 2);
txtTotalAmount.Text = decTotal.ToString();
}
else
{
txtTotalAmount.Text = "0.00";
}
dgvSalesOrderReport.DataSource = dtblSalesOrderReport;
if (dgvSalesOrderReport.Columns.Count > 0)
{
dgvSalesOrderReport.Columns["dgvtxtTotalAmount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
}
catch (Exception ex)
{
MessageBox.Show("SORP9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the cancel the salesOrder
/// </summary>
public void SalesOrderCancel()
{
try
{
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
spSalesOrderMaster.SalesOrderCancel(decSalesOrderMasterId);
Messages.InformationMessage("Cancelled successfully");
if (frmSalesOrderRegisterObj != null)
{
this.Close();
frmSalesOrderRegisterObj.GridFill();
}
if (frmSalesOrderReportObj != null)
{
this.Close();
frmSalesOrderReportObj.GridFill();
}
}
catch (Exception ex)
{
MessageBox.Show("SO51:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the invalid entries checking for Save
/// </summary>
public void SaveOrEdit()
{
try
{
SettingsSP spSetting = new SettingsSP();
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
dgvSalesOrder.ClearSelection();
int inRow = dgvSalesOrder.RowCount;
if (txtOrderNo.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Enter voucher number");
txtOrderNo.Focus();
}
else if (spSalesOrderMaster.SalesOrderNumberCheckExistence(txtOrderNo.Text.Trim(), 0, decSalesOrderTypeId) == true && btnSave.Text == "Save")
{
Messages.InformationMessage("Order number already exist");
txtOrderNo.Focus();
}
else if (txtDate.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Select a date in between financial year");
txtDate.Focus();
}
else if (cmbCashOrParty.SelectedValue == null)
{
Messages.InformationMessage("Select Cash/Party");
cmbCashOrParty.Focus();
}
else if (cmbPricingLevel.SelectedValue == null)
{
Messages.InformationMessage("Select Pricing Level");
cmbPricingLevel.Focus();
}
else if (cmbSalesMan.SelectedValue == null)
{
Messages.InformationMessage("Select SalesMan");
cmbSalesMan.Focus();
}
else if (txtDueDate.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Select due date");
txtDueDate.Focus();
}
else if (txtDueDays.Text.Contains("-") && txtDueDays.Text != string.Empty)
{
Messages.InformationMessage("Due date should not be greater than order date");
txtDueDate.Focus();
}
else if (inRow - 1 == 0)
{
Messages.InformationMessage("Can't save sales order without atleast one product with complete details");
}
else if (RemoveIncompleteRowsFromGrid())
{
if (dgvSalesOrder.Rows[0].Cells["dgvtxtProductName"].Value == null && dgvSalesOrder.Rows[0].Cells["dgvtxtProductCode"].Value == null)
{
MessageBox.Show("Can't save sales order without atleast one product with complete details", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgvSalesOrder.ClearSelection();
dgvSalesOrder.Focus();
}
else
{
if (btnSave.Text == "Save")
{
if (dgvSalesOrder.Rows[0].Cells["dgvtxtProductName"].Value == null
|| dgvSalesOrder.Rows[0].Cells["dgvtxtQty"].Value == null
|| dgvSalesOrder.Rows[0].Cells["dgvtxtAmount"].Value == null
|| dgvSalesOrder.Rows[0].Cells["dgvtxtRate"].Value == null)
{
MessageBox.Show("Can't save sales order without atleast one product with complete details", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgvSalesOrder.ClearSelection();
dgvSalesOrder.Focus();
}
else
{
if (PublicVariables.isMessageAdd)
{
if (Messages.SaveMessage())
{
SaveFunction();
}
}
else
{
SaveFunction();
}
}
}
if (btnSave.Text == "Update")
{
if (dgvSalesOrder.Rows[0].Cells["dgvtxtProductName"].Value == null
|| dgvSalesOrder.Rows[0].Cells["dgvtxtQty"].Value == null
|| dgvSalesOrder.Rows[0].Cells["dgvtxtAmount"].Value == null
|| dgvSalesOrder.Rows[0].Cells["dgvtxtRate"].Value == null)
{
MessageBox.Show("Can't edit sales order without atleast one product with complete details", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgvSalesOrder.ClearSelection();
dgvSalesOrder.Focus();
}
else
{
if (PublicVariables.isMessageEdit)
{
if (Messages.UpdateMessage())
{
EditFunction();
}
}
else
{
EditFunction();
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("SO50:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <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>
/// Function to use the voucherno Automatic generation
/// </summary>
public void VoucherNumberGeneration()
{
string strTableName = "SalesOrderMaster";
string strPrefix = string.Empty;
string strSuffix = string.Empty;
string strInvoiceNo = string.Empty;
try
{
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
TransactionsGeneralFill TransactionGeneralFillObj = new TransactionsGeneralFill();
if (isAutomatic)
{
strVoucherNo = "0";
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0"; //strMax;
}
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decSalesOrderTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, strTableName);
if (Convert.ToDecimal(strVoucherNo) != spSalesOrderMaster.SalesOrderVoucherMasterMaxPlusOne(decSalesOrderTypeId))
{
strVoucherNo = spSalesOrderMaster.SalesOrderVoucherMasterMax(decSalesOrderTypeId).ToString();
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decSalesOrderTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, strTableName);
if (spSalesOrderMaster.SalesOrderVoucherMasterMax(decSalesOrderTypeId).ToString() == "0")
{
strVoucherNo = "0";
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decSalesOrderTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, strTableName);
}
}
if (isAutomatic)
{
SuffixPrefixSP spSuffisprefix = new SuffixPrefixSP();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = spSuffisprefix.GetSuffixPrefixDetails(decSalesOrderTypeId, dtpDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
strInvoiceNo = strPrefix + strVoucherNo + strSuffix;
txtOrderNo.Text = strInvoiceNo;
txtOrderNo.ReadOnly = true;
}
else
{
txtOrderNo.ReadOnly = false;
txtOrderNo.Text = string.Empty;
strInvoiceNo = txtOrderNo.Text.Trim();
}
}
}
catch (Exception ex)
{
MessageBox.Show("SO40:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Showing Reminder If Any one have
/// </summary>
public void ShowReminderIfAny()
{
try
{
string Purchasereminder = string.Empty;
string Salesreminder = string.Empty;
string Personalreminder = string.Empty;
string NegativeStkreminder = string.Empty;
string MinStkreminder = string.Empty;
string MaxStkreminder = string.Empty;
string ReordrStkreminder = string.Empty;
string ShortExpiryReminder = string.Empty;
DataTable dtbl = new DataTable();
ReminderSP SpReminder = new ReminderSP();
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmOverduePurchaseOrder", "View"))
{
PurchaseOrderMasterSP SpPurchaseOrderMaster = new PurchaseOrderMasterSP();
dtbl = SpPurchaseOrderMaster.PurchaseOrderOverDueReminder(PublicVariables._dtFromDate, PublicVariables._dtToDate, "Due", PublicVariables._dtCurrentDate, "All");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
{
Purchasereminder = Purchasereminder + "1 Overdue purchase order\n\n";
}
else
{
Purchasereminder = Purchasereminder + dtbl.Rows.Count + " Overdue purchase orders\n\n";
}
}
}
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmOverdueSalesOrder", "View"))
{
SalesOrderMasterSP SpSalesOrderMaster = new SalesOrderMasterSP();
dtbl = SpSalesOrderMaster.SalesOrderOverDueReminder(PublicVariables._dtFromDate, PublicVariables._dtToDate, "Due", PublicVariables._dtCurrentDate, "All");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
{
Salesreminder = Salesreminder + "1 Overdue sales order\n\n";
}
else
{
Salesreminder = Salesreminder + dtbl.Rows.Count + " Overdue sales orders\n\n";
}
}
}
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmPersonalReminder", "Delete") ||
CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmPersonalReminder", "Update") ||
CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmPersonalReminder", "Save"))
{
string FromDate = Convert.ToString(PublicVariables._dtCurrentDate);
string ToDate = Convert.ToString(PublicVariables._dtCurrentDate);
dtbl = SpReminder.ReminderSearch(FromDate, ToDate);
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
{
Personalreminder = Personalreminder + "1 personal reminder \n\n";
}
else
{
Personalreminder = Personalreminder + dtbl.Rows.Count + " Personal reminders\n\n";
}
}
}
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmShortExpiry", "View"))
{
dtbl = SpReminder.ShortExpiryReminder(0, 0, 0, 0, 0, 0, 0, 0);
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
{
ShortExpiryReminder = ShortExpiryReminder + "1 Product batch is going to expire";
}
else
{
ShortExpiryReminder = ShortExpiryReminder + dtbl.Rows.Count + " Product batches going to expire";
}
}
}
//frmStock
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmStock", "View"))
{
dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Negative Stock");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
{
NegativeStkreminder = NegativeStkreminder + "1 Negative stock product \n\n";
}
else
{
NegativeStkreminder = NegativeStkreminder + dtbl.Rows.Count + " Negative stock products\n\n";
}
}
dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Minimum Level");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
{
MinStkreminder = MinStkreminder + "1 Minimum stock product \n\n";
}
else
{
MinStkreminder = MinStkreminder + dtbl.Rows.Count + " Minimum stock products \n\n";
}
}
dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Maximum Level");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
{
MaxStkreminder = MaxStkreminder + "1 Maximum stock product \n\n";
}
else
{
MaxStkreminder = MaxStkreminder + dtbl.Rows.Count + " Maximum stock products \n\n";
}
}
dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Reorder Level");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
{
ReordrStkreminder = ReordrStkreminder + "1 Reorder Level product \n\n";
}
else
{
ReordrStkreminder = ReordrStkreminder + dtbl.Rows.Count + " Reorder Level products \n\n";
}
}
}
if (Salesreminder.Trim() != string.Empty || Purchasereminder.Trim() != string.Empty || Personalreminder.Trim() != string.Empty || NegativeStkreminder.Trim() != string.Empty || MinStkreminder.Trim() != string.Empty || MaxStkreminder.Trim() != string.Empty || ReordrStkreminder.Trim() != string.Empty)
{
frmReminderPopUp frmReminder = new frmReminderPopUp();
frmReminderPopUp isOpen = Application.OpenForms["frmReminderPopUp"] as frmReminderPopUp;
if (isOpen == null)
{
frmReminder.WindowState = FormWindowState.Normal;
frmReminder.MdiParent = formMDI.MDIObj;
frmReminder.BringToFront();
frmReminder.ChangeLabel(Salesreminder, Purchasereminder, Personalreminder, ShortExpiryReminder, NegativeStkreminder, MinStkreminder, MaxStkreminder, ReordrStkreminder);
}
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "CCD 13: " + ex.Message;
}
}
/// <summary>
/// Showing Reminder If Any one have
/// </summary>
public void ShowReminderIfAny()
{
try
{
string Purchasereminder = string.Empty;
string Salesreminder = string.Empty;
string Personalreminder = string.Empty;
string NegativeStkreminder = string.Empty;
string MinStkreminder = string.Empty;
string MaxStkreminder = string.Empty;
string ReordrStkreminder = string.Empty;
string ShortExpiryReminder = string.Empty;
DataTable dtbl = new DataTable();
ReminderSP SpReminder = new ReminderSP();
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmOverduePurchaseOrder", "View"))
{
PurchaseOrderMasterSP SpPurchaseOrderMaster = new PurchaseOrderMasterSP();
dtbl = SpPurchaseOrderMaster.PurchaseOrderOverDueReminder(PublicVariables._dtFromDate, PublicVariables._dtToDate, "Due", PublicVariables._dtCurrentDate, "All");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
Purchasereminder = Purchasereminder + "1 Overdue purchase order\n\n";
else
Purchasereminder = Purchasereminder + dtbl.Rows.Count + " Overdue purchase orders\n\n";
}
}
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmOverdueSalesOrder", "View"))
{
SalesOrderMasterSP SpSalesOrderMaster = new SalesOrderMasterSP();
dtbl = SpSalesOrderMaster.SalesOrderOverDueReminder(PublicVariables._dtFromDate, PublicVariables._dtToDate, "Due", PublicVariables._dtCurrentDate, "All");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
Salesreminder = Salesreminder + "1 Overdue sales order\n\n";
else
Salesreminder = Salesreminder + dtbl.Rows.Count + " Overdue sales orders\n\n";
}
}
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmPersonalReminder", "Delete") ||
CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmPersonalReminder", "Update") ||
CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmPersonalReminder", "Save"))
{
string FromDate = Convert.ToString(PublicVariables._dtCurrentDate);
string ToDate = Convert.ToString(PublicVariables._dtCurrentDate);
dtbl = SpReminder.ReminderSearch(FromDate, ToDate);
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
Personalreminder = Personalreminder + "1 personal reminder \n\n";
else
Personalreminder = Personalreminder + dtbl.Rows.Count + " Personal reminders\n\n";
}
}
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmShortExpiry", "View"))
{
dtbl = SpReminder.ShortExpiryReminder(0, 0, 0, 0, 0, 0, 0, 0);
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
ShortExpiryReminder = ShortExpiryReminder + "1 Product batch is going to expire";
else
ShortExpiryReminder = ShortExpiryReminder + dtbl.Rows.Count + " Product batches going to expire";
}
}
//frmStock
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmStock", "View"))
{
dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Negative Stock");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
NegativeStkreminder = NegativeStkreminder + "1 Negative stock product \n\n";
else
NegativeStkreminder = NegativeStkreminder + dtbl.Rows.Count + " Negative stock products\n\n";
}
dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Minimum Level");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
MinStkreminder = MinStkreminder + "1 Minimum stock product \n\n";
else
MinStkreminder = MinStkreminder + dtbl.Rows.Count + " Minimum stock products \n\n";
}
dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Maximum Level");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
MaxStkreminder = MaxStkreminder + "1 Maximum stock product \n\n";
else
MaxStkreminder = MaxStkreminder + dtbl.Rows.Count + " Maximum stock products \n\n";
}
dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Reorder Level");
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows.Count == 1)
ReordrStkreminder = ReordrStkreminder + "1 Reorder Level product \n\n";
else
ReordrStkreminder = ReordrStkreminder + dtbl.Rows.Count + " Reorder Level products \n\n";
}
}
if (Salesreminder.Trim() != string.Empty || Purchasereminder.Trim() != string.Empty || Personalreminder.Trim() != string.Empty || NegativeStkreminder.Trim() != string.Empty || MinStkreminder.Trim() != string.Empty || MaxStkreminder.Trim() != string.Empty || ReordrStkreminder.Trim() != string.Empty)
{
frmReminderPopUp frmReminder = new frmReminderPopUp();
frmReminderPopUp isOpen = Application.OpenForms["frmReminderPopUp"] as frmReminderPopUp;
if (isOpen == null)
{
frmReminder.WindowState = FormWindowState.Normal;
frmReminder.MdiParent = formMDI.MDIObj;
frmReminder.BringToFront();
frmReminder.ChangeLabel(Salesreminder, Purchasereminder, Personalreminder, ShortExpiryReminder, NegativeStkreminder, MinStkreminder, MaxStkreminder, ReordrStkreminder);
}
}
}
catch (Exception ex)
{
MessageBox.Show("CCD : 13 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// function to use Check Cancel Status
/// </summary>
/// <param name="decId"></param>
/// <returns></returns>
public bool CheckCancelStatus(decimal decId)
{
bool isCancelled = false;
try
{
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
isCancelled = spSalesOrderMaster.SalesOrderCancelCheckStatus(decId);
}
catch (Exception ex)
{
MessageBox.Show("SO52:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return isCancelled;
}
/// <summary>
/// Function to delete
/// </summary>
public void Delete()
{
try
{
SalesOrderDetailsSP spSalesOrderDetails = new SalesOrderDetailsSP();
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
decimal decResult1 = 0;
for (int inI = 0; inI < dgvSalesOrder.Rows.Count - 1; inI++)
{
if (Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesOrderDetailsId"].Value) != 0)
{
decResult1 = spSalesOrderDetails.SalesOrderDetailsDeletee(Convert.ToDecimal(dgvSalesOrder.Rows[inI].Cells["dgvtxtSalesOrderDetailsId"].Value));
}
}
decimal decResult2 = spSalesOrderMaster.SalesOrderMasterDelete(decSalesOrderMasterId);
if (decResult1 > 0 && decResult2 > 0)
{
Messages.DeletedMessage();
if (frmSalesOrderRegisterObj != null)
{
this.Close();
frmSalesOrderRegisterObj.Enabled = true;
}
if (frmSalesOrderReportObj != null)
{
this.Close();
frmSalesOrderReportObj.Enabled = true;
}
if (objVoucherSearch != null)
{
this.Close();
objVoucherSearch.Enabled = true;
}
if (frmDayBookObj != null)
{
this.Close();
}
}
else
{
Messages.ReferenceExistsMessage();
}
}
catch (Exception ex)
{
MessageBox.Show("SO53:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the VoucherTypeCombobox
/// </summary>
public void VoucherTypeComboFill()
{
try
{
string typeOfVoucher = string.Empty;
typeOfVoucher = "Sales Quotation";
DataTable dtbl = new DataTable();
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
dtbl = spSalesOrderMaster.VoucherTypesBasedOnTypeOfVouchers(typeOfVoucher);
DataRow dr = dtbl.NewRow();
dr["voucherTypeId"] = 0;
dr["voucherTypeName"] = "NA";
dtbl.Rows.InsertAt(dr, 0);
cmbType.DataSource = dtbl;
cmbType.ValueMember = "voucherTypeId";
cmbType.DisplayMember = "voucherTypeName";
}
catch (Exception ex)
{
MessageBox.Show("SO7" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save Function
/// </summary>
public void SaveFunction()
{
try
{
DeliveryNoteMasterInfo infoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
DeliveryNoteDetailsInfo infoDeliveryNoteDetails = new DeliveryNoteDetailsInfo();
StockPostingInfo infoStockPosting = new StockPostingInfo();
StockPostingSP spStockPosting = new StockPostingSP();
DeliveryNoteMasterSP spDeliveryNoteMaster = new DeliveryNoteMasterSP();
DeliveryNoteDetailsSP spDeliveryNoteDetails = new DeliveryNoteDetailsSP();
SalesOrderMasterInfo infoSalesOrderMaster = new SalesOrderMasterInfo();
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
SalesQuotationMasterInfo infoSalesQuotationMaster = new SalesQuotationMasterInfo();
SalesQuotationMasterSP spSalesQuotationMaster = new SalesQuotationMasterSP();
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 = spSalesOrderMaster.SalesOrderMasterView(infoDeliveryNoteMaster.OrderMasterId);
}
else if (cmbDeliveryMode.Text == "Against Quotation")
{
infoDeliveryNoteMaster.QuotationMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
infoSalesQuotationMaster = spSalesQuotationMaster.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(spDeliveryNoteMaster.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;
spDeliveryNoteDetails.DeliveryNoteDetailsAdd(infoDeliveryNoteDetails);
}
else
{
infoDeliveryNoteDetails.DeliveryNoteMasterId = decDelivryNoteIdToEdit;
spDeliveryNoteDetails.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;
spStockPosting.StockPostingAdd(infoStockPosting);
}
Messages.SavedMessage();
if (cbxPrint.Checked)
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decDeliveryNoteMasterId);
}
else
{
Print(decDeliveryNoteMasterId);
}
}
}
if (btnSave.Text == "Update")
{
SettingsSP spSettings = new SettingsSP();
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 = spSalesOrderMaster.SalesOrderMasterView(infoDeliveryNoteMaster.OrderMasterId);
}
else if (cmbDeliveryMode.Text == "Against Quotation")
{
infoDeliveryNoteMaster.QuotationMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
infoSalesQuotationMaster = spSalesQuotationMaster.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;
spDeliveryNoteMaster.DeliveryNoteMasterEdit(infoDeliveryNoteMaster);
RemoveDeliveryNoteDetails();
infoDeliveryNoteMaster.VoucherTypeId = decDeliveryNoteVoucherTypeId;
spDeliveryNoteMaster.StockPostDeletingForDeliveryNote(decDeliveryNoteVoucherTypeId, strVoucherNo, txtDeliveryNoteNo.Text);
DeliveryNoteDetails();
Messages.UpdatedMessage();
if (frmDeliveryNoteRegisterObj != null)
{
if (cbxPrint.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decDelivryNoteIdToEdit);
}
else
{
Print(decDelivryNoteIdToEdit);
}
}
frmDeliveryNoteRegisterObj.GridFill();
}
if (frmDeliveryNoteReportObj != null)
{
if (cbxPrint.Checked)
{
if (spSettings.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>
/// doing the unit conversion in cell enter
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvSalesOrder_CellEnter(object sender, DataGridViewCellEventArgs e)
{
SalesOrderMasterInfo infoSalesOrderMaster = new SalesOrderMasterInfo();
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
// decimal decQty =0;
try
{
if (dgvSalesOrder.Rows[e.RowIndex].Cells[e.ColumnIndex] is DataGridViewComboBoxCell)
{
dgvSalesOrder.EditMode = DataGridViewEditMode.EditOnEnter;
}
else
{
dgvSalesOrder.EditMode = DataGridViewEditMode.EditOnKeystrokeOrF2;
}
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
if (dgvSalesOrder.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value != null && dgvSalesOrder.Rows[e.RowIndex].Cells["dgvtxtProductId"].Value.ToString() != string.Empty)
{
if (dgvSalesOrder.Columns[e.ColumnIndex].Name == "dgvcmbUnit")
{
if (dgvSalesOrder.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value != null && dgvSalesOrder.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString() != string.Empty)
{
if (dgvSalesOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value != null && dgvSalesOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value.ToString() != string.Empty)
{
decCurrentConversionRate = Convert.ToDecimal(dgvSalesOrder.Rows[e.RowIndex].Cells["dgvtxtConversionRate"].Value.ToString());
decCurrentRate = Convert.ToDecimal(dgvSalesOrder.Rows[e.RowIndex].Cells["dgvtxtRate"].Value.ToString());
}
}
}
}
if (dgvSalesOrder.CurrentRow.Cells["dgvtxtProductId"].Value != null)
{
if (dgvSalesOrder.CurrentRow.Cells["dgvtxtProductId"].Value.ToString() != string.Empty)
{
BatchSP spBatch = new BatchSP();
decimal decBatchId = Convert.ToDecimal(dgvSalesOrder.CurrentRow.Cells["dgvcmbBatch"].Value);
string strBarcode = spBatch.ProductBatchBarcodeViewByBatchId(decBatchId);
dgvSalesOrder.Rows[e.RowIndex].Cells["dgvtxtBarcode"].Value = strBarcode;
}
}
}
CheckInvalidEntries(e);
}
catch (Exception ex)
{
MessageBox.Show("SO75" + 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();
VoucherTypeSP spVoucherType = new VoucherTypeSP();
DeliveryNoteMasterSP spDeliveryNoteMaster = new DeliveryNoteMasterSP();
DeliveryNoteDetailsSP spDeliveryNoteDetails = new DeliveryNoteDetailsSP();
SalesOrderMasterInfo infoSalesOrderMaster = new SalesOrderMasterInfo();
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
SalesQuotationMasterInfo infoSalesQuotationMaster = new SalesQuotationMasterInfo();
SalesQuotationMasterSP spSalesQuotationMaster = new SalesQuotationMasterSP();
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 = spDeliveryNoteMaster.DeliveryNoteMasterViewAllByMasterId(decDelivryNoteIdToEdit);
txtDeliveryNoteNo.Text = infoDeliveryNoteMaster.InvoiceNo;
strVoucherNo = infoDeliveryNoteMaster.VoucherNo.ToString();
decDeliveryNoteSuffixPrefixId = Convert.ToDecimal(infoDeliveryNoteMaster.SuffixPrefixId);
decDeliveryNoteVoucherTypeId = Convert.ToDecimal(infoDeliveryNoteMaster.VoucherTypeId);
isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(decDeliveryNoteVoucherTypeId);
decDeliveryNoteTypeId = decDeliveryNoteVoucherTypeId;
cmbCashOrParty.SelectedValue = infoDeliveryNoteMaster.LedgerId;
txtDate.Text = infoDeliveryNoteMaster.Date.ToString("dd-MMM-yyyy");
cmbPricingLevel.SelectedValue = infoDeliveryNoteMaster.PricinglevelId;
infoVoucherType = spVoucherType.VoucherTypeView(decDeliveryNoteVoucherTypeId);
this.Text = infoVoucherType.VoucherTypeName;
if (infoDeliveryNoteMaster.OrderMasterId != 0)
{
cmbDeliveryMode.Text = "Against Order";
infoSalesOrderMaster = spSalesOrderMaster.SalesOrderMasterView(infoDeliveryNoteMaster.OrderMasterId);
cmbType.SelectedValue = infoSalesOrderMaster.VoucherTypeId;
AgainstOrderComboFill();
cmbOrderNo.SelectedValue = infoDeliveryNoteMaster.OrderMasterId;
}
else if (infoDeliveryNoteMaster.QuotationMasterId != 0)
{
cmbDeliveryMode.Text = "Against Quotation";
infoSalesQuotationMaster = spSalesQuotationMaster.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");
DataTable dtblDetails = spDeliveryNoteDetails.DeliveryNoteDetailsViewByDeliveryNoteMasterId(decDelivryNoteIdToEdit);
foreach (DataRow drowDetails in dtblDetails.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 (spDeliveryNoteMaster.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>
/// Function to use CashOrParty Combofill
/// </summary>
public void DueDays()
{
try
{
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
txtDueDays.Text = spSalesOrderMaster.DueDays(dtpDate.Value, dtpDueDate.Value).ToString();
}
catch (Exception ex)
{
MessageBox.Show("SO20:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Grid fill function Againest SalseOrderDetails
/// </summary>
public void gridFillAgainestSalseOrderDetails()
{
SalesOrderMasterSP SPSalesOrderMaster = new SalesOrderMasterSP();
SalesOrderDetailsSP spSalesOrderDetails = new SalesOrderDetailsSP();
ProductInfo infoproduct = new ProductInfo();
SalesMasterSP spSalesMaster = new SalesMasterSP();
BrandInfo InfoBrand = new BrandInfo();
TaxInfo infoTax = new TaxInfo();
TaxSP SPTax = new TaxSP();
try
{
if (cmbSalesModeOrderNo.SelectedIndex > 0)
{
inMaxCount = 0;
isValueChange = false;
for (int i = 0; i < dgvSalesInvoice.RowCount - 1; i++)
{
if (dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceSalesDetailsId"].Value != null && dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceSalesDetailsId"].Value.ToString() != string.Empty)
{
lstArrOfRemove.Add(dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceSalesDetailsId"].Value.ToString());
}
}
dgvSalesInvoice.Rows.Clear();
isValueChange = true;
DataTable dtblMaster = SPSalesOrderMaster.SalesInvoiceGridfillAgainestSalesOrder(Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString()));
cmbPricingLevel.SelectedValue = Convert.ToDecimal(dtblMaster.Rows[0]["pricingLevelId"].ToString());
cmbCurrency.SelectedValue = Convert.ToDecimal(dtblMaster.Rows[0]["exchangeRateId"].ToString());
if (dtblMaster.Rows[0]["employeeId"].ToString() != string.Empty)
{
strSalesManId = dtblMaster.Rows[0]["employeeId"].ToString();
cmbSalesMan.SelectedValue = strSalesManId;
if (cmbSalesMan.SelectedValue == null)
{
salesManComboFill();
cmbSalesMan.SelectedValue = dtblMaster.Rows[0]["employeeId"].ToString();
}
}
cmbPricingLevel.Enabled = false;
btnNewPricingLevel.Enabled = false;
cmbCurrency.Enabled = false;
DataTable dtblDetails = spSalesOrderDetails.SalesInvoiceGridfillAgainestSalesOrderUsingSalesDetails(Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString()), Convert.ToDecimal(decSalesInvoiceIdToEdit), DecSalesInvoiceVoucherTypeId);
int inRowIndex = 0;
foreach (DataRow drowDetails in dtblDetails.Rows)
{
dgvSalesInvoice.Rows.Add();
isValueChange = false;
IsSetGridValueChange = false;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSISalesOrderDetailsId"].Value = drowDetails["salesOrderDetailsId"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceProductCode"].Value = drowDetails["productCode"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceBarcode"].Value = drowDetails["barcode"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvcmbSalesInvoiceBatch"].Value = Convert.ToDecimal(drowDetails["batchId"].ToString());
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceVoucherNo"].Value = drowDetails["voucherNo"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceInvoiceNo"].Value = drowDetails["invoiceNo"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceVoucherTypeId"].Value = drowDetails["voucherTypeId"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceDiscountPercentage"].Value = "0";
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceInRowIndex"].Value = drowDetails["salesOrderDetailsId"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceProductId"].Value = drowDetails.ItemArray[2].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceUnitConversionId"].Value = drowDetails["unitConversionId"].ToString();
infoproduct = spSalesMaster.ProductViewByProductIdforSalesInvoice(Convert.ToDecimal(dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceProductId"].Value).ToString());
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceProductName"].Value = infoproduct.ProductName;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceMrp"].Value = infoproduct.Mrp;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoicePurchaseRate"].Value = infoproduct.PurchaseRate;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceSalesRate"].Value = infoproduct.SalesRate;
InfoBrand = new BrandSP().BrandView(infoproduct.BrandId);
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceBrand"].Value = InfoBrand.BrandName;
infoTax = SPTax.TaxViewByProductId(Convert.ToDecimal(dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceProductId"].Value).ToString());
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvcmbSalesInvoiceTaxName"].Value = infoTax.TaxId;
isValueChange = false;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoicembUnitName"].Value = Convert.ToDecimal(drowDetails["unitId"].ToString());
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoicembUnitName"].ReadOnly = true;
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceQty"].Value = drowDetails["Qty"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceRate"].Value = drowDetails["rate"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceAmount"].Value = drowDetails["amount"].ToString();
dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceConversionRate"].Value = drowDetails["conversionRate"].ToString();
isFromAgainest = true;
gridColumnMakeEnables();
int intIndex = 0;
intIndex = Convert.ToInt32(drowDetails["salesOrderDetailsId"].ToString());
if (inMaxCount < intIndex)
inMaxCount = intIndex;
inRowIndex++;
isValueChange = true;
isFromAgainest = false;
GrossValueCalculation(dgvSalesInvoice.Rows.Count - 2);
discountCalculation(dgvSalesInvoice.Rows.Count - 2);
taxAndGridTotalAmountCalculation(dgvSalesInvoice.Rows.Count - 2);
}
IsSetGridValueChange = true;
for (int i = inRowIndex; i < dgvSalesInvoice.Rows.Count; ++i)
dgvSalesInvoice["dgvtxtSalesInvoiceInRowIndex", i].Value = GetNextinRowIndex().ToString();
SerialNoforSalesInvoice();
strVoucherNoTostockPost = dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceVoucherNo"].Value.ToString();
strInvoiceNoTostockPost = dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceInvoiceNo"].Value.ToString();
decVouchertypeIdTostockPost = Convert.ToDecimal(dgvSalesInvoice.Rows[dgvSalesInvoice.Rows.Count - 2].Cells["dgvtxtSalesInvoiceVoucherTypeId"].Value);
}
else
{
SiGridTotalAmountCalculation();
ClearGridAgainest();
}
SiGridTotalAmountCalculation();
}
catch (Exception ex)
{
MessageBox.Show("SI: 51" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use to fill details to updation when comes register or report
/// </summary>
public void FillRegisterOrReport()
{
try
{
SalesQuotationMasterInfo infoSalesQuotationMaster = new SalesQuotationMasterInfo();
SalesOrderMasterInfo infoSalesOrderMaster = new SalesOrderMasterInfo();
SalesOrderDetailsSP spSalesOrderDetails = new SalesOrderDetailsSP();
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
isValueChange = false;
btnSave.Text = "Update";
btnDelete.Enabled = true;
txtOrderNo.ReadOnly = true;
infoSalesOrderMaster = spSalesOrderMaster.SalesOrderMasterView(decSalesOrderMasterId);
txtOrderNo.Text = infoSalesOrderMaster.InvoiceNo;
strVoucherNo = infoSalesOrderMaster.VoucherNo.ToString();
decSalesSuffixPrefixId = Convert.ToDecimal(infoSalesOrderMaster.SuffixPrefixId);
decSalesVoucherId = Convert.ToDecimal(infoSalesOrderMaster.VoucherTypeId);
isAutomatic = new VoucherTypeSP().CheckMethodOfVoucherNumbering(decSalesVoucherId);
decSalesOrderTypeId = decSalesVoucherId;
txtDate.Text = infoSalesOrderMaster.Date.ToString("dd-MMM-yyyy");
cmbCashOrParty.SelectedValue = infoSalesOrderMaster.LedgerId;
decSalesOrderVoucherTypeId = infoSalesOrderMaster.VoucherTypeId;
VoucherTypeInfo infoVoucherType = new VoucherTypeInfo();
VoucherTypeSP spVoucherType = new VoucherTypeSP();
infoVoucherType = spVoucherType.VoucherTypeView(decSalesOrderVoucherTypeId);
string strVoucherTypeName = infoVoucherType.VoucherTypeName;
this.Text = strVoucherTypeName;
if (infoSalesOrderMaster.QuotationMasterId == 0)
{
cmbType.SelectedItem = "NA";
}
else if (infoSalesOrderMaster.QuotationMasterId != 0)
{
infoSalesQuotationMaster = new SalesQuotationMasterSP().SalesQuotationMasterView(infoSalesOrderMaster.QuotationMasterId);
cmbType.SelectedValue = infoSalesQuotationMaster.VoucherTypeId;
AgainstQuotationComboFill();
cmbQuotationNo.SelectedValue = infoSalesOrderMaster.QuotationMasterId;
}
txtDueDate.Text = infoSalesOrderMaster.DueDate.ToString("dd-MMM-yyyy");
TimeSpan objTs = Convert.ToDateTime(txtDueDate.Text).Subtract(Convert.ToDateTime(txtDate.Text));
txtDueDays.Text = objTs.Days.ToString();
txtNarration.Text = infoSalesOrderMaster.Narration;
cmbCurrency.SelectedValue = infoSalesOrderMaster.ExchangeRateId;
cmbPricingLevel.SelectedValue = infoSalesOrderMaster.PricinglevelId;
SalesManComboFill();
cmbSalesMan.SelectedValue = infoSalesOrderMaster.EmployeeId;
txtTotalAmount.Text = infoSalesOrderMaster.TotalAmount.ToString();
DataTable dtbl = new DataTable();
dtbl = spSalesOrderDetails.SalesOrderDetailsViewByMasterId(decSalesOrderMasterId);
if (CheckCancelStatus(decSalesOrderMasterId))
{
isCheck = true;
cbxCancelled.Checked = true;
cbxCancelled.Enabled = false;
btnSave.Enabled = false;
isCheck = false;
}
else
{
isCheck = true;
cbxCancelled.Enabled = true;
cbxCancelled.Checked = false;
isCheck = false;
}
if (isAutomatic)
{
txtOrderNo.ReadOnly = true;
txtDate.Focus();
}
else
{
txtOrderNo.ReadOnly = false;
txtOrderNo.Focus();
}
for (int i = 0; i < dtbl.Rows.Count; i++)
{
isAmountcalc = false;
isValueChange = false;
dgvSalesOrder.Rows.Add();
dgvSalesOrder.Rows[i].HeaderCell.Value = string.Empty;
dgvSalesOrder.Rows[i].Cells["dgvtxtSalesOrderDetailsId"].Value = Convert.ToDecimal(dtbl.Rows[i]["salesOrderDetailsId"].ToString());
dgvSalesOrder.Rows[i].Cells["dgvtxtProductId"].Value = dtbl.Rows[i]["productId"].ToString();
dgvSalesOrder.Rows[i].Cells["dgvtxtProductCode"].Value = dtbl.Rows[i]["productCode"].ToString();
dgvSalesOrder.Rows[i].Cells["dgvtxtProductName"].Value = dtbl.Rows[i]["productName"].ToString();
dgvSalesOrder.Rows[i].Cells["dgvtxtQty"].Value = dtbl.Rows[i]["qty"].ToString();
UnitComboFill(Convert.ToDecimal(dgvSalesOrder.Rows[i].Cells["dgvtxtProductId"].Value.ToString()), i, dgvSalesOrder.Rows[i].Cells["dgvcmbUnit"].ColumnIndex);
dgvSalesOrder.Rows[i].Cells["dgvcmbUnit"].Value = Convert.ToDecimal(dtbl.Rows[i]["unitId"].ToString());
dgvSalesOrder.Rows[i].Cells["dgvtxtRate"].Value = dtbl.Rows[i]["rate"].ToString();
BatchComboFill(Convert.ToDecimal(dgvSalesOrder.Rows[i].Cells["dgvtxtProductId"].Value.ToString()), i, dgvSalesOrder.Rows[i].Cells["dgvcmbBatch"].ColumnIndex);
dgvSalesOrder.Rows[i].Cells["dgvcmbBatch"].Value = Convert.ToDecimal(dtbl.Rows[i]["batchId"].ToString());
dgvSalesOrder.Rows[i].Cells["dgvtxtBarcode"].Value = dtbl.Rows[i]["barcode"].ToString();
dgvSalesOrder.Rows[i].Cells["dgvtxtAmount"].Value = dtbl.Rows[i]["amount"].ToString();
dgvSalesOrder.Rows[i].Cells["dgvtxtUnitConversionId"].Value = dtbl.Rows[i]["unitConversionId"].ToString();
dgvSalesOrder.Rows[i].Cells["dgvtxtConversionRate"].Value = dtbl.Rows[i]["conversionRate"].ToString();
dgvSalesOrder.Rows[i].Cells["dgvtxtSalesQuotationDetailsId"].Value = dtbl.Rows[i]["quotationDetailsId"].ToString();
if (Convert.ToDecimal(dtbl.Rows[i]["quotationDetailsId"].ToString()) != 0)
{
dgvSalesOrder.Rows[i].Cells["dgvtxtProductCode"].ReadOnly = true;
dgvSalesOrder.Rows[i].Cells["dgvtxtProductName"].ReadOnly = true;
dgvSalesOrder.Rows[i].Cells["dgvtxtBarcode"].ReadOnly = true;
}
if (cmbQuotationNo.Visible == true)
{
dgvSalesOrder.Rows[i].Cells["dgvcmbUnit"].ReadOnly = true;
}
}
isAmountcalc = true;
isEditFill = false;
isValueChange = true;
isDoAfterGridFill = true;
}
catch (Exception ex)
{
MessageBox.Show("SO30:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP();
if (txtVoucherNo.Text.Trim() == string.Empty)
{
strInvoiceNo = "-1";
}
else
{
strInvoiceNo = txtVoucherNo.Text;
}
if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1)
{
decLedgerId = -1;
}
else
{
decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
}
if (cmbVoucherType.SelectedIndex == 0 || cmbVoucherType.SelectedIndex == -1)
{
decVoucherTypeId = -1;
}
else
{
decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
}
if (cmbSalesMan.SelectedIndex == 0 || cmbSalesMan.SelectedIndex == -1)
{
decEmployeeId = -1;
}
else
{
decEmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
if (txtProductCode.Text.Trim() == string.Empty)
{
strProductCode = string.Empty;
}
else
{
strProductCode = txtProductCode.Text;
}
if (cmbArea.SelectedIndex == 0 || cmbArea.SelectedIndex == -1)
{
decAreaId = -1;
}
else
{
decAreaId = Convert.ToDecimal(cmbArea.SelectedValue.ToString());
}
if (cmbRoute.SelectedIndex == 0 || cmbRoute.SelectedIndex == -1)
{
decRouteId = -1;
}
else
{
decRouteId = Convert.ToDecimal(cmbRoute.SelectedValue.ToString());
}
if (cmbProductGroup.SelectedIndex == 0 || cmbProductGroup.SelectedIndex == -1)
{
decGroupId = -1;
}
else
{
decGroupId = Convert.ToDecimal(cmbProductGroup.SelectedValue.ToString());
}
if (cmbQuotationNo.SelectedIndex == 0)
{
strSalesQuotationNo = "-1";
}
else
{
strSalesQuotationNo = cmbQuotationNo.SelectedValue.ToString();
}
if (cmbStatus.SelectedIndex == 0 || cmbStatus.SelectedIndex == -1)
{
strStatus = "All";
}
else
{
strStatus = cmbStatus.SelectedItem.ToString();
}
DateTime FromDate = this.dtpFromDate.Value;
DateTime ToDate = this.dtpToDate.Value;
dtblSalesOrderReport = spSalesOrderMaster.SalesOrderReportViewAll(strInvoiceNo, decLedgerId, strProductCode, decVoucherTypeId, FromDate, ToDate, strStatus, decEmployeeId, strSalesQuotationNo, decAreaId, decGroupId, decRouteId);
if (dtblSalesOrderReport.Rows.Count > 0)
{
decimal decTotal = 0;
for (int i = 0; i < dtblSalesOrderReport.Rows.Count; i++)
{
if (dtblSalesOrderReport.Rows[i]["totalAmount"].ToString() != null)
{
decTotal = decTotal + Convert.ToDecimal(dtblSalesOrderReport.Rows[i]["totalAmount"].ToString());
}
}
decTotal = Math.Round(decTotal, 2);
txtTotalAmount.Text = decTotal.ToString();
}
else
{
txtTotalAmount.Text = "0.00";
}
dgvSalesOrderReport.DataSource = dtblSalesOrderReport;
if (dgvSalesOrderReport.Columns.Count > 0)
{
dgvSalesOrderReport.Columns["dgvtxtTotalAmount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "SORP9:" + ex.Message;
}
}
/// <summary>
/// Function to fill AgainstOrder combobox
/// </summary>
public void AgainstOrderComboFill()
{
try
{
bool isEveryComboFill = false;
SalesOrderMasterSP spSalesOrder = new SalesOrderMasterSP();
SalesQuotationMasterSP spQuotationMaster = new SalesQuotationMasterSP();
DataTable dtblOrderFill = new DataTable();
if (cmbCashOrParty.SelectedValue.ToString() != null && cmbDeliveryMode.SelectedValue.ToString() != "System.Data.DataRowView")
{
cmbOrderNo.Text = string.Empty;
if (strTypeOfVoucher == "Sales Order")
{
dtblOrderFill = spSalesOrderMaster.GetSalesOrderInvoiceNumberCorrespondingToLedgerId(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), Convert.ToDecimal(cmbDeliveryMode.SelectedValue.ToString()));
DataRow dr = dtblOrderFill.NewRow();
dr[0] = "0";
dr[1] = string.Empty;
dtblOrderFill.Rows.InsertAt(dr, 0);
cmbOrderNo.DataSource = dtblOrderFill;
if (dtblOrderFill.Rows.Count > 0)
{
cmbOrderNo.DisplayMember = "invoiceNo";
cmbOrderNo.ValueMember = "salesOrderMasterId";
cmbOrderNo.SelectedIndex = 0;
}
}
else if (strTypeOfVoucher == "Sales Quotation")
{
dtblOrderFill = spQuotationMaster.GetSalesQuotationNumberCorrespondingToLedger(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), Convert.ToDecimal(cmbDeliveryMode.SelectedValue.ToString()));
DataRow dr = dtblOrderFill.NewRow();
dr[0] = "0";
dr[1] = string.Empty;
dtblOrderFill.Rows.InsertAt(dr, 0);
cmbOrderNo.DataSource = dtblOrderFill;
if (dtblOrderFill.Rows.Count > 0)
{
cmbOrderNo.DisplayMember = "invoiceNo";
cmbOrderNo.ValueMember = "quotationMasterId";
}
}
else
{
GridFill();
}
}
isEveryComboFill = true;
}
catch (Exception ex)
{
MessageBox.Show("DNREP06: " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
