/// <summary>
/// Function to set the calculation method by checking the settings
/// </summary>
public void CalculationMethod()
{
try
{
SettingsInfo InfoSettings = new SettingsInfo();
SettingsSP SpSettings = new SettingsSP();
//--------------- Selection Of Calculation Method According To Settings ------------------//
if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
calculationMethod = "FIFO";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
calculationMethod = "Average Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
calculationMethod = "High Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
calculationMethod = "Low Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
calculationMethod = "Last Purchase Rate";
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "AGR6:" + ex.Message;
}
}
/// <summary>
/// Function to set the calculation method by checking the settings
/// </summary>
public void CalculationMethod()
{
try
{
SettingsInfo InfoSettings = new SettingsInfo();
SettingsSP SpSettings = new SettingsSP();
//--------------- Selection Of Calculation Method According To Settings ------------------//
if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
calculationMethod = "FIFO";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
calculationMethod = "Average Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
calculationMethod = "High Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
calculationMethod = "Low Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
calculationMethod = "Last Purchase Rate";
}
}
catch (Exception ex)
{
MessageBox.Show("AGR:6" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to print StockJournal in curresponding Crystal report
/// </summary>
/// <param name="dsStockJournal"></param>
internal void StockJournalPrinting(DataSet dsStockJournal)
{
try
{
crptStockJournal crptStockJournalObj = new crptStockJournal();
foreach (DataTable dtbl in dsStockJournal.Tables)
{
if (dtbl.TableName == "Table")
{
crptStockJournalObj.Database.Tables["dtblCompany"].SetDataSource(dtbl);
}
else if (dtbl.TableName == "Table1")
{
crptStockJournalObj.Database.Tables["dtblStockJournalMaster"].SetDataSource(dtbl);
}
else if (dtbl.TableName == "Table2")
{
crptStockJournalObj.Database.Tables["dtblStockJournalDetailsConsumption"].SetDataSource(dtbl);
}
else if (dtbl.TableName == "Table3")
{
crptStockJournalObj.Database.Tables["dtblStockJournalDetailsProduction"].SetDataSource(dtbl);
}
}
this.crptViewer.ReportSource = crptStockJournalObj;
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("DirectPrint") == "No")
{
base.Show();
this.BringToFront();
}
else
{
crptStockJournalObj.PrintToPrinter(1, false, 0, 0);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Function to return amount in words
/// </summary>
/// <param name="decAmount"></param>
/// <param name="decCurrId"></param>
/// <returns></returns>
public string AmountWords(decimal decAmount, decimal decCurrId)
{
string AountInWords = string.Empty; // To return the amount in words
CurrencyInfo currencyInfo = new CurrencySP().CurrencyView(decCurrId);
decAmount = Math.Round(decAmount, currencyInfo.NoOfDecimalPlaces); //Rounding according to decimal places of currency
string strAmount = decAmount.ToString(); // Just keeping the whole amount as string for performing split operation on it
string strAmountinwordsOfIntiger = string.Empty; // To hold amount in words of intiger
string strAmountInWordsOfDecimal = string.Empty; // To hold amoutn in words of decimal part
string[] strPartsArray = strAmount.Split('.'); // Splitting with "." to get intiger part and decimal part seperately
string strDecimaPart = string.Empty; // To hold decimal part
if (strPartsArray.Length > 1)
if (strPartsArray[1] != null)
strDecimaPart = strPartsArray[1]; // Holding decimal portion if any
if (strPartsArray[0] != null)
strAmount = strPartsArray[0]; // Holding intiger part of amount
else
strAmount = string.Empty; ;
if (strAmount.Trim() != string.Empty && decimal.Parse(strAmount) != 0)
strAmountinwordsOfIntiger = NumberToText(long.Parse(strAmount));
if (strDecimaPart.Trim() != string.Empty && decimal.Parse(strDecimaPart) != 0)
strAmountInWordsOfDecimal = NumberToText(long.Parse(strDecimaPart));
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("ShowCurrencySymbol") != "Yes")
{
// Showing currency as suffix
if (strAmountinwordsOfIntiger != string.Empty)
AountInWords = strAmountinwordsOfIntiger + " " + currencyInfo.CurrencyName;
if (strAmountInWordsOfDecimal != string.Empty)
AountInWords = AountInWords + " and " + strAmountInWordsOfDecimal + " " + currencyInfo.SubunitName;
AountInWords = AountInWords + " only";
}
else
{
// Showing currency as prefix
if (strAmountinwordsOfIntiger != string.Empty)
AountInWords = currencyInfo.CurrencyName + " " + strAmountinwordsOfIntiger;
if (strAmountInWordsOfDecimal != string.Empty)
AountInWords = AountInWords + " and " + currencyInfo.SubunitName + " " + strAmountInWordsOfDecimal;
AountInWords = AountInWords + " only";
}
return AountInWords;
}
/// <summary>
/// Function to fill Unit combobox
/// </summary>
public void UnitComboFill()
{
try
{
dtbl = TransactionsGeneralFill.UnitViewAll(cmbUnit, false);
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("ShowUnit") == "Yes")
{
cmbUnit.Enabled = true;
}
else
{
cmbUnit.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show("MPC1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Gridview cell value changed , doing basic calculations and checking invalid entries
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvPaymentVoucher_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
TotalAmount();
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value != null && dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value == null || dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value.ToString() == string.Empty)
{
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(1);
}
}
AccountGroupSP spAccountGroup = new AccountGroupSP();
AccountLedgerSP SpAccountLedger = new AccountLedgerSP();
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value != null && dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value.ToString().Trim() != string.Empty)
{
if (dgvPaymentVoucher.CurrentCell.ColumnIndex == dgvPaymentVoucher.CurrentRow.Cells["dgvcmbAccountLedger"].ColumnIndex)
{
/*************Remove partybalance while changing the ledger ************/
if (inUpdatingRowIndexForPartyRemove != -1)
{
int inTableRowCount = dtblPartyBalance.Rows.Count;
for (int inJ = 0; inJ < inTableRowCount; inJ++)
{
if (dtblPartyBalance.Rows.Count == inJ)
{
break;
}
if (Convert.ToDecimal(dtblPartyBalance.Rows[inJ]["ledgerId"].ToString()) == decUpdatingLedgerForPartyremove)
{
if (dtblPartyBalance.Rows[inJ]["PartyBalanceId"].ToString() != "0")
{
arrlstOfDeletedPartyBalanceRow.Add(dtblPartyBalance.Rows[inJ]["PartyBalanceId"]);
}
dtblPartyBalance.Rows.RemoveAt(inJ);
inJ--;
}
}
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
decUpdatingLedgerForPartyremove = 0;
inUpdatingRowIndexForPartyRemove = -1;
}
/*************************************************************************/
decimal decLedgerId = Convert.ToDecimal(dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value.ToString());
bool IsBankAccount = spAccountGroup.AccountGroupwithLedgerId(decLedgerId);
decimal decI = Convert.ToDecimal(SpAccountLedger.AccountGroupIdCheck(dgvPaymentVoucher.CurrentRow.Cells["dgvcmbAccountLedger"].FormattedValue.ToString()));
if (decI > 0)//to make amount and currency read only when party is choosen as ledger
{
dgvPaymentVoucher.CurrentRow.Cells["dgvtxtAmount"].ReadOnly = true;
dgvPaymentVoucher.CurrentRow.Cells["dgvtxtAmount"].Value = string.Empty;
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(1);
dgvPaymentVoucher.CurrentRow.Cells["dgvcmbCurrency"].ReadOnly = true;
}
else
{
dgvPaymentVoucher.CurrentRow.Cells["dgvtxtAmount"].ReadOnly = false;
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
dgvcmbCurrency.ReadOnly = false;
}
else
{
dgvcmbCurrency.ReadOnly = true;
}
}
}
}
CheckColumnMissing();
DateValidation objVal = new DateValidation();
TextBox txtDate1 = new TextBox();
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value != null)
{
txtDate1.Text = dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value.ToString();
bool isDate = objVal.DateValidationFunction(txtDate1);
if (isDate)
{
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = txtDate1.Text;
}
else
{
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PV48:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On cellvalueChanged of dgvCreditNote
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvJournalVoucher_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
DebitAndCreditTotal();
if (dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value != null && dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
if (dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value == null || dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value.ToString() == string.Empty)
{
dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(1); //decExchangeRateId;
}
}
if (dgvJournalVoucher.Rows[e.RowIndex].Cells[e.ColumnIndex].OwningColumn.Name == "dgvcmbAccountLedger")
{
/*************Remove partybalance while changing the ledger ************/
if (inUpdatingRowIndexForPartyRemove != -1)
{
int inTableRowCount = dtblPartyBalance.Rows.Count;
for (int inJ = 0; inJ < inTableRowCount; inJ++)
{
if (dtblPartyBalance.Rows.Count == inJ)
{
break;
}
if (Convert.ToDecimal(dtblPartyBalance.Rows[inJ]["ledgerId"].ToString()) == decUpdatingLedgerForPartyremove)
{
if (dtblPartyBalance.Rows[inJ]["PartyBalanceId"].ToString() != "0")
{
arrlstOfDeletedPartyBalanceRow.Add(dtblPartyBalance.Rows[inJ]["PartyBalanceId"]);
}
dtblPartyBalance.Rows.RemoveAt(inJ);
inJ--;
}
}
dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
//reset
decUpdatingLedgerForPartyremove = 0;
inUpdatingRowIndexForPartyRemove = -1;
}
/*************************************************************************/
//-----------To make amount readonly when party is selected as ledger------------------------------//
AccountLedgerSP spAccountLedger = new AccountLedgerSP();
if (spAccountLedger.AccountGroupIdCheck(dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].FormattedValue.ToString()))
{
dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtAmount"].ReadOnly = true;
}
else
{
dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtAmount"].ReadOnly = false;
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
dgvcmbCurrency.ReadOnly = false;
}
else
{
dgvcmbCurrency.ReadOnly = true;
}
}
//========================================================================================//
}
if (dgvJournalVoucher.Rows[e.RowIndex].Cells[e.ColumnIndex].OwningColumn.Name == "dgvcmbDrOrCr")
{
/*************Remove partybalance while changing the Dr/Cr ************/
if (inUpdatingRowIndexForPartyRemove != -1)
{
int inTableRowCount = dtblPartyBalance.Rows.Count;
for (int inJ = 0; inJ < inTableRowCount; inJ++)
{
if (dtblPartyBalance.Rows.Count == inJ)
{
break;
}
if (Convert.ToDecimal(dtblPartyBalance.Rows[inJ]["ledgerId"].ToString()) == decUpdatingLedgerForPartyremove)
{
if (dtblPartyBalance.Rows[inJ]["PartyBalanceId"].ToString() != "0")
{
arrlstOfDeletedPartyBalanceRow.Add(dtblPartyBalance.Rows[inJ]["PartyBalanceId"]);
}
dtblPartyBalance.Rows.RemoveAt(inJ);
inJ--;
}
}
dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
//reset
decUpdatingLedgerForPartyremove = 0;
inUpdatingRowIndexForPartyRemove = -1;
}
/*************************************************************************/
}
//-----------------------------------Chequedate validation----------------------------------//
DateValidation obj = new DateValidation();
TextBox txtDate1 = new TextBox();
if (dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value != null && dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
txtDate1.Text = dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value.ToString();
bool isInvalid = obj.DateValidationFunction(txtDate1);
if (!isInvalid)
{
dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
else
{
dgvJournalVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = txtDate1.Text;
}
}
//=========================================================================================//
//---------------------check column missing---------------------------------//
CheckColumnMissing(e);
//==========================================================================//
}
}
catch (Exception ex)
{
MessageBox.Show("JV50:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Edit Function
/// </summary>
public void EditFunction()
{
try
{
removeSalesInvoiceDetails();
SalesMasterSP spSalesMaster = new SalesMasterSP();
SalesMasterInfo InfoSalesMaster = new SalesMasterInfo();
InfoSalesMaster = spSalesMaster.SalesMasterView(decSalesInvoiceIdToEdit);
if (InfoSalesMaster.DeliveryNoteMasterId != 0)
{
DeliveryNoteMasterInfo infoDeliveryNote = new DeliveryNoteMasterInfo();
infoDeliveryNote = new DeliveryNoteMasterSP().DeliveryNoteMasterView(InfoSalesMaster.DeliveryNoteMasterId);
new StockPostingSP().StockPostingDeleteForSalesInvoiceAgainstDeliveryNote
(InfoSalesMaster.VoucherTypeId, InfoSalesMaster.VoucherNo,
infoDeliveryNote.VoucherNo, infoDeliveryNote.VoucherTypeId);
}
new StockPostingSP().StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType
(0, "NA", InfoSalesMaster.VoucherNo, InfoSalesMaster.VoucherTypeId);
InfoSalesMaster.SalesMasterId = decSalesInvoiceIdToEdit;
InfoSalesMaster.AdditionalCost = Convert.ToDecimal(lblLedgerTotalAmount.Text);
InfoSalesMaster.BillDiscount = Convert.ToDecimal(txtBillDiscount.Text.Trim());
InfoSalesMaster.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text.Trim().ToString());
InfoSalesMaster.CustomerName = txtCustomer.Text.Trim();
InfoSalesMaster.Date = Convert.ToDateTime(txtDate.Text.ToString());
InfoSalesMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
InfoSalesMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
InfoSalesMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoSalesMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text.Trim());
InfoSalesMaster.InvoiceNo = txtInvoiceNo.Text.Trim();
InfoSalesMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
InfoSalesMaster.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
InfoSalesMaster.VoucherNo = strVoucherNo;
if (isAutomatic)
{
InfoSalesMaster.SuffixPrefixId = decSalseInvoiceSuffixPrefixId;
}
else
{
InfoSalesMaster.SuffixPrefixId = 0;
}
if (cmbSalesMode.Text == "Against SalesOrder")
{
InfoSalesMaster.OrderMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.OrderMasterId = 0;
}
if (cmbSalesMode.Text == "Against Delivery Note")
{
InfoSalesMaster.DeliveryNoteMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.DeliveryNoteMasterId = 0;
}
if (cmbSalesMode.Text == "Against Quotation")
{
InfoSalesMaster.QuotationMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.QuotationMasterId = 0;
}
InfoSalesMaster.Narration = txtNarration.Text.Trim();
InfoSalesMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
InfoSalesMaster.SalesAccount = Convert.ToDecimal(cmbSalesAccount.SelectedValue.ToString());
InfoSalesMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text.Trim());
if (dgvSalesInvoice.Columns["dgvcmbSalesInvoiceTaxName"].Visible)
{
InfoSalesMaster.TaxAmount = Convert.ToDecimal(lblTaxTotalAmount.Text.Trim());
}
else
{
InfoSalesMaster.TaxAmount = 0;
}
InfoSalesMaster.UserId = PublicVariables._decCurrentUserId;
InfoSalesMaster.LrNo = txtVehicleNo.Text;
InfoSalesMaster.TransportationCompany = txtTransportCompany.Text.Trim();
InfoSalesMaster.POS = false;
InfoSalesMaster.CounterId = 0;
InfoSalesMaster.ExtraDate = DateTime.Now;
InfoSalesMaster.Extra1 = string.Empty;
InfoSalesMaster.Extra2 = string.Empty;
spSalesMaster.SalesMasterEdit(InfoSalesMaster);
removeSalesInvoiceDetails();
SalesInvoiceDetailsEditFill();
if (cmbCashOrParty.Enabled)
{
LedgerPostingSP spLedgerPosting = new LedgerPostingSP();
spLedgerPosting.LedgerPostDelete(strVoucherNo, DecSalesInvoiceVoucherTypeId);
ledgerPostingAdd();
}
else
{
ledgerPostingEdit();
}
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesInvoiceIdToEdit);
}
else
{
Print(decSalesInvoiceIdToEdit);
}
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("SI: 78" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save or edit function to checking the negative stock status
/// </summary>
public void SaveOrEditFunction()
{
try
{
decimal decProductId = 0;
decimal decBatchId = 0;
decimal decCalcQty = 0;
StockPostingSP spStockPosting = new StockPostingSP();
SettingsSP spSettings = new SettingsSP();
string strStatus = spSettings.SettingsStatusCheck("NegativeStockStatus");
bool isNegativeLedger = false;
int inRowCount = dgvSalesInvoice.RowCount;
for (int i = 0; i < inRowCount - 1; i++)
{
if (dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceProductId"].Value != null && dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceProductId"].Value.ToString() != string.Empty)
{
decProductId = Convert.ToDecimal(dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceProductId"].Value.ToString());
if (dgvSalesInvoice.Rows[i].Cells["dgvcmbSalesInvoiceBatch"].Value != null && dgvSalesInvoice.Rows[i].Cells["dgvcmbSalesInvoiceBatch"].Value.ToString() != string.Empty)
{
decBatchId = Convert.ToDecimal(dgvSalesInvoice.Rows[i].Cells["dgvcmbSalesInvoiceBatch"].Value.ToString());
}
decimal decCurrentStock = spStockPosting.StockCheckForProductSale(decProductId, decBatchId);
if (dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceQty"].Value != null && dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceQty"].Value.ToString() != string.Empty)
{
decCalcQty = decCurrentStock - Convert.ToDecimal(dgvSalesInvoice.Rows[i].Cells["dgvtxtSalesInvoiceQty"].Value.ToString());
}
if (decCalcQty < 0)
{
isNegativeLedger = true;
break;
}
}
}
if (isNegativeLedger)
{
if (strStatus == "Warn")
{
if (MessageBox.Show("Negative Stock balance exists,Do you want to Continue", "Open miracle", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
SaveOrEdit();
}
}
else if (strStatus == "Block")
{
MessageBox.Show("Cannot continue ,due to negative stock balance", "Open miracle", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else
{
SaveOrEdit();
}
}
else
{
SaveOrEdit();
}
}
catch (Exception ex)
{
MessageBox.Show("SI : 68" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// When Form Loads
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmDeliveryNote_Load(object sender, EventArgs e)
{
try
{
Clear();
PrintCheck();
FillProducts(false, null);
SettingsSP Spsetting = new SettingsSP();
if (Spsetting.SettingsStatusCheck("ShowProductCode") == "Yes")
{
dgvProduct.Columns["dgvtxtProductCode"].Visible = true;
}
else
{
dgvProduct.Columns["dgvtxtProductCode"].Visible = false;
}
if (Spsetting.SettingsStatusCheck("barcode") == "Yes")
{
dgvProduct.Columns["dgvtxtBarcode"].Visible = true;
}
else
{
dgvProduct.Columns["dgvtxtBarcode"].Visible = false;
}
if (Spsetting.SettingsStatusCheck("ShowUnit") == "Yes")
{
dgvProduct.Columns["dgvcmbUnit"].Visible = true;
}
else
{
dgvProduct.Columns["dgvcmbUnit"].Visible = false;
}
if (Spsetting.SettingsStatusCheck("AllowGodown") == "Yes")
{
dgvProduct.Columns["dgvcmbGodown"].Visible = true;
dgvProduct.Columns["dgvcmbRack"].Visible = true;
}
else
{
dgvProduct.Columns["dgvcmbGodown"].Visible = false;
dgvProduct.Columns["dgvcmbRack"].Visible = false;
}
if (Spsetting.SettingsStatusCheck("AllowRack") == "Yes")
{
if (Spsetting.SettingsStatusCheck("AllowGodown") == "Yes")
dgvProduct.Columns["dgvcmbRack"].Visible = true;
else
dgvProduct.Columns["dgvcmbRack"].Visible = false;
}
else
{
dgvProduct.Columns["dgvcmbRack"].Visible = false;
}
if (Spsetting.SettingsStatusCheck("AllowBatch") == "Yes")
{
dgvProduct.Columns["dgvcmbBatch"].Visible = true;
}
else
{
dgvProduct.Columns["dgvcmbBatch"].Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("DN51:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void FillGrid()
{
try
{
if (!isFormLoad)
{
DateValidation objValidation = new DateValidation();
objValidation.DateValidationFunction(txtToDate);
if (txtToDate.Text == string.Empty)
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
}
Font newFont = new Font(dgvReport.Font, FontStyle.Bold);
CurrencyInfo InfoCurrency = new CurrencyInfo();
CurrencySP SpCurrency = new CurrencySP();
InfoCurrency = SpCurrency.CurrencyView(1);
int inDecimalPlaces = InfoCurrency.NoOfDecimalPlaces;
dgvReport.Rows.Clear();
FinancialStatementSP SpFinance = new FinancialStatementSP();
DataSet DsetBalanceSheet = new DataSet();
DataTable dtbl = new DataTable();
SettingsInfo InfoSettings = new SettingsInfo();
SettingsSP SpSettings = new SettingsSP();
//--------------- Selection Of Calculation Method According To Settings ------------------//
if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
calculationMethod = "FIFO";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
calculationMethod = "Average Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
calculationMethod = "High Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
calculationMethod = "Low Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
calculationMethod = "Last Purchase Rate";
}
int LiabilityRow = 0;
int AssetRow = 0;
decimal TotalAssets = 0;
decimal TotalLiabilities = 0;
decimal OpeningStock = SpFinance.StockValueGetOnDate(Convert.ToDateTime(txtToDate.Text), calculationMethod, true, true);
OpeningStock = Math.Round(OpeningStock, inDecimalPlaces);
DsetBalanceSheet = SpFinance.BalanceSheet(PublicVariables._dtFromDate, DateTime.Parse(txtToDate.Text));
//------------------- Asset -------------------------------//
dtbl = DsetBalanceSheet.Tables[0];
foreach (DataRow rw in dtbl.Rows)
{
dgvReport.Rows.Add();
decimal balance = (rw["ID"].ToString() == "6") ? Convert.ToDecimal(rw["Balance"].ToString()) + OpeningStock : Convert.ToDecimal(rw["Balance"].ToString());
if (balance > 0)
{
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Value = rw["Name"].ToString();
dgvReport.Rows[AssetRow].Cells["Amount1"].Value = balance.ToString("N2");
dgvReport.Rows[AssetRow].Cells["GroupId1"].Value = rw["ID"].ToString();
TotalAssets += balance;
AssetRow++;
}
else
{
balance = balance * -1;
dgvReport.Rows.Add();
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Value = rw["Name"].ToString();
dgvReport.Rows[LiabilityRow].Cells["Amount2"].Value = balance.ToString("N2");
dgvReport.Rows[LiabilityRow].Cells["GroupId2"].Value = rw["ID"].ToString();
TotalLiabilities += balance;
LiabilityRow++;
}
}
//------------------------ Liability ---------------------//
dtbl = DsetBalanceSheet.Tables[1];
foreach (DataRow rw in dtbl.Rows)
{
decimal balance = Convert.ToDecimal(rw["Balance"].ToString());
if (balance < 0)
{
balance = balance * -1;
dgvReport.Rows.Add();
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Value = rw["Name"].ToString();
dgvReport.Rows[AssetRow].Cells["Amount1"].Value = balance.ToString("N2");
dgvReport.Rows[AssetRow].Cells["GroupId1"].Value = rw["ID"].ToString();
TotalAssets += balance;
AssetRow++;
}
else
{
dgvReport.Rows.Add();
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Value = rw["Name"].ToString();
dgvReport.Rows[LiabilityRow].Cells["Amount2"].Value = balance.ToString("N2");
dgvReport.Rows[LiabilityRow].Cells["GroupId2"].Value = rw["ID"].ToString();
TotalLiabilities += balance;
LiabilityRow++;
}
}
//---------------------Closing Stock---------------------------------------------------------------------------------------------------------------
decimal ClosingStock = SpFinance.StockValueGetOnDate(Convert.ToDateTime(txtToDate.Text), calculationMethod, false, false);
ClosingStock = Math.Round(ClosingStock, inDecimalPlaces) - OpeningStock;
if (ClosingStock != 0)
{
if (ClosingStock > 0)
{
dgvReport.Rows.Add();
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Value = "Closing Stock";
dgvReport.Rows[AssetRow].Cells["Amount1"].Value = ClosingStock.ToString("N2");
TotalAssets += ClosingStock;
AssetRow++;
}
else
{
ClosingStock = ClosingStock * -1;
dgvReport.Rows.Add();
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Value = "Closing Stock";
dgvReport.Rows[LiabilityRow].Cells["Amount2"].Value = ClosingStock.ToString("N2");
TotalLiabilities += ClosingStock;
LiabilityRow++;
}
}
if (AssetRow > LiabilityRow)
{
LiabilityRow = AssetRow;
}
else
{
AssetRow = LiabilityRow;
}
//---------------------Profit And Loss---------------------------------------------------------------------------------------------------------------
DataSet dsetProfitAndLoss = SpFinance.ProfitAndLossAnalysisUpToaDateForBalansheet(PublicVariables._dtFromDate, DateTime.Parse(txtToDate.Text));
decimal dcProfit = 0;
for (int i = 0; i < dsetProfitAndLoss.Tables.Count; ++i)
{
dtbl = dsetProfitAndLoss.Tables[i];
decimal dcSum = 0;
if (i == 0 || (i % 2) == 0)
{
if (dtbl.Rows.Count > 0)
{
dcSum = decimal.Parse(dtbl.Compute("Sum(Debit)", string.Empty).ToString());
dcProfit = dcProfit - dcSum;
}
}
else
{
if (dtbl.Rows.Count > 0)
{
dcSum = decimal.Parse(dtbl.Compute("Sum(Credit)", string.Empty).ToString());
dcProfit = dcProfit + dcSum;
}
}
}
DataSet dsetProfitAndLossOpening = SpFinance.ProfitAndLossAnalysisUpToaDateForPreviousYears(PublicVariables._dtFromDate);
decimal dcProfitOpening = 0;
for (int i = 0; i < dsetProfitAndLossOpening.Tables.Count; ++i)
{
dtbl = dsetProfitAndLossOpening.Tables[i];
decimal dcSum = 0;
if (i == 0 || (i % 2) == 0)
{
if (dtbl.Rows.Count > 0)
{
dcSum = decimal.Parse(dtbl.Compute("Sum(Debit)", string.Empty).ToString());
dcProfitOpening = dcProfitOpening - dcSum;
}
}
else
{
if (dtbl.Rows.Count > 0)
{
dcSum = decimal.Parse(dtbl.Compute("Sum(Credit)", string.Empty).ToString());
dcProfitOpening = dcProfitOpening + dcSum;
}
}
}
decimal decProfitLedgerOpening = decimal.Parse(DsetBalanceSheet.Tables[3].Compute("Sum(Balance)", string.Empty).ToString());
decimal decTotalProfitAndLoss = decimal.Parse(DsetBalanceSheet.Tables[2].Compute("Sum(Balance)", string.Empty).ToString());
decimal decCurrentProfitLoss = dcProfit + ClosingStock;
decimal decOpeningOfProfitAndLoss = decProfitLedgerOpening + dcProfitOpening;
decimal decTotalProfitAndLossOverAll = decTotalProfitAndLoss + decOpeningOfProfitAndLoss + decCurrentProfitLoss;
decTotalProfitAndLoss = (decTotalProfitAndLoss < 0) ? decTotalProfitAndLoss * -1 : decTotalProfitAndLoss;
decOpeningOfProfitAndLoss = (decOpeningOfProfitAndLoss < 0) ? decOpeningOfProfitAndLoss * -1 : decOpeningOfProfitAndLoss;
decCurrentProfitLoss = (decCurrentProfitLoss < 0) ? decCurrentProfitLoss * -1 : decCurrentProfitLoss;
if (decTotalProfitAndLossOverAll >= 0)
{
dgvReport.Rows.Add();
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Value = "----------------------------------------";
dgvReport.Rows[AssetRow].DefaultCellStyle.Font = newFont;
AssetRow++;
foreach (DataRow dRow in DsetBalanceSheet.Tables[2].Rows)
{
if (dRow["Name"].ToString() == "Profit And Loss Account")
{
dgvReport.Rows.Add();
dgvReport.Rows[AssetRow].DefaultCellStyle.Font = newFont;
dgvReport.Rows[AssetRow].DefaultCellStyle.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Value = dRow["Name"].ToString();
dgvReport.Rows[AssetRow].Cells["Amount1"].Value = Math.Round(decTotalProfitAndLoss + decCurrentProfitLoss, PublicVariables._inNoOfDecimalPlaces).ToString("N2");
dgvReport.Rows[AssetRow].Cells["GroupId1"].Value = dRow["ID"].ToString();
AssetRow++;
}
}
//-------------- Asset ---------------//
dgvReport.Rows.Add();
dgvReport.Rows[AssetRow].DefaultCellStyle.Font = newFont;
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Value = "Profit And Loss (Opening)";
dgvReport.Rows[AssetRow].Cells["Amount1"].Value = Math.Round(decTotalProfitAndLoss, PublicVariables._inNoOfDecimalPlaces).ToString("N2");
dgvReport.Rows[AssetRow].Cells["Amount1"].Style.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Style.ForeColor = Color.DarkSlateGray;
AssetRow++;
//-------------- Asset ---------------//
dgvReport.Rows.Add();
dgvReport.Rows[AssetRow].DefaultCellStyle.Font = newFont;
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Value = "Current Period";
dgvReport.Rows[AssetRow].Cells["Amount1"].Value = Math.Round(decCurrentProfitLoss, PublicVariables._inNoOfDecimalPlaces).ToString("N2");
dgvReport.Rows[AssetRow].Cells["Amount1"].Style.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Style.ForeColor = Color.DarkSlateGray;
AssetRow++;
TotalAssets = TotalAssets + (decCurrentProfitLoss + decTotalProfitAndLoss);
dgvReport.Rows.Add();
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Value = "----------------------------------------";
dgvReport.Rows[AssetRow].DefaultCellStyle.Font = newFont;
AssetRow++;
}
else
{
dgvReport.Rows.Add();
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Value = "----------------------------------------";
dgvReport.Rows[LiabilityRow].DefaultCellStyle.Font = newFont;
LiabilityRow++;
foreach (DataRow dRow in DsetBalanceSheet.Tables[2].Rows)
{
if (dRow["Name"].ToString() == "Profit And Loss Account")
{
dgvReport.Rows.Add();
dgvReport.Rows[LiabilityRow].DefaultCellStyle.Font = newFont;
dgvReport.Rows[LiabilityRow].DefaultCellStyle.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Value = dRow[1].ToString();
dgvReport.Rows[LiabilityRow].Cells["Amount2"].Value = Math.Round(decTotalProfitAndLoss + decCurrentProfitLoss, PublicVariables._inNoOfDecimalPlaces).ToString("N2");
dgvReport.Rows[LiabilityRow].Cells["GroupId2"].Value = dRow[0].ToString();
LiabilityRow++;
}
}
//------------ Liability ------------//
dgvReport.Rows.Add();
dgvReport.Rows[LiabilityRow].DefaultCellStyle.Font = newFont;
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Value = "Profit And Loss (Opening)";
dgvReport.Rows[LiabilityRow].Cells["Amount2"].Value = Math.Round(decTotalProfitAndLoss, inDecimalPlaces).ToString("N2");
dgvReport.Rows[LiabilityRow].Cells["Amount2"].Style.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Style.ForeColor = Color.DarkSlateGray;
TotalLiabilities += decOpeningOfProfitAndLoss;
LiabilityRow++;
//------------ Liability ------------//
dgvReport.Rows.Add();
dgvReport.Rows[LiabilityRow].DefaultCellStyle.Font = newFont;
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Value = "Current Period";
dgvReport.Rows[LiabilityRow].Cells["Amount2"].Value = Math.Round(decCurrentProfitLoss, inDecimalPlaces).ToString("N2");
dgvReport.Rows[LiabilityRow].Cells["Amount2"].Style.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Style.ForeColor = Color.DarkSlateGray;
TotalLiabilities = TotalLiabilities + (decCurrentProfitLoss + decTotalProfitAndLoss); //dcProfit;
LiabilityRow++;
dgvReport.Rows.Add();
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Value = "----------------------------------------";
dgvReport.Rows[LiabilityRow].DefaultCellStyle.Font = newFont;
LiabilityRow++;
}
if (AssetRow > LiabilityRow)
{
LiabilityRow = AssetRow;
}
else
{
AssetRow = LiabilityRow;
}
dgvReport.Rows.Add();
decimal dcDiffAsset = 0;
decimal dcDiffLiability = 0;
LiabilityRow++;
AssetRow++;
if (TotalAssets > TotalLiabilities)
{
//--------------- Liability exceeds so in asset side ----------------//
dgvReport.Rows.Add();
dgvReport.Rows[LiabilityRow].Cells["dgvtxtLiability"].Value = "Difference";
dgvReport.Rows[LiabilityRow].Cells["Amount2"].Value = Math.Round((TotalAssets - TotalLiabilities), inDecimalPlaces).ToString("N2");
dgvReport.Rows[LiabilityRow].DefaultCellStyle.Font = newFont;
dgvReport.Rows[LiabilityRow].DefaultCellStyle.ForeColor = Color.DarkRed;
dcDiffLiability = TotalAssets - TotalLiabilities;
LiabilityRow++;
}
else
{
//--------------- Asset exceeds so in liability side ----------------//
dgvReport.Rows.Add();
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Value = "Difference";
dgvReport.Rows[AssetRow].Cells["Amount1"].Value = Math.Round((TotalLiabilities - TotalAssets), inDecimalPlaces).ToString("N2");
dgvReport.Rows[AssetRow].DefaultCellStyle.Font = newFont;
dgvReport.Rows[AssetRow].DefaultCellStyle.ForeColor = Color.DarkRed;
dcDiffAsset = TotalLiabilities - TotalAssets;
AssetRow++;
}
if (AssetRow > LiabilityRow)
{
LiabilityRow = AssetRow;
}
else
{
AssetRow = LiabilityRow;
}
dgvReport.Rows.Add();
dgvReport.Rows.Add();
AssetRow++;
dgvReport.Rows[AssetRow].Cells["Amount1"].Value = "________________________";
dgvReport.Rows[AssetRow].Cells["Amount2"].Value = "________________________";
dgvReport.Rows.Add();
AssetRow++;
dgvReport.Rows[AssetRow].DefaultCellStyle.Font = newFont;
dgvReport.Rows[AssetRow].Cells["dgvtxtLiability"].Value = "Total";
dgvReport.Rows[AssetRow].Cells["dgvtxtAsset"].Value = "Total";
dgvReport.Rows[AssetRow].Cells["Amount1"].Value = Math.Round((TotalAssets + dcDiffAsset), inDecimalPlaces).ToString("N2");
dgvReport.Rows[AssetRow].Cells["Amount2"].Value = Math.Round((TotalLiabilities + dcDiffLiability), inDecimalPlaces).ToString("N2");
LiabilityRow++;
if (dgvReport.Columns.Count > 0)
{
dgvReport.Columns["Amount1"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvReport.Columns["Amount2"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
decPrintOrNot = TotalAssets + dcDiffAsset;
decPrintOrNot1 = TotalLiabilities + dcDiffLiability;
if (inCurrenRowIndex >= 0 && dgvReport.Rows.Count > 0 && inCurrenRowIndex < dgvReport.Rows.Count)
{
if (dgvReport.Rows[inCurrenRowIndex].Cells[inCurentcolIndex].Visible)
{
dgvReport.CurrentCell = dgvReport.Rows[inCurrenRowIndex].Cells[inCurentcolIndex];
}
if (dgvReport.CurrentCell != null && dgvReport.CurrentCell.Visible)
{
dgvReport.CurrentCell.Selected = true;
}
}
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "BS1:" + ex.Message;
}
}
/// <summary>
/// Function to remove incomplete rows from production grid
/// </summary>
/// <returns></returns>
public bool RemoveIncompleteRowsFromProductionGrid()
{
SettingsSP spSettings = new SettingsSP();
bool isOk = true;
try
{
string strMessage = "Rows";
int inC = 0, inForFirst = 0;
int inRowcount = dgvConsumption.RowCount;
int inLastRow = 1;
foreach (DataGridViewRow dgvrowCur in dgvProduction.Rows)
{
if (inLastRow < inRowcount)
{
if (dgvrowCur.HeaderCell.Value != null)
{
if (spSettings.SettingsStatusCheck("AllowZeroValueEntry") == "No" && Convert.ToDecimal(dgvrowCur.Cells["dgvtxtProductionAmount"].Value) == 0)
{
dgvProduction.CurrentRow.HeaderCell.Value = "X";
dgvProduction.CurrentRow.HeaderCell.Style.ForeColor = Color.Red;
}
if (dgvrowCur.HeaderCell.Value.ToString() == "X" || dgvrowCur.Cells["dgvtxtProductionProductName"].Value == null)
{
isOk = false;
if (inC == 0)
{
strMessage = strMessage + Convert.ToString(dgvrowCur.Index + 1);
inForFirst = dgvrowCur.Index;
inC++;
}
else
{
strMessage = strMessage + ", " + Convert.ToString(dgvrowCur.Index + 1);
}
}
}
}
inLastRow++;
}
inLastRow = 1;
if (!isOk)
{
strMessage = strMessage + " contains invalid entries. Do you want to continue?";
if (MessageBox.Show(strMessage, "OpenMiracle", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
isOk = true;
for (int inK = 0; inK < dgvProduction.Rows.Count; inK++)
{
if (dgvProduction.Rows[inK].HeaderCell.Value != null && dgvProduction.Rows[inK].HeaderCell.Value.ToString() == "X")
{
if (!dgvProduction.Rows[inK].IsNewRow)
{
dgvProduction.Rows.RemoveAt(inK);
inK--;
ProductionSerialNo();
}
}
}
}
else
{
dgvProduction.Focus();
}
}
}
catch (Exception ex)
{
MessageBox.Show("SJ:38" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return isOk;
}
/// <summary>
/// Function to fill Datagridview after calculation
/// </summary>
public void GridFill()
{
try
{
if (!isFormLoad)
{
DateValidation objValidation = new DateValidation();
objValidation.DateValidationFunction(txtFundFlowFromDate);
if (txtFundFlowFromDate.Text == string.Empty)
{
txtFundFlowFromDate.Text = PublicVariables._dtFromDate.ToString("dd-MMM-yyyy");
}
objValidation.DateValidationFunction(txtFundflowToDate);
if (txtFundflowToDate.Text == string.Empty)
{
txtFundflowToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
}
//-------------------------------------First gridfill-------------------------------------//
DateTime strFromDate = Convert.ToDateTime(txtFundFlowFromDate.Text.ToString());
DateTime strTodate = Convert.ToDateTime(txtFundflowToDate.Text.ToString());
FinancialStatementSP spFinancial = new FinancialStatementSP();
DataSet dsetFinancial = new DataSet();
SettingsInfo InfoSettings = new SettingsInfo();
SettingsSP SpSettings = new SettingsSP();
//--------------- Selection Of Calculation Method According To Settings ------------------//
if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
strCalculationMethod = "FIFO";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
strCalculationMethod = "Average Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
strCalculationMethod = "High Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
strCalculationMethod = "Low Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
strCalculationMethod = "Last Purchase Rate";
}
dsetFinancial = spFinancial.FundFlow(strFromDate, strTodate);
DataTable dtbl = new DataTable();
Font newFont = new Font(dgvFundFlow.Font, FontStyle.Bold);
CurrencyInfo InfoCurrency = new CurrencyInfo();
CurrencySP SpCurrency = new CurrencySP();
InfoCurrency = SpCurrency.CurrencyView(1);
int inDecimalPlaces = InfoCurrency.NoOfDecimalPlaces;
dgvFundFlow.Rows.Clear();
////-------------------Source--------------------------------------------------------------
dtbl = dsetFinancial.Tables[0];
foreach (DataRow rw in dtbl.Rows)
{
dgvFundFlow.Rows.Add();
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtSource"].Value = rw["Name"].ToString();
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = rw["Balance"].ToString();
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtgroupId1"].Value = rw["ID"].ToString();
}
decimal dcTotalAsset = 0;
if (dtbl.Rows.Count > 0)
{
dcTotalAsset = decimal.Parse(dtbl.Compute("Sum(Balance)", string.Empty).ToString());
}
////-----------------Application------------------------------------------------------------
dtbl = new DataTable();
dtbl = dsetFinancial.Tables[1];
int index = 0;
foreach (DataRow rw in dtbl.Rows)
{
if (index < dgvFundFlow.Rows.Count)
{
dgvFundFlow.Rows[index].Cells["dgvtxtApplication"].Value = rw["Name"].ToString();
dgvFundFlow.Rows[index].Cells["dgvtxtAmount2"].Value = rw["Balance"].ToString();
dgvFundFlow.Rows[index].Cells["dgvtxtgroupId2"].Value = rw["ID"].ToString();
}
else
{
dgvFundFlow.Rows.Add();
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtApplication"].Value = rw["Name"].ToString();
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = rw["Balance"].ToString();
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtgroupId2"].Value = rw["ID"].ToString();
}
index++;
}
decimal dcTotalLiability = 0;
if (dtbl.Rows.Count > 0)
{
dcTotalLiability = Convert.ToDecimal(dtbl.Compute("Sum(Balance)", string.Empty).ToString());
}
//-------------------- Closing Stock -----------------------// With Calculation
dcClosingStock = spFinancial.StockValueGetOnDate(Convert.ToDateTime(txtFundflowToDate.Text), strCalculationMethod, false, false);
dcClosingStock = Math.Round(dcClosingStock, inDecimalPlaces);
//---------------------Opening Stock-----------------------
decimal dcOpeninggStock = spFinancial.StockValueGetOnDate(Convert.ToDateTime(txtFundFlowFromDate.Text), strCalculationMethod, true, false);
//------------- Profit Or Loss -----------// With Calculation
decimal dcProfit = 0;
DataSet dsetProfitAndLoss = new DataSet();
dsetProfitAndLoss = spFinancial.ProfitAndLossAnalysisUpToaDateForBalansheet(Convert.ToDateTime(txtFundFlowFromDate.Text), Convert.ToDateTime(txtFundflowToDate.Text));
DataTable dtblProfit = new DataTable();
dtblProfit = dsetProfitAndLoss.Tables[0];
for (int i = 0; i < dsetProfitAndLoss.Tables.Count; ++i)
{
dtbl = dsetProfitAndLoss.Tables[i];
decimal dcSum = 0;
if (i == 0 || (i % 2) == 0)
{
if (dtbl.Rows.Count > 0)
{
dcSum = Convert.ToDecimal(dtbl.Compute("Sum(Debit)", string.Empty).ToString());
dcProfit = dcProfit - dcSum;
}
}
else
{
if (dtbl.Rows.Count > 0)
{
dcSum = Convert.ToDecimal(dtbl.Compute("Sum(Credit)", string.Empty).ToString());
dcProfit = dcProfit + dcSum;
}
}
}
//---------------------NetProfit/NetLoss Calculation--------------------------
dcProfit = dcProfit + dcClosingStock - dcOpeninggStock;
if (dcProfit > 0)
{
//------------ Liability ------------//
dgvFundFlow.Rows.Add();
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtSource"].Value = "Net Profit";
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = Math.Round(dcProfit, inDecimalPlaces);
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtAmount1"].Style.ForeColor = Color.Green;
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtSource"].Style.ForeColor = Color.Green;
//dcTotalLiability += dcProfit;
}
else
{
//-------------- Asset ---------------//
dgvFundFlow.Rows.Add();
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtApplication"].Value = "Net Loss";
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = -Math.Round(dcProfit, inDecimalPlaces);
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtAmount2"].Style.ForeColor = Color.Red;
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtApplication"].Style.ForeColor = Color.Red;
}
if (dcProfit > 0)
{
dcTotalAsset += (dcProfit);
}
else
{
dcTotalLiability += (-dcProfit);
}
decimal dcTotalValue = dcTotalAsset;
dgvFundFlow.Rows.Add();
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = "_______________________";
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = "_______________________";
dgvFundFlow.Rows.Add();
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtApplication"].Value = "Total";
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtSource"].Value = "Total";
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = Math.Round((dcTotalAsset), inDecimalPlaces);
dgvFundFlow.Rows[dgvFundFlow.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = Math.Round((dcTotalLiability), inDecimalPlaces);
//----------------------------------------Second gridfill----------------------------------------------
//--------------------------------------Current Assets-------------------------------------------
Font newFont2 = new Font(dgvFundFlow2.Font, FontStyle.Bold);
dgvFundFlow2.Rows.Clear();
dtbl = dsetFinancial.Tables[3];
decimal decWC = 0;
foreach (DataRow rw in dtbl.Rows)
{
dgvFundFlow2.Rows.Add();
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtgroupId"].Value = rw["ID"].ToString();
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtParticulars"].Value = rw["Name"].ToString();
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtOpeningBalance"].Value = rw["OpeningBalance"].ToString() + "Dr";
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtop"].Value = rw["OpeningBalance"].ToString();
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtcb"].Value = rw["ClosingBalance"].ToString();
decimal decOB = Convert.ToDecimal(rw["OpeningBalance"].ToString());
decimal decCB = Convert.ToDecimal(rw["ClosingBalance"].ToString());
decCB = decCB + dcClosingStock;
if (decCB > 0)
{
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtClosingBalance"].Value = Math.Round(decCB, inDecimalPlaces).ToString() + "Dr";
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtcb"].Value = Math.Round(decCB, inDecimalPlaces).ToString();
}
else
{
decCB = -1 * decCB;
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtClosingBalance"].Value = Math.Round(decCB, inDecimalPlaces).ToString() + "Dr";
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtcb"].Value = Math.Round(decCB, inDecimalPlaces).ToString();
}
decWC = decOB - decCB;
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtWorkingCapitalIncrease"].Value = Math.Round(decWC, inDecimalPlaces).ToString();
}
//--------------------------------------Current Liability-------------------------------------------
dtbl = dsetFinancial.Tables[5];
decimal decWCCL = 0;
foreach (DataRow rw in dtbl.Rows)
{
dgvFundFlow2.Rows.Add();
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtgroupId"].Value = rw["ID"].ToString();
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtParticulars"].Value = rw["Name"].ToString();
decimal decOp = Convert.ToDecimal(rw["OpeningBalance"].ToString());
decimal decCb = Convert.ToDecimal(rw["ClosingBalance"].ToString());
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtOpeningBalance"].Value = decOp.ToString() + "Cr";
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtop"].Value = rw["OpeningBalance"].ToString();
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtcb"].Value = rw["ClosingBalance"].ToString();
if (decCb > 0)
{
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtClosingBalance"].Value = decCb.ToString() + "Cr";
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtcb"].Value = decCb.ToString();
}
else
{
decCb = -1 * decCb;
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtClosingBalance"].Value = decCb.ToString() + "Cr";
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtcb"].Value = decCb.ToString();
}
decimal decOB = Convert.ToDecimal(rw["OpeningBalance"].ToString());
decimal decCB = Convert.ToDecimal(rw["ClosingBalance"].ToString());
decWCCL = decOp - decCb;
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtWorkingCapitalIncrease"].Value = decWCCL.ToString();
}
//-----------------Calculating Working capital---------------
decimal decOpen = 0;
decimal decClose = 0;
decimal decWork = 0;
decOpen = Convert.ToDecimal(dgvFundFlow2.Rows[0].Cells[3].Value.ToString()) - Convert.ToDecimal(dgvFundFlow2.Rows[1].Cells[3].Value.ToString());
decClose = Convert.ToDecimal(dgvFundFlow2.Rows[0].Cells[5].Value.ToString()) - Convert.ToDecimal(dgvFundFlow2.Rows[1].Cells[5].Value.ToString());
decWork = Convert.ToDecimal(dgvFundFlow2.Rows[0].Cells[6].Value.ToString()) - Convert.ToDecimal(dgvFundFlow2.Rows[1].Cells[6].Value.ToString());
decimal decW1 = Convert.ToDecimal(dgvFundFlow2.Rows[0].Cells[6].Value.ToString());
decimal decW2 = Convert.ToDecimal(dgvFundFlow2.Rows[1].Cells[6].Value.ToString());
dgvFundFlow2.Rows.Add();
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtParticulars"].Value = "Working Capital";
if (decOpen > 0)
{
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtOpeningBalance"].Value = decOpen.ToString() + "Dr";
}
else
{
decOpen *= -1;
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtOpeningBalance"].Value = decOpen.ToString() + "Cr";
}
if (decClose > 0)
{
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtClosingBalance"].Value = decClose.ToString() + "Dr";
}
else
{
decClose *= -1;
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtClosingBalance"].Value = decClose.ToString() + "Cr";
}
dgvFundFlow2.Rows[dgvFundFlow2.Rows.Count - 1].Cells["dgvtxtWorkingCapitalIncrease"].Value = decWork.ToString();
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "FF6:" + ex.Message;
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void Gridfill()
{
try
{
if (!isFormLoad)
{
DateValidation objValidation = new DateValidation();
objValidation.DateValidationFunction(txtFromDate);
if (txtFromDate.Text == string.Empty)
{
txtFromDate.Text = PublicVariables._dtFromDate.ToString("dd-MMM-yyyy");
}
objValidation.DateValidationFunction(txtToDate);
if (txtToDate.Text == string.Empty)
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
}
Font newFont = new Font(dgvProfitAndLoss.Font, FontStyle.Bold);
CurrencyInfo InfoCurrency = new CurrencyInfo();
CurrencySP SpCurrency = new CurrencySP();
InfoCurrency = SpCurrency.CurrencyView(1);
int inDecimalPlaces = InfoCurrency.NoOfDecimalPlaces;
dgvProfitAndLoss.Rows.Clear();
FinancialStatementSP spFinancial = new FinancialStatementSP();
DataTable dtblFinancial = new DataTable();
DataSet DsetProfitAndLoss = new DataSet();
SettingsInfo infoSettings = new SettingsInfo();
SettingsSP SpSettings = new SettingsSP();
//---------check calculation method
if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
calculationMethod = "FIFO";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
calculationMethod = "Average Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
calculationMethod = "High Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
calculationMethod = "Low Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
calculationMethod = "Last Purchase Rate";
}
DsetProfitAndLoss = spFinancial.ProfitAndLossAnalysis(DateTime.Parse(txtFromDate.Text), DateTime.Parse(txtToDate.Text));
//---- Opening Stock
dgvProfitAndLoss.Rows.Add();
decimal dcOpeningStock = spFinancial.StockValueGetOnDate(DateTime.Parse(txtFromDate.Text), DateTime.Parse(txtToDate.Text), calculationMethod, true, false);
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtExpenses"].Value = "Opening Stock";
if (dcOpeningStock > 0)
{
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = Math.Round(dcOpeningStock, inDecimalPlaces);
}
else
{
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = -(Math.Round(dcOpeningStock, inDecimalPlaces));
}
//Closing Stock
decimal dcClosingStock = 0;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtIncome"].Value = "Closing Stock";
dcClosingStock = spFinancial.StockValueGetOnDate(DateTime.Parse(txtToDate.Text), calculationMethod, false, false);
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = Math.Round(dcClosingStock, inDecimalPlaces);
/// ---Purchase Account - Debit
dtblFinancial = new DataTable();
dtblFinancial = DsetProfitAndLoss.Tables[0];
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtExpenses"].Value = "Purchase Accounts";
decimal dcPurchaseAccount = 0m;
if (dtblFinancial.Rows.Count > 0)
{
foreach (DataRow rw in dtblFinancial.Rows)
{
decimal dcBalance = decimal.Parse(rw["Debit"].ToString().ToString());
dcPurchaseAccount += dcBalance;
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtGroupId1"].Value = "11";
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = dcPurchaseAccount.ToString();
//---Sales Account -Credit
dtblFinancial = new DataTable();
dtblFinancial = DsetProfitAndLoss.Tables[1];
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtIncome"].Value = "Sales Accounts";
decimal dcSalesAccount = 0m;
if (dtblFinancial.Rows.Count > 0)
{
foreach (DataRow rw in dtblFinancial.Rows)
{
decimal dcBalance = decimal.Parse(rw["Credit"].ToString().ToString());
dcSalesAccount += dcBalance;
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtGroupId2"].Value = "10";
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = dcSalesAccount.ToString();
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows.Add();
//---Direct Expense
dtblFinancial = new DataTable();
dtblFinancial = DsetProfitAndLoss.Tables[2];
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtExpenses"].Value = "Direct Expenses";
decimal dcDirectExpense = 0m;
if (dtblFinancial.Rows.Count > 0)
{
foreach (DataRow rw in dtblFinancial.Rows)
{
decimal dcBalance = Convert.ToDecimal(rw["Debit"].ToString());
dcDirectExpense += dcBalance;
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtGroupId1"].Value = "13";
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = dcDirectExpense.ToString();
//----Direct Income
dtblFinancial = new DataTable();
dtblFinancial = DsetProfitAndLoss.Tables[3];
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtIncome"].Value = "Direct Incomes";
decimal dcDirectIncoome = 0m;
if (dtblFinancial.Rows.Count > 0)
{
foreach (DataRow rw in dtblFinancial.Rows)
{
decimal dcBalance = Convert.ToDecimal(rw["Credit"].ToString());
dcDirectIncoome += dcBalance;
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtGroupId2"].Value = "12";
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = dcDirectIncoome.ToString();
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = "_______________________";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = "_______________________";
dgvProfitAndLoss.Rows.Add();
decimal dcTotalExpense = 0;
decimal dcTotalIncome = 0;
dcTotalExpense = dcOpeningStock + dcPurchaseAccount + dcDirectExpense;
dcTotalIncome = dcClosingStock + dcSalesAccount + dcDirectIncoome;
dcTotalExpense = Math.Round(dcTotalExpense, inDecimalPlaces);
dcTotalIncome = Math.Round(dcTotalIncome, inDecimalPlaces);
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtExpenses"].Value = "Total";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtIncome"].Value = "Total";
decimal dcGrossProfit = 0;
decimal dcGrossLoss = 0;
if (dcTotalExpense > dcTotalIncome)
{
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = dcTotalExpense.ToString();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = dcTotalExpense.ToString();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtIncome"].Value = "Gross Loss b/d ";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtAmount2"].Value = dcTotalExpense - dcTotalIncome;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtAmount2"].Style.ForeColor = Color.Red;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtIncome"].Style.ForeColor = Color.Red;
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtExpenses"].Value = "Gross Loss b/d ";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = dcTotalExpense - dcTotalIncome;
dcGrossLoss = dcTotalExpense - dcTotalIncome;
}
else
{
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = dcTotalIncome.ToString();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = dcTotalIncome.ToString();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtExpenses"].Value = "Gross Profit c/d ";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtAmount1"].Value = dcTotalIncome - dcTotalExpense;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtAmount1"].Style.ForeColor = Color.Green;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtExpenses"].Style.ForeColor = Color.Green;
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtIncome"].Value = "Gross Profit c/d ";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = dcTotalIncome - dcTotalExpense;
dcGrossProfit = dcTotalIncome - dcTotalExpense;
}
dgvProfitAndLoss.Rows.Add();
///------Indirect Expense
dtblFinancial = new DataTable();
dtblFinancial = DsetProfitAndLoss.Tables[4];
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtExpenses"].Value = "Indirect Expenses";
decimal dcIndirectExpense = 0;
if (dtblFinancial.Rows.Count > 0)
{
foreach (DataRow rw in dtblFinancial.Rows)
{
decimal dcBalance = Convert.ToDecimal(rw["Debit"].ToString());
dcIndirectExpense += dcBalance;
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtGroupId1"].Value = "15";
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = dcIndirectExpense.ToString();
///---Indirect Income
dtblFinancial = new DataTable();
dtblFinancial = DsetProfitAndLoss.Tables[5];
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtIncome"].Value = "Indirect Incomes";
decimal dcIndirectIncome = 0m;
if (dtblFinancial.Rows.Count > 0)
{
foreach (DataRow rw in dtblFinancial.Rows)
{
decimal dcBalance = Convert.ToDecimal(rw["Credit"].ToString());
dcIndirectIncome += dcBalance;
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtGroupId2"].Value = "14";
}
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = dcIndirectIncome.ToString();
//---- Calculating Grand total
decimal dcGrandTotalExpense = dcGrossLoss + dcIndirectExpense;
decimal dcGrandTotalIncome = dcGrossProfit + dcIndirectIncome;
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = "_______________________";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = "_______________________";
dgvProfitAndLoss.Rows.Add();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtExpenses"].Value = "Grand Total";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtIncome"].Value = "Grand Total";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].DefaultCellStyle.Font = newFont;
if (dcGrandTotalExpense > dcGrandTotalIncome)
{
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = dcGrandTotalExpense.ToString();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = dcGrandTotalExpense.ToString();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtIncome"].Value = "Net Loss ";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtAmount2"].Value = dcGrandTotalExpense - dcGrandTotalIncome;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtIncome"].Style.ForeColor = Color.Red;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtAmount2"].Style.ForeColor = Color.Red;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].DefaultCellStyle.Font = newFont;
decgranExTotal = dcGrandTotalExpense;
}
else
{
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount1"].Value = dcGrandTotalIncome.ToString();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 1].Cells["dgvtxtAmount2"].Value = dcGrandTotalIncome.ToString();
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtExpenses"].Value = "Net Profit";
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtAmount1"].Value = dcGrandTotalIncome - dcGrandTotalExpense;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtExpenses"].Style.ForeColor = Color.Green;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].Cells["dgvtxtAmount1"].Style.ForeColor = Color.Green;
dgvProfitAndLoss.Rows[dgvProfitAndLoss.Rows.Count - 3].DefaultCellStyle.Font = newFont;
decgranIncTotal = dcGrandTotalIncome;
}
if (dgvProfitAndLoss.Columns.Count > 0)
{
dgvProfitAndLoss.Columns["dgvtxtAmount1"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvProfitAndLoss.Columns["dgvtxtAmount2"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
if (inCurrenRowIndex >= 0 && dgvProfitAndLoss.Rows.Count > 0 && inCurrenRowIndex < dgvProfitAndLoss.Rows.Count)
{
if (dgvProfitAndLoss.Rows[inCurrenRowIndex].Cells[inCurrentColunIndex].Visible)
{
dgvProfitAndLoss.CurrentCell = dgvProfitAndLoss.Rows[inCurrenRowIndex].Cells[inCurrentColunIndex];
}
else
{
dgvProfitAndLoss.CurrentCell = dgvProfitAndLoss.Rows[inCurrenRowIndex].Cells["dgvtxtExpenses"];
}
dgvProfitAndLoss.CurrentCell.Selected = true;
}
inCurrenRowIndex = 0;
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "PAL1:" + ex.Message;
}
}
/// <summary>
/// Function to fill the grid
/// </summary>
public void GridFill()
{
try
{
CurrencyInfo InfoCurrency = new CurrencyInfo();
CurrencySP SpCurrency = new CurrencySP();
InfoCurrency = SpCurrency.CurrencyView(1);
int inDecimalPlaces = InfoCurrency.NoOfDecimalPlaces;
string calculationMethod = string.Empty;
SettingsInfo InfoSettings = new SettingsInfo();
SettingsSP SpSettings = new SettingsSP();
//--------------- Selection Of Calculation Method According To Settings ------------------//
if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
calculationMethod = "FIFO";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
calculationMethod = "Average Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
calculationMethod = "High Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
calculationMethod = "Low Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
calculationMethod = "Last Purchase Rate";
}
StockPostingSP spstock = new StockPostingSP();
decimal decrackId = 0;
DataSet dsstock = new DataSet();
DataTable dtbl = new DataTable();
if (cmbRack.SelectedValue != null)
{
decrackId = Convert.ToDecimal(cmbRack.SelectedValue.ToString());
}
dtbl = spstock.StockReportGridFill1(txtproductName.Text, Convert.ToDecimal(cmbBrand.SelectedValue.ToString()), Convert.ToDecimal(cmbModel.SelectedValue.ToString()), (txtProductCode.Text), Convert.ToDecimal(cmbGodown.SelectedValue.ToString()), decrackId, Convert.ToDecimal(cmbSize.SelectedValue.ToString()), Convert.ToDecimal(cmbTax.SelectedValue.ToString()), Convert.ToDecimal(cmbProductgroup.SelectedValue.ToString()), txtBatchName.Text);
if (dtbl.Rows.Count > 0)
{
decimal decTotal = 0;
for (int i = 0; i < dtbl.Rows.Count; i++)
{
if (dtbl.Rows[i]["stockvalue"].ToString() != string.Empty)
{
decTotal = decTotal + Convert.ToDecimal(dtbl.Rows[i]["stockvalue"].ToString());
}
}
decTotal = Math.Round(decTotal, 2);
txtTotal.Text = decTotal.ToString();
}
else
{
txtTotal.Text = "0.00";
}
dgvStockReport.DataSource = dtbl;
//if (dtbl.Columns.Count > 0)
//{
// dgvStockReport.Columns["stockvalue"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
//}
}
catch (Exception ex)
{
MessageBox.Show("STKR:8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to set the calculation method by checking the settings
/// </summary>
public void CalculationMethod()
{
try
{
SettingsInfo InfoSettings = new SettingsInfo();
SettingsSP SpSettings = new SettingsSP();
//--------------- Selection Of Calculation Method According To Settings ------------------//
if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
calculationMethod = "FIFO";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
calculationMethod = "Average Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
calculationMethod = "High Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
calculationMethod = "Low Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
calculationMethod = "Last Purchase Rate";
}
}
catch (Exception ex)
{
MessageBox.Show("AGR:6" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to return amount in words
/// </summary>
/// <param name="decAmount"></param>
/// <param name="decCurrId"></param>
/// <returns></returns>
public string AmountWords(decimal decAmount, decimal decCurrId)
{
string AountInWords = string.Empty; // To return the amount in words
CurrencyInfo currencyInfo = new CurrencySP().CurrencyView(decCurrId);
decAmount = Math.Round(decAmount, currencyInfo.NoOfDecimalPlaces); //Rounding according to decimal places of currency
string strAmount = decAmount.ToString(); // Just keeping the whole amount as string for performing split operation on it
string strAmountinwordsOfIntiger = string.Empty; // To hold amount in words of intiger
string strAmountInWordsOfDecimal = string.Empty; // To hold amoutn in words of decimal part
string[] strPartsArray = strAmount.Split('.'); // Splitting with "." to get intiger part and decimal part seperately
string strDecimaPart = string.Empty; // To hold decimal part
if (strPartsArray.Length > 1)
{
if (strPartsArray[1] != null)
{
strDecimaPart = strPartsArray[1]; // Holding decimal portion if any
}
}
if (strPartsArray[0] != null)
{
strAmount = strPartsArray[0]; // Holding intiger part of amount
}
else
{
strAmount = string.Empty;
};
if (strAmount.Trim() != string.Empty && decimal.Parse(strAmount) != 0)
{
strAmountinwordsOfIntiger = NumberToText(long.Parse(strAmount));
}
if (strDecimaPart.Trim() != string.Empty && decimal.Parse(strDecimaPart) != 0)
{
strAmountInWordsOfDecimal = NumberToText(long.Parse(strDecimaPart));
}
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("ShowCurrencySymbol") != "Yes")
{
// Showing currency as suffix
if (strAmountinwordsOfIntiger != string.Empty)
{
AountInWords = strAmountinwordsOfIntiger + " " + currencyInfo.CurrencyName;
}
if (strAmountInWordsOfDecimal != string.Empty)
{
AountInWords = AountInWords + " and " + strAmountInWordsOfDecimal + " " + currencyInfo.SubunitName;
}
AountInWords = AountInWords + " only";
}
else
{
// Showing currency as prefix
if (strAmountinwordsOfIntiger != string.Empty)
{
AountInWords = currencyInfo.CurrencyName + " " + strAmountinwordsOfIntiger;
}
if (strAmountInWordsOfDecimal != string.Empty)
{
AountInWords = AountInWords + " and " + currencyInfo.SubunitName + " " + strAmountInWordsOfDecimal;
}
AountInWords = AountInWords + " only";
}
return(AountInWords);
}
/// <summary>
/// Function to check Negative Stock at the time of saving and updating
/// </summary>
public bool SaveOrEditCheck()
{
bool isOk = false;
try
{
decimal decProductId = 0;
decimal decBatchId = 0;
decimal decCalcQty = 0;
StockPostingSP spStockPosting = new StockPostingSP();
SettingsSP spSettings = new SettingsSP();
string strStatus = spSettings.SettingsStatusCheck("NegativeStockStatus");
bool isNegativeLedger = false;
DataTable dtblPurchaseMasterViewById = new DataTable();
PurchaseReturnMasterSP SPPurchaseReturnMaster = new PurchaseReturnMasterSP();
dgvPurchaseReturn.ClearSelection();
int inRow = dgvPurchaseReturn.RowCount;
if (txtReturnNo.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Enter Return number");
txtReturnNo.Focus();
}
else if (SPPurchaseReturnMaster.PurchaseReturnNumberCheckExistence(txtReturnNo.Text.Trim(), decPurchaseReturnVoucherTypeId) == true && btnSave.Text == "Save")
{
Messages.InformationMessage("Return number already exist");
txtReturnNo.Focus();
}
else if ((btnSave.Text == "Update") && (txtReturnNo.Text != strReturnNo) && (SPPurchaseReturnMaster.PurchaseReturnNumberCheckExistence(txtReturnNo.Text.Trim(), decPurchaseReturnVoucherTypeId) == true))
{
Messages.InformationMessage("Return number already exist");
txtReturnNo.Focus();
}
else if (txtDate.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Select a date in between financial year");
txtDate.Focus();
}
else if (cmbInvoiceNo.Visible == true && cmbInvoiceNo.SelectedValue == null)
{
Messages.InformationMessage("Select a invoice no");
cmbInvoiceNo.Focus();
}
else
{
if (RemoveIncompleteRowsFromGrid())
{
int inRowCount = dgvPurchaseReturn.RowCount;
if (inRowCount > 1)
{
for (int i = 0; i < inRowCount - 1; i++)
{
if (dgvPurchaseReturn.Rows[i].Cells["dgvtxtproductId"].Value != null && dgvPurchaseReturn.Rows[i].Cells["dgvtxtproductId"].Value.ToString() != string.Empty)
{
decProductId = Convert.ToDecimal(dgvPurchaseReturn.Rows[i].Cells["dgvtxtproductId"].Value.ToString());
if (dgvPurchaseReturn.Rows[i].Cells["dgvcmbBatch"].Value != null && dgvPurchaseReturn.Rows[i].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
decBatchId = Convert.ToDecimal(dgvPurchaseReturn.Rows[i].Cells["dgvcmbBatch"].Value.ToString());
}
decimal decCurrentStock = spStockPosting.StockCheckForProductSale(decProductId, decBatchId);
if (dgvPurchaseReturn.Rows[i].Cells["dgvtxtqty"].Value != null && dgvPurchaseReturn.Rows[i].Cells["dgvtxtqty"].Value.ToString() != string.Empty)
{
decCalcQty = decCurrentStock - Convert.ToDecimal(dgvPurchaseReturn.Rows[i].Cells["dgvtxtqty"].Value.ToString());
}
if (decCalcQty < 0)
{
isNegativeLedger = true;
break;
}
}
}
if (isNegativeLedger)
{
if (strStatus == "Warn")
{
if (MessageBox.Show("Negative Stock balance exists,Do you want to Continue", "Open miracle", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
isOk = true;
}
}
else if (strStatus == "Block")
{
MessageBox.Show("Cannot continue ,due to negative stock balance", "Open miracle", MessageBoxButtons.OK, MessageBoxIcon.Stop);
isOk = false;
}
else
{
isOk = true;
}
}
else
{
isOk = true;
}
}
else
{
isOk = false;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PR:48" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return isOk;
}
/// <summary>
/// Function to check invalid entries in production grid
/// </summary>
/// <param name="e"></param>
public void CheckInvalidEntriesProduction(DataGridViewCellEventArgs e)
{
try
{
SettingsSP spSettings = new SettingsSP();
if (dgvProduction.CurrentRow != null)
{
if (!isValueChanged)
{
if (dgvProduction.CurrentRow.Cells["dgvtxtProductionProductName"].Value == null || dgvProduction.CurrentRow.Cells["dgvtxtProductionProductName"].Value.ToString().Trim() == string.Empty)
{
isValueChanged = true;
dgvProduction.CurrentRow.HeaderCell.Value = "X";
dgvProduction.CurrentRow.HeaderCell.Style.ForeColor = Color.Red;
}
else if (dgvProduction.CurrentRow.Cells["dgvtxtProductionQty"].Value == null || dgvProduction.CurrentRow.Cells["dgvtxtProductionQty"].Value.ToString().Trim() == string.Empty || Convert.ToDecimal(dgvProduction.CurrentRow.Cells["dgvtxtProductionQty"].Value) == 0)
{
isValueChanged = true;
dgvProduction.CurrentRow.HeaderCell.Value = "X";
dgvProduction.CurrentRow.HeaderCell.Style.ForeColor = Color.Red;
}
else if (spSettings.SettingsStatusCheck("AllowZeroValueEntry") == "No" && Convert.ToDecimal(dgvProduction.CurrentRow.Cells["dgvtxtProductionRate"].Value) == 0)
{
dgvProduction.CurrentRow.HeaderCell.Value = "X";
dgvProduction.CurrentRow.HeaderCell.Style.ForeColor = Color.Red;
}
else
{
isValueChanged = true;
dgvProduction.CurrentRow.HeaderCell.Value = string.Empty;
}
}
isValueChanged = false;
}
}
catch (Exception ex)
{
MessageBox.Show("SJ:42" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Save and Edit
/// </summary>
public void SaveOrEdit()
{
try
{
PurchaseMasterSP SPPurchaseMaster = new PurchaseMasterSP();
PurchaseReturnMasterSP SPPurchaseReturnMaster = new PurchaseReturnMasterSP();
PurchaseReturnDetailsSP SPPurchaseReturnDetails = new PurchaseReturnDetailsSP();
PurchaseReturnDetailsInfo infoPurchaseReturnDetails = new PurchaseReturnDetailsInfo();
StockPostingInfo infoStockPosting = new StockPostingInfo();
StockPostingSP spStockPosting = new StockPostingSP();
UnitConvertionSP SPUnitConversion = new UnitConvertionSP();
LedgerPostingSP spLedgerPosting = new LedgerPostingSP();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
PartyBalanceSP spPartyBalance = new PartyBalanceSP();
PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo();
AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo();
AccountLedgerSP spAccountLedger = new AccountLedgerSP();
PurchaseReturnBilltaxInfo infoPurchaseReturnBillTax = new PurchaseReturnBilltaxInfo();
PurchaseReturnBilltaxSP spPurchaseReturnBillTax = new PurchaseReturnBilltaxSP();
SettingsSP spSettings = new SettingsSP();
UnitSP spUnit = new UnitSP();
DataTable dtblPurchaseMasterViewById = new DataTable();
string strAgainstVoucherNo = string.Empty;
string strAgainstInvoiceNo = string.Empty;
decimal decPurchaseReturnMasterIds = 0;
decimal decPurchaseMasterId = 0;
decimal decDiscount = 0;
decimal decExchangeRate = 0;
decimal decDis = 0;
if (isAutomatic)
{
if (strVoucherNo != string.Empty)
{
infoPurchaseReturnMaster.VoucherNo = strVoucherNo;
}
if (txtReturnNo.Text != string.Empty)
{
infoPurchaseReturnMaster.InvoiceNo = txtReturnNo.Text;
}
}
else
{
infoPurchaseReturnMaster.VoucherNo = strVoucherNo;
infoPurchaseReturnMaster.InvoiceNo = txtReturnNo.Text;
}
if (decPurchaseReturnVoucherTypeId != 0)
{
infoPurchaseReturnMaster.VoucherTypeId = decPurchaseReturnVoucherTypeId;
}
infoPurchaseReturnMaster.SuffixPrefixId = (decPurchaseReturnSuffixPrefixId != 0) ? decPurchaseReturnSuffixPrefixId : 0;
infoPurchaseReturnMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoPurchaseReturnMaster.PurchaseAccount = Convert.ToDecimal(cmbPurchaseAccount.SelectedValue.ToString());
if (cmbInvoiceNo.SelectedValue != null && cmbInvoiceNo.Visible == true)
{
infoPurchaseReturnMaster.PurchaseMasterId = Convert.ToDecimal((cmbInvoiceNo.SelectedValue.ToString()));
decPurchaseMasterId = Convert.ToDecimal((cmbInvoiceNo.SelectedValue.ToString()));
}
else
{
infoPurchaseReturnMaster.PurchaseMasterId = 0;
}
infoPurchaseReturnMaster.ExchangeRateId = (cmbCurrency.SelectedValue != null) ? Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()) : 0;
infoPurchaseReturnMaster.Narration = txtNarration.Text.Trim();
infoPurchaseReturnMaster.UserId = PublicVariables._decCurrentUserId;
infoPurchaseReturnMaster.LrNo = txtLrlNo.Text.Trim();
infoPurchaseReturnMaster.TransportationCompany = txtTransportationCompany.Text.Trim();
infoPurchaseReturnMaster.Date = Convert.ToDateTime(txtDate.Text);
infoPurchaseReturnMaster.TotalAmount = (txtTotalAmount.Text != string.Empty) ? Convert.ToDecimal(txtTotalAmount.Text) : 0;
infoPurchaseReturnMaster.TotalTax = (lblTaxAmount.Text != string.Empty) ? Convert.ToDecimal(lblTaxAmount.Text) : 0;
infoPurchaseReturnMaster.Discount = (txtBillDiscount.Text != string.Empty) ? Convert.ToDecimal(txtBillDiscount.Text) : 0;
infoPurchaseReturnMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPurchaseReturnMaster.Extra1 = string.Empty;
infoPurchaseReturnMaster.Extra2 = string.Empty;
infoPurchaseReturnMaster.ExtraDate = DateTime.Now;
infoPurchaseReturnMaster.GrandTotal = (txtGrandTotal.Text != string.Empty) ? Convert.ToDecimal(txtGrandTotal.Text) : 0;
if (btnSave.Text == "Save")
{
decPurchaseReturnMasterIds = SPPurchaseReturnMaster.PurchaseReturnMasterAddWithReturnIdentity(infoPurchaseReturnMaster);
}
else
{
infoPurchaseReturnMaster.PurchaseReturnMasterId = decPurchaseReturnMasterId;
decExchangeRate = spExchangeRate.ExchangeRateViewByExchangeRateId(infoPurchaseReturnMaster.ExchangeRateId);
SPPurchaseReturnMaster.PurchaseReturnMasterEdit(infoPurchaseReturnMaster);
infoPurchaseMaster = SPPurchaseMaster.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
spLedgerPosting.LedgerPostDelete(strVoucherNo, decPurchaseReturnVoucherTypeId);
spAccountLedger.PartyBalanceDeleteByVoucherTypeVoucherNoAndReferenceType(strVoucherNo, decPurchaseReturnVoucherTypeId);
}
infoLedgerPosting.Date = infoPurchaseReturnMaster.Date;
infoLedgerPosting.VoucherTypeId = infoPurchaseReturnMaster.VoucherTypeId;
infoLedgerPosting.VoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.InvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.LedgerId = infoPurchaseReturnMaster.PurchaseAccount;
infoLedgerPosting.Debit = 0;
if (btnSave.Text == "Save")
{
infoLedgerPosting.Credit = TotalNetAmountCalculation() * spExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.ExtraDate = DateTime.Now;
}
else
{
infoLedgerPosting.Credit = TotalNetAmountCalculation();
}
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
infoLedgerPosting.LedgerId = infoPurchaseReturnMaster.LedgerId;
if (btnSave.Text == "Save")
{
infoLedgerPosting.Debit = Convert.ToDecimal(txtGrandTotal.Text) * spExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.ExtraDate = DateTime.Now;
}
else
{
infoLedgerPosting.Debit = Convert.ToDecimal(txtGrandTotal.Text);
}
infoLedgerPosting.Credit = 0;
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
foreach (DataGridViewRow dgvrow in dgvPurchaseReturnTax.Rows)
{
if (dgvrow.Cells["dgvtxtTaxId"].Value != null && dgvrow.Cells["dgvtxtTaxId"].Value.ToString() != string.Empty)
{
infoLedgerPosting.LedgerId = Convert.ToDecimal(dgvrow.Cells["dgvtxtledgerId"].Value.ToString());
infoLedgerPosting.Credit = (dgvrow.Cells["dgvtxtAmounts"].Value == null) ? 0 : Convert.ToDecimal(dgvrow.Cells["dgvtxtAmounts"].Value.ToString());
infoLedgerPosting.Debit = 0;
infoLedgerPosting.ExtraDate = DateTime.Now;
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
if (txtBillDiscount.Text.Trim() != string.Empty)
{
decDis = Convert.ToDecimal(txtBillDiscount.Text);
}
if (decDis >= 0)
{
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = decDis;
infoLedgerPosting.LedgerId = 9;
infoLedgerPosting.ExtraDate = DateTime.Now;
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
if (btnSave.Text == "Update")
{
infoPurchaseReturnMaster = SPPurchaseReturnMaster.PurchaseReturnMasterView(decPurchaseReturnMasterId);
if (infoPurchaseReturnMaster.PurchaseMasterId == 0)
{
spStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(0, "NA", infoPurchaseReturnMaster.VoucherNo, infoPurchaseReturnMaster.VoucherTypeId);
}
if (infoPurchaseReturnMaster.PurchaseMasterId != 0)
{
infoPurchaseMaster = SPPurchaseMaster.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
spStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(infoPurchaseMaster.VoucherTypeId, strInvoiceNo, strVoucherNo, infoPurchaseReturnMaster.VoucherTypeId);
}
}
foreach (DataGridViewRow dgvrow in dgvPurchaseReturn.Rows)
{
if (dgvrow.Cells["dgvtxtProductId"].Value != null && dgvrow.Cells["dgvtxtProductId"].Value.ToString() != string.Empty)
{
infoPurchaseReturnDetails.ExtraDate = DateTime.Now;
infoPurchaseReturnDetails.Extra1 = string.Empty;
infoPurchaseReturnDetails.Extra2 = string.Empty;
infoPurchaseReturnDetails.PurchaseReturnMasterId = (btnSave.Text == "Save") ? decPurchaseReturnMasterIds : decPurchaseReturnMasterId;
infoPurchaseReturnDetails.ProductId = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtproductId"].Value));
infoPurchaseReturnDetails.Qty = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtqty"].Value));
infoPurchaseReturnDetails.Rate = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtrate"].Value));
if (btnSave.Text == "Save")
{
infoPurchaseReturnDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
infoPurchaseReturnDetails.UnitConversionId = SPUnitConversion.UnitconversionIdViewByUnitIdAndProductId(infoPurchaseReturnDetails.UnitId, infoPurchaseReturnDetails.ProductId);
}
else
{
if (Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value) == 0)
{
try
{
infoPurchaseReturnDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
}
catch
{
infoPurchaseReturnDetails.UnitId = spUnit.UnitIdByUnitName(Convert.ToString(dgvrow.Cells["dgvcmbUnit"].Value.ToString()));
}
infoPurchaseReturnDetails.UnitConversionId = SPUnitConversion.UnitconversionIdViewByUnitIdAndProductId(infoPurchaseReturnDetails.UnitId, infoPurchaseReturnDetails.ProductId);
}
else
{
try
{
infoPurchaseReturnDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
}
catch
{
infoPurchaseReturnDetails.UnitId = spUnit.UnitIdByUnitName(Convert.ToString(dgvrow.Cells["dgvcmbUnit"].Value.ToString()));
}
}
infoPurchaseReturnDetails.UnitConversionId = Convert.ToDecimal(dgvrow.Cells["dgvtxtUnitConversionId"].Value);
}
infoPurchaseReturnDetails.Discount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtdiscount"].Value));
if (dgvrow.Cells["dgvcmbTax"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbTax"].Value) != string.Empty && dgvrow.Cells["dgvcmbTax"].Value as string != "NA")
{
infoPurchaseReturnDetails.TaxId = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvcmbTax"].Value));
if (strTaxComboFill != string.Empty)
{
infoPurchaseReturnDetails.TaxAmount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtTaxAmount"].Value));
}
}
else
{
infoPurchaseReturnDetails.TaxId = 0;
}
if (dgvrow.Cells["dgvcmbBatch"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbBatch"].Value) != string.Empty)
{
infoPurchaseReturnDetails.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value);
}
else
{
infoPurchaseReturnDetails.GodownId = 0;
}
if (dgvrow.Cells["dgvcmbGodown"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbGodown"].Value) != string.Empty)
{
infoPurchaseReturnDetails.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value);
}
else
{
infoPurchaseReturnDetails.RackId = 0;
}
if (dgvrow.Cells["dgvcmbRack"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbRack"].Value) != string.Empty)
{
infoPurchaseReturnDetails.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value);
}
infoPurchaseReturnDetails.GrossAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtgrossValue"].Value.ToString());
infoPurchaseReturnDetails.NetAmount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtNetAmount"].Value));
infoPurchaseReturnDetails.Amount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtAmount"].Value));
infoPurchaseReturnDetails.SlNo = Convert.ToInt32(Convert.ToString(dgvrow.Cells["dgvtxtSlNo"].Value));
infoPurchaseReturnDetails.PurchaseDetailsId = (dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value != null) ? Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value)) : 0;
if (dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value != null)
{
if (dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value.ToString() == "0" || dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value.ToString() == string.Empty)
{
SPPurchaseReturnDetails.PurchaseReturnDetailsAddWithReturnIdentity(infoPurchaseReturnDetails);
}
else
{
infoPurchaseReturnDetails.PurchaseReturnDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value.ToString());
SPPurchaseReturnDetails.PurchaseReturnDetailsEdit(infoPurchaseReturnDetails);
}
}
else
{
SPPurchaseReturnDetails.PurchaseReturnDetailsAddWithReturnIdentity(infoPurchaseReturnDetails);
}
if (btnSave.Text == "Save")
{
infoPurchaseMaster = SPPurchaseMaster.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
}
infoStockPosting.Date = infoPurchaseReturnMaster.Date;
infoStockPosting.ProductId = infoPurchaseReturnDetails.ProductId;
infoStockPosting.BatchId = infoPurchaseReturnDetails.BatchId;
infoStockPosting.UnitId = infoPurchaseReturnDetails.UnitId;
infoStockPosting.GodownId = infoPurchaseReturnDetails.GodownId;
infoStockPosting.RackId = infoPurchaseReturnDetails.RackId;
decimal decConversionId = SPUnitConversion.UnitConversionRateByUnitConversionId(infoPurchaseReturnDetails.UnitConversionId);
//infoStockPosting.OutwardQty = infoPurchaseReturnDetails.Qty / (decConversionId == 0 ? 1 : decConversionId);
infoStockPosting.OutwardQty = infoPurchaseReturnDetails.Qty;
infoStockPosting.InwardQty = 0;
infoStockPosting.Rate = infoPurchaseReturnDetails.Rate;
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
if (infoPurchaseReturnDetails.PurchaseDetailsId != 0)
{
infoStockPosting.AgainstVoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.AgainstVoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.AgainstInvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.InvoiceNo = txtReturnNo.Text.Trim();
infoStockPosting.VoucherTypeId = decPurchaseReturnVoucherTypeId;
decAgainstVoucherTypeId = infoStockPosting.VoucherTypeId;
}
else
{
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.VoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoStockPosting.InvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoStockPosting.VoucherTypeId = decPurchaseReturnVoucherTypeId;
decAgainstVoucherTypeId = 0;
}
spStockPosting.StockPostingAdd(infoStockPosting);
}
}
if (btnSave.Text == "Update")
{
removePurchaseReturnDetails();
}
infoAccountLedger = spAccountLedger.AccountLedgerView(infoPurchaseReturnMaster.LedgerId);
if (infoAccountLedger.BillByBill == true)
{
infoPartyBalance.Date = infoPurchaseReturnMaster.Date;
infoPartyBalance.LedgerId = infoPurchaseReturnMaster.LedgerId;
if (decAgainstVoucherTypeId != 0)
{
infoPartyBalance.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoPartyBalance.VoucherNo = infoPurchaseMaster.VoucherNo;
infoPartyBalance.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoPartyBalance.AgainstVoucherTypeId = infoPurchaseReturnMaster.VoucherTypeId;
infoPartyBalance.AgainstVoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoPartyBalance.AgainstInvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoPartyBalance.ReferenceType = "Against";
}
else
{
infoPartyBalance.VoucherTypeId = infoPurchaseReturnMaster.VoucherTypeId;
infoPartyBalance.VoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoPartyBalance.InvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoPartyBalance.AgainstVoucherTypeId = 0;
infoPartyBalance.AgainstVoucherNo = "NA";
infoPartyBalance.AgainstInvoiceNo = "NA";
infoPartyBalance.ReferenceType ="New";
}
infoPartyBalance.Debit = infoPurchaseReturnMaster.TotalAmount;
infoPartyBalance.Credit = 0;
infoPartyBalance.CreditPeriod = 0;
infoPartyBalance.ExchangeRateId = infoPurchaseReturnMaster.ExchangeRateId;
infoPartyBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPartyBalance.Extra1 = string.Empty;
infoPartyBalance.Extra2 = string.Empty;
spPartyBalance.PartyBalanceAdd(infoPartyBalance);
}
foreach (DataGridViewRow item in dgvPurchaseReturnTax.Rows)
{
if (item.Cells["dgvtxtTaxId"].Value != null)
{
infoPurchaseReturnBillTax.PurchaseReturnMasterId = (btnSave.Text == "Save") ? decPurchaseReturnMasterIds : decPurchaseReturnMasterIds;
infoPurchaseReturnBillTax.TaxId = Convert.ToDecimal(item.Cells["dgvtxtTaxId"].Value.ToString());
infoPurchaseReturnBillTax.TaxAmount = (item.Cells["dgvtxtAmounts"].Value == null) ? 0 : Convert.ToDecimal(item.Cells["dgvtxtAmounts"].Value.ToString());
infoPurchaseReturnBillTax.Extra1 = string.Empty;
infoPurchaseReturnBillTax.Extra2 = string.Empty;
spPurchaseReturnBillTax.PurchaseReturnBilltaxAdd(infoPurchaseReturnBillTax);
}
}
if (btnSave.Text == "Save")
{
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPurchaseReturnMasterIds);
}
else
{
Print(decPurchaseReturnMasterIds);
}
}
Clear();
}
else
{
decDiscount = Convert.ToDecimal(txtBillDiscount.Text);
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPurchaseReturnMasterId);
}
else
{
Print(decPurchaseReturnMasterId);
}
}
if (frmPurchaseReturnRegisterObj != null)
{
frmPurchaseReturnRegisterObj.GridFill();
frmPurchaseReturnRegisterObj.Enabled = true;
}
if (ObjPurchaseReturnReport != null)
{
ObjPurchaseReturnReport.PurchaseReturnReportGridFill();
ObjPurchaseReturnReport.Enabled = true;
}
if (frmLedgerDetailsObj != null)
{
frmLedgerDetailsObj.LedgerDetailsView();
frmLedgerDetailsObj.Enabled = true;
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("PR:49" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save Function
/// </summary>
public void SaveFunction()
{
try
{
DeliveryNoteMasterInfo infoDeliveryNoteMaster = new DeliveryNoteMasterInfo();
DeliveryNoteDetailsInfo infoDeliveryNoteDetails = new DeliveryNoteDetailsInfo();
StockPostingInfo infoStockPosting = new StockPostingInfo();
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>
/// Function for Settings Status Check
/// </summary>
public void PurchaseReturnSettingsCheck()
{
SettingsSP spSettings = new SettingsSP();
try
{
dgvPurchaseReturn.Columns["dgvcmbGodown"].Visible = (spSettings.SettingsStatusCheck("AllowGodown") == "Yes") ? true : false;
dgvPurchaseReturn.Columns["dgvCmbRack"].Visible = (spSettings.SettingsStatusCheck("AllowRack") == "Yes") ? true : false;
dgvPurchaseReturn.Columns["dgvcmbBatch"].Visible = (spSettings.SettingsStatusCheck("AllowBatch") == "Yes") ? true : false;
dgvPurchaseReturn.Columns["dgvtxtBarcode"].Visible = (spSettings.SettingsStatusCheck("Barcode") == "Yes") ? true : false;
dgvPurchaseReturn.Columns["dgvcmbUnit"].Visible = (spSettings.SettingsStatusCheck("ShowUnit") == "Yes") ? true : false;
dgvPurchaseReturn.Columns["dgvtxtproductCode"].Visible = (spSettings.SettingsStatusCheck("ShowProductCode") == "Yes") ? true : false;
dgvPurchaseReturn.Columns["dgvtxtdiscount"].Visible = (spSettings.SettingsStatusCheck("ShowDiscountAmount") == "Yes") ? true : false;
dgvPurchaseReturn.Columns["dgvtxtrate"].Visible = (spSettings.SettingsStatusCheck("ShowPurchaseRate") == "Yes") ? true : false;
cbxPrintAfterSave.Checked = (spSettings.SettingsStatusCheck("TickPrintAfterSave") == "Yes") ? true : false;
if (spSettings.SettingsStatusCheck("Tax") == "Yes")
{
dgvcmbTax.Visible = true;
dgvPurchaseReturnTax.Visible = true;
lblTotalTaxAmount.Visible = true;
lblTaxAmount.Visible = true;
lblTotalTaxAmount.Visible = true;
dgvtxttaxAmount.Visible = true;
}
else
{
dgvcmbTax.Visible = false;
dgvPurchaseReturnTax.Visible = false;
lblTaxAmount.Visible = false;
lblTaxAmount.Visible = false;
lblTotalTaxAmount.Visible = false;
dgvtxttaxAmount.Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("PR:16 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Checking the settings and arrange the form controlls based on settings
/// </summary>
public void SalesInvoiceSettingsCheck()
{
SettingsSP spSettings = new SettingsSP();
try
{
cmbCashOrbank.Visible = false;
lblcashOrBank.Visible = false;
if (spSettings.SettingsStatusCheck("AllowGodown") == "Yes")
{
dgvSalesInvoice.Columns["dgvcmbSalesInvoiceGodown"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvcmbSalesInvoiceGodown"].Visible = false;
}
if (spSettings.SettingsStatusCheck("AllowRack") == "Yes")
{
dgvSalesInvoice.Columns["dgvcmbSalesInvoiceRack"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvcmbSalesInvoiceRack"].Visible = false;
}
if (spSettings.SettingsStatusCheck("ShowBrand") == "Yes")
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceBrand"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceBrand"].Visible = false;
}
if (spSettings.SettingsStatusCheck("ShowSalesRate") == "yes")
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceSalesRate"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceSalesRate"].Visible = false;
}
if (spSettings.SettingsStatusCheck("ShowMRP") == "Yes")
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceMrp"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceMrp"].Visible = false;
}
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
cmbCurrency.Enabled = true;
}
else
{
cmbCurrency.Enabled = false;
}
if (spSettings.SettingsStatusCheck("ShowUnit") == "Yes")
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoicembUnitName"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoicembUnitName"].Visible = false;
}
if (spSettings.SettingsStatusCheck("ShowDiscountAmount") == "Yes")
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceDiscountAmount"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceDiscountAmount"].Visible = false;
}
if (spSettings.SettingsStatusCheck("ShowProductCode") == "Yes")
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceProductCode"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceProductCode"].Visible = false;
}
if (spSettings.SettingsStatusCheck("Barcode") == "Yes")
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceBarcode"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceBarcode"].Visible = false;
}
if (spSettings.SettingsStatusCheck("ShowDiscountPercentage") == "Yes")
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceDiscountPercentage"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceDiscountPercentage"].Visible = false;
}
if (spSettings.SettingsStatusCheck("AllowBatch") == "Yes")
{
dgvSalesInvoice.Columns["dgvcmbSalesInvoiceBatch"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvcmbSalesInvoiceBatch"].Visible = false;
}
if (spSettings.SettingsStatusCheck("ShowPurchaseRate") == "Yes")
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoicePurchaseRate"].Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvtxtSalesInvoicePurchaseRate"].Visible = false;
}
if (spSettings.SettingsStatusCheck("Tax") == "Yes")
{
dgvSalesInvoice.Columns["dgvcmbSalesInvoiceTaxName"].Visible = true;
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceTaxAmount"].Visible = true;
dgvSalesInvoiceTax.Visible = true;
lblTaxTotal.Visible = true;
lblTaxTotalAmount.Visible = true;
}
else
{
dgvSalesInvoice.Columns["dgvcmbSalesInvoiceTaxName"].Visible = false;
dgvSalesInvoice.Columns["dgvtxtSalesInvoiceTaxAmount"].Visible = false;
dgvSalesInvoiceTax.Visible = false;
lblTaxTotal.Visible = false;
lblTaxTotalAmount.Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("SI : 02" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save the sales quatation
/// </summary>
public void SaveFunction()
{
SalesQuotationDetailsSP SpSalesQuotationDetails = new SalesQuotationDetailsSP();
SalesQuotationMasterSP SpSalesQuotationMaster = new SalesQuotationMasterSP();
SalesQuotationMasterInfo infoSalesQuotationMaster = new SalesQuotationMasterInfo();
SalesQuotationDetailsInfo infoSalesQuotationDetails = new SalesQuotationDetailsInfo();
SettingsSP spSettings = new SettingsSP();
ProductSP spProduct = new ProductSP();
ProductInfo infoproduct = new ProductInfo();
try
{
infoSalesQuotationMaster.Date = Convert.ToDateTime(txtSalesQuotationDate.Text);
infoSalesQuotationMaster.PricinglevelId = Convert.ToDecimal(cmbPricinglevel.SelectedValue.ToString());
infoSalesQuotationMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoSalesQuotationMaster.EmployeeId = Convert.ToDecimal(cmbSalesman.SelectedValue.ToString());
if (isAutomatic)
{
infoSalesQuotationMaster.SuffixPrefixId = decSalesQuotationPreffixSuffixId;
infoSalesQuotationMaster.VoucherNo = strSalesQuotationNo;
}
else
{
infoSalesQuotationMaster.SuffixPrefixId = 0;
infoSalesQuotationMaster.VoucherNo = SpSalesQuotationMaster.VoucherNoMax(decsalesQuotationTypeId);
}
infoSalesQuotationMaster.VoucherTypeId = decsalesQuotationTypeId;
infoSalesQuotationMaster.InvoiceNo = txtQuotationNo.Text;
infoSalesQuotationMaster.EmployeeId = Convert.ToDecimal(cmbSalesman.SelectedValue.ToString());
infoSalesQuotationMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoSalesQuotationMaster.userId = PublicVariables._decCurrentUserId;
infoSalesQuotationMaster.TotalAmount = Convert.ToDecimal(txtTotal.Text);
infoSalesQuotationMaster.Narration = txtNarration.Text.Trim();
infoSalesQuotationMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoSalesQuotationMaster.Extra1 = string.Empty;
infoSalesQuotationMaster.Extra2 = string.Empty;
if (cbxApproved.Checked)
{
infoSalesQuotationMaster.Approved = true;
}
else
{
infoSalesQuotationMaster.Approved = false;
}
decSalesQuotationmasterIdentity = Convert.ToDecimal(SpSalesQuotationMaster.SalesQuotationMasterAdd(infoSalesQuotationMaster));
int inRowcount = dgvProduct.Rows.Count;
for (int inI = 0; inI < inRowcount - 1; inI++)
{
infoSalesQuotationDetails.QuotationMasterId = decSalesQuotationmasterIdentity;
if (dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString() != string.Empty)
{
infoproduct = spProduct.ProductViewByCode(dgvProduct.Rows[inI].Cells["dgvtxtProductCode"].Value.ToString());
infoSalesQuotationDetails.ProductId = infoproduct.ProductId;
}
if (dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value != null && dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString() != string.Empty)
{
infoSalesQuotationDetails.Qty = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtQty"].Value.ToString());
}
if (dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString() != string.Empty)
{
infoSalesQuotationDetails.UnitId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbUnit"].Value.ToString());
decimal unitConversion = SpSalesQuotationDetails.UnitconversionIdViewByUnitIdAndProductId(infoSalesQuotationDetails.UnitId, infoSalesQuotationDetails.ProductId);
infoSalesQuotationDetails.UnitConversionId = unitConversion;
}
if (dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value != null && dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value.ToString() != string.Empty)
{
infoSalesQuotationDetails.BatchId = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvcmbBatch"].Value);
}
else
{
infoSalesQuotationDetails.BatchId = 0;
}
infoSalesQuotationDetails.Rate = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
infoSalesQuotationDetails.Amount = Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoSalesQuotationDetails.Slno = Convert.ToInt32(dgvProduct.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
infoSalesQuotationDetails.Extra1 = string.Empty;
infoSalesQuotationDetails.Extra2 = string.Empty;
SpSalesQuotationDetails.SalesQuotationDetailsAdd(infoSalesQuotationDetails);
}
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
if (dgvProduct.Rows.Count > 0)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesQuotationmasterIdentity);
}
else
{
Print(decSalesQuotationmasterIdentity);
}
}
else
{
Messages.InformationMessage("No data found");
}
}
Clear();
}
catch (Exception ex)
{
MessageBox.Show("SQ:32" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save function
/// </summary>
public void SaveFunction()
{
SalesMasterSP spSalesMaster = new SalesMasterSP();
SalesDetailsSP spSalesDetails = new SalesDetailsSP();
StockPostingInfo infoStockPosting = new StockPostingInfo();
SalesMasterInfo InfoSalesMaster = new SalesMasterInfo();
SalesDetailsInfo InfoSalesDetails = new SalesDetailsInfo();
StockPostingSP spStockPosting = new StockPostingSP();
AdditionalCostInfo infoAdditionalCost = new AdditionalCostInfo();
AdditionalCostSP spAdditionalCost = new AdditionalCostSP();
SalesBillTaxInfo infoSalesBillTax = new SalesBillTaxInfo();
SalesBillTaxSP spSalesBillTax = new SalesBillTaxSP();
UnitConvertionSP SPUnitConversion = new UnitConvertionSP();
try
{
InfoSalesMaster.AdditionalCost = Convert.ToDecimal(lblLedgerTotalAmount.Text);
InfoSalesMaster.BillDiscount = Convert.ToDecimal(txtBillDiscount.Text.Trim());
InfoSalesMaster.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text.Trim().ToString());
InfoSalesMaster.CustomerName = txtCustomer.Text.Trim();
InfoSalesMaster.Date = Convert.ToDateTime(txtDate.Text.ToString());
InfoSalesMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
InfoSalesMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
InfoSalesMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoSalesMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text.Trim());
InfoSalesMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
InfoSalesMaster.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
if (isAutomatic)
{
InfoSalesMaster.InvoiceNo = txtInvoiceNo.Text.Trim();
InfoSalesMaster.VoucherNo = strVoucherNo;
InfoSalesMaster.SuffixPrefixId = decSalseInvoiceSuffixPrefixId;
}
else
{
InfoSalesMaster.InvoiceNo = txtInvoiceNo.Text.Trim();
InfoSalesMaster.VoucherNo = strVoucherNo;
InfoSalesMaster.SuffixPrefixId = 0;
}
if (cmbSalesMode.Text == "Against SalesOrder")
{
InfoSalesMaster.OrderMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.OrderMasterId = 0;
}
if (cmbSalesMode.Text == "Against Delivery Note")
{
InfoSalesMaster.DeliveryNoteMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.DeliveryNoteMasterId = 0;
}
if (cmbSalesMode.Text == "Against Quotation")
{
InfoSalesMaster.QuotationMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.QuotationMasterId = 0;
}
InfoSalesMaster.Narration = txtNarration.Text.Trim();
InfoSalesMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
InfoSalesMaster.SalesAccount = Convert.ToDecimal(cmbSalesAccount.SelectedValue.ToString());
InfoSalesMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text.Trim());
if (dgvSalesInvoice.Columns["dgvcmbSalesInvoiceTaxName"].Visible)
{
InfoSalesMaster.TaxAmount = Convert.ToDecimal(lblTaxTotalAmount.Text.Trim());
}
else
{
InfoSalesMaster.TaxAmount = 0;
}
InfoSalesMaster.UserId = PublicVariables._decCurrentUserId;
InfoSalesMaster.LrNo = txtVehicleNo.Text;
InfoSalesMaster.TransportationCompany = txtTransportCompany.Text.Trim();
InfoSalesMaster.POS = false;
InfoSalesMaster.CounterId = 0;
InfoSalesMaster.ExtraDate = DateTime.Now;
InfoSalesMaster.Extra1 = string.Empty;
InfoSalesMaster.Extra2 = string.Empty;
decimal decSalesMasterId = spSalesMaster.SalesMasterAdd(InfoSalesMaster);
int inRowCount = dgvSalesInvoice.RowCount;
InfoSalesDetails.SalesMasterId = decSalesMasterId;
InfoSalesDetails.ExtraDate = DateTime.Now;
InfoSalesDetails.Extra1 = string.Empty;
InfoSalesDetails.Extra2 = string.Empty;
string strAgainstInvoiceN0 = txtInvoiceNo.Text.Trim();
for (int inI = 0; inI < inRowCount - 1; inI++)
{
if (dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceProductName"].Value != null && dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceProductName"].Value.ToString() != string.Empty)
{
if (dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceQty"].Value != null && dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceQty"].Value.ToString() != string.Empty)
{
if (cmbSalesMode.Text == "Against SalesOrder")
{
InfoSalesDetails.OrderDetailsId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSISalesOrderDetailsId"].Value.ToString());
}
else
{
InfoSalesDetails.OrderDetailsId = 0;
}
if (cmbSalesMode.Text == "Against Delivery Note")
{
InfoSalesDetails.DeliveryNoteDetailsId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceDeliveryNoteDetailsId"].Value.ToString());
}
else
{
InfoSalesDetails.DeliveryNoteDetailsId = 0;
}
if (cmbSalesMode.Text == "Against Quotation")
{
InfoSalesDetails.QuotationDetailsId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceQuotationDetailsId"].Value.ToString());
}
else
{
InfoSalesDetails.QuotationDetailsId = 0;
}
InfoSalesDetails.SlNo = Convert.ToInt32(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceSlno"].Value.ToString());
InfoSalesDetails.ProductId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceProductId"].Value.ToString());
InfoSalesDetails.Qty = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceQty"].Value.ToString());
InfoSalesDetails.Rate = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceRate"].Value.ToString());
InfoSalesDetails.UnitId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoicembUnitName"].Value.ToString());
InfoSalesDetails.UnitConversionId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceUnitConversionId"].Value.ToString());
InfoSalesDetails.Discount = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceDiscountAmount"].Value.ToString());
InfoSalesDetails.BatchId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceBatch"].Value.ToString());
if (dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceGodown"].Value != null && dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceGodown"].Value.ToString() != string.Empty)
{
InfoSalesDetails.GodownId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceGodown"].Value.ToString());
}
else
{
InfoSalesDetails.GodownId = 0;
}
if (dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceRack"].Value != null && dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceRack"].Value.ToString() != string.Empty)
{
InfoSalesDetails.RackId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceRack"].Value.ToString());
}
else
{
InfoSalesDetails.RackId = 0;
}
if (dgvSalesInvoice.Columns["dgvcmbSalesInvoiceTaxName"].Visible)
{
InfoSalesDetails.TaxId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceTaxName"].Value.ToString());
InfoSalesDetails.TaxAmount = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceTaxAmount"].Value.ToString());
}
else
{
InfoSalesDetails.TaxId = 1;
InfoSalesDetails.TaxAmount = 0;
}
InfoSalesDetails.GrossAmount = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceGrossValue"].Value.ToString());
InfoSalesDetails.NetAmount = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceNetAmount"].Value.ToString());
InfoSalesDetails.Amount = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceAmount"].Value.ToString());
spSalesDetails.SalesDetailsAdd(InfoSalesDetails);
infoStockPosting.Date = Convert.ToDateTime(txtDate.Text.Trim().ToString());
infoStockPosting.ProductId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceProductId"].Value.ToString());
infoStockPosting.BatchId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceBatch"].Value.ToString());
infoStockPosting.UnitId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoicembUnitName"].Value.ToString());
if (dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceGodown"].Value != null && dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceGodown"].Value.ToString() != string.Empty)
{
infoStockPosting.GodownId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceGodown"].Value.ToString());
}
else
{
infoStockPosting.GodownId = 0;
}
if (dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceRack"].Value != null && dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceRack"].Value.ToString() != string.Empty)
{
infoStockPosting.RackId = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvcmbSalesInvoiceRack"].Value.ToString());
}
else
{
infoStockPosting.RackId = 0;
}
infoStockPosting.Rate = Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceRate"].Value.ToString());
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.ExtraDate = DateTime.Now;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
if (dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceDeliveryNoteDetailsId"].Value != null)
{
if (Convert.ToDecimal(dgvSalesInvoice.Rows[inI].Cells["dgvtxtSalesInvoiceDeliveryNoteDetailsId"].Value.ToString()) != 0)
{
infoStockPosting.InwardQty = InfoSalesDetails.Qty / SPUnitConversion.UnitConversionRateByUnitConversionId(InfoSalesDetails.UnitConversionId);
infoStockPosting.OutwardQty = 0;
infoStockPosting.VoucherNo = strVoucherNoTostockPost;
infoStockPosting.AgainstVoucherNo = strVoucherNo;
infoStockPosting.InvoiceNo = strInvoiceNoTostockPost;
infoStockPosting.AgainstInvoiceNo = strAgainstInvoiceN0;
infoStockPosting.VoucherTypeId = decVouchertypeIdTostockPost;
infoStockPosting.AgainstVoucherTypeId = DecSalesInvoiceVoucherTypeId;
spStockPosting.StockPostingAdd(infoStockPosting);
}
}
infoStockPosting.InwardQty = 0;
infoStockPosting.OutwardQty = InfoSalesDetails.Qty / SPUnitConversion.UnitConversionRateByUnitConversionId(InfoSalesDetails.UnitConversionId);
infoStockPosting.VoucherNo = InfoSalesMaster.VoucherNo; ;
infoStockPosting.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoStockPosting.InvoiceNo = InfoSalesMaster.InvoiceNo;
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
spStockPosting.StockPostingAdd(infoStockPosting);
}
}
}
if (dgvSalesInvoice.Columns["dgvcmbSalesInvoiceTaxName"].Visible)
{
int inTaxRowCount = dgvSalesInvoiceTax.RowCount;
infoSalesBillTax.SalesMasterId = decSalesMasterId;
infoSalesBillTax.ExtraDate = DateTime.Now;
infoSalesBillTax.Extra1 = string.Empty;
infoSalesBillTax.Extra2 = string.Empty;
for (int inI = 0; inI < inTaxRowCount; inI++)
{
if (dgvSalesInvoiceTax.Rows[inI].Cells["dgvtxtTtaxId"].Value != null && dgvSalesInvoiceTax.Rows[inI].Cells["dgvtxtTtaxId"].Value.ToString() != string.Empty)
{
if (dgvSalesInvoiceTax.Rows[inI].Cells["dgvtxtTtaxAmount"].Value != null && dgvSalesInvoiceTax.Rows[inI].Cells["dgvtxtTtaxAmount"].Value.ToString() != string.Empty)
{
decimal decAmount = Convert.ToDecimal(dgvSalesInvoiceTax.Rows[inI].Cells["dgvtxtTtaxAmount"].Value);
if (decAmount > 0)
{
infoSalesBillTax.TaxId = Convert.ToInt32(dgvSalesInvoiceTax.Rows[inI].Cells["dgvtxtTtaxId"].Value.ToString());
infoSalesBillTax.TaxAmount = Convert.ToDecimal(dgvSalesInvoiceTax.Rows[inI].Cells["dgvtxtTtaxAmount"].Value.ToString());
spSalesBillTax.SalesBillTaxAdd(infoSalesBillTax);
}
}
}
}
}
int inAddRowCount = dgvSalesInvoiceLedger.RowCount;
infoAdditionalCost.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoAdditionalCost.VoucherNo = strVoucherNo;
infoAdditionalCost.ExtraDate = DateTime.Now;
infoAdditionalCost.Extra1 = string.Empty;
infoAdditionalCost.Extra2 = string.Empty;
for (int inI = 0; inI < inAddRowCount; inI++)
{
if (dgvSalesInvoiceLedger.Rows[inI].Cells["dgvCmbAdditionalCostledgerName"].Value != null && dgvSalesInvoiceLedger.Rows[inI].Cells["dgvCmbAdditionalCostledgerName"].Value.ToString() != string.Empty)
{
if (dgvSalesInvoiceLedger.Rows[inI].Cells["dgvtxtAdditionalCoastledgerAmount"].Value != null && dgvSalesInvoiceLedger.Rows[inI].Cells["dgvtxtAdditionalCoastledgerAmount"].Value.ToString() != string.Empty)
{
infoAdditionalCost.LedgerId = Convert.ToInt32(dgvSalesInvoiceLedger.Rows[inI].Cells["dgvCmbAdditionalCostledgerName"].Value.ToString());
if (!cmbCashOrbank.Visible)
{
infoAdditionalCost.Debit = 0;
infoAdditionalCost.Credit = Convert.ToDecimal(dgvSalesInvoiceLedger.Rows[inI].Cells["dgvtxtAdditionalCoastledgerAmount"].Value.ToString());
}
else
{
infoAdditionalCost.Debit = Convert.ToDecimal(dgvSalesInvoiceLedger.Rows[inI].Cells["dgvtxtAdditionalCoastledgerAmount"].Value.ToString());
infoAdditionalCost.Credit = 0;
}
spAdditionalCost.AdditionalCostAdd(infoAdditionalCost);
}
}
}
if (!cmbCashOrbank.Visible)
{
decimal decCAshOrBankId = 0;
decCAshOrBankId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
decimal decTotalAddAmount = Convert.ToDecimal(lblLedgerTotalAmount.Text.Trim().ToString());
if (decTotalAddAmount > 0)
{
infoAdditionalCost.Debit = decTotalAddAmount;
infoAdditionalCost.Credit = 0;
infoAdditionalCost.LedgerId = decCAshOrBankId;
infoAdditionalCost.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoAdditionalCost.VoucherNo = strVoucherNo;
infoAdditionalCost.ExtraDate = DateTime.Now;
infoAdditionalCost.Extra1 = string.Empty;
infoAdditionalCost.Extra2 = string.Empty;
spAdditionalCost.AdditionalCostAdd(infoAdditionalCost);
}
}
else
{
if (cmbCashOrbank.Visible)
{
decimal decCAshOrBankId = 0;
decCAshOrBankId = Convert.ToDecimal(cmbCashOrbank.SelectedValue.ToString());
decimal decTotalAddAmount = Convert.ToDecimal(lblLedgerTotalAmount.Text.Trim().ToString());
if (decTotalAddAmount > 0)
{
infoAdditionalCost.Debit = 0;
infoAdditionalCost.Credit = decTotalAddAmount;
infoAdditionalCost.LedgerId = decCAshOrBankId;
infoAdditionalCost.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoAdditionalCost.VoucherNo = strVoucherNo;
infoAdditionalCost.ExtraDate = DateTime.Now;
infoAdditionalCost.Extra1 = string.Empty;
infoAdditionalCost.Extra2 = string.Empty;
spAdditionalCost.AdditionalCostAdd(infoAdditionalCost);
}
}
}
ledgerPostingAdd();
if (spSalesMaster.SalesInvoiceInvoicePartyCheckEnableBillByBillOrNot(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString())))
{
partyBalanceAdd();
}
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked == true)
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesMasterId);
}
else
{
Print(decSalesMasterId);
}
}
Clear();
}
catch (Exception ex)
{
MessageBox.Show("SI: 70" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to edit the SalesQuatation
/// </summary>
public void EditFunction()
{
SalesQuotationDetailsSP SpSalesQuotationDetails = new SalesQuotationDetailsSP();
SalesQuotationMasterInfo infoSalesQuotationMaster = new SalesQuotationMasterInfo();
SalesQuotationMasterSP SpSalesQuotationMaster = new SalesQuotationMasterSP();
SettingsSP spSettings = new SettingsSP();
try
{
for (int inI = 0; inI < dgvProduct.Rows.Count - 1; inI++)
{
if (Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtquotationDetailsId"].Value) != 0)
{
isEditDetails = Convert.ToString(SpSalesQuotationDetails.SalesQuotationRefererenceCheckForEditDetails(Convert.ToDecimal(dgvProduct.Rows[inI].Cells["dgvtxtquotationDetailsId"].Value)));
}
}
isEditMaster = Convert.ToString(SpSalesQuotationMaster.SalesQuotationRefererenceCheckForEditMaster(decSalesquotationMasterId));
if (isEditMaster == "False" && isEditDetails == "False")
{
infoSalesQuotationMaster.QuotationMasterId = decSalesquotationMasterId;
infoSalesQuotationMaster.Date = Convert.ToDateTime(txtSalesQuotationDate.Text);
infoSalesQuotationMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoSalesQuotationMaster.SuffixPrefixId = Convert.ToDecimal(decSalesQuotationPreffixSuffixId);
infoSalesQuotationMaster.VoucherNo = strVoucherNo;
infoSalesQuotationMaster.VoucherTypeId = decSalesQuotationVoucherId;
infoSalesQuotationMaster.InvoiceNo = txtQuotationNo.Text;
infoSalesQuotationMaster.userId = PublicVariables._decCurrentUserId;//by default current userid used as current user id
infoSalesQuotationMaster.EmployeeId = Convert.ToDecimal(cmbSalesman.SelectedValue.ToString());
infoSalesQuotationMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoSalesQuotationMaster.Narration = txtNarration.Text.Trim();
infoSalesQuotationMaster.TotalAmount = Convert.ToDecimal(txtTotal.Text);
infoSalesQuotationMaster.PricinglevelId = Convert.ToDecimal(cmbPricinglevel.SelectedValue.ToString());
infoSalesQuotationMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
if (cbxApproved.Checked)
{
infoSalesQuotationMaster.Approved = true;
}
else
{
infoSalesQuotationMaster.Approved = false;
}
infoSalesQuotationMaster.Extra1 = string.Empty;
infoSalesQuotationMaster.Extra2 = string.Empty;
SpSalesQuotationMaster.SalesQuotationMasterEdit(infoSalesQuotationMaster);
RemoveSalesQuotationDetails();
NewRowAddedToSalesQuotationDetails();
SalesQuotationDetailsEditFill();
Messages.UpdatedMessage();
if (frmSalesQuotationRegisterObj != null)
{
if (cbxPrintAfterSave.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesquotationMasterId);
}
else
{
Print(decSalesquotationMasterId);
}
}
this.Close();
frmSalesQuotationRegisterObj.GridFill();
}
if (frmSalesQuotationReportObj != null)
{
if (cbxPrintAfterSave.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesquotationMasterId);
}
else
{
Print(decSalesquotationMasterId);
}
}
this.Close();
frmSalesQuotationReportObj.GridFill();
}
if (frmDayBookObj != null)
{
if (cbxPrintAfterSave.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesquotationMasterId);
}
else
{
Print(decSalesquotationMasterId);
}
}
this.Close();
}
if (objfrmVoucherSearch != null)
{
if (cbxPrintAfterSave.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesquotationMasterId);
}
else
{
Print(decSalesquotationMasterId);
}
}
this.Close();
}
if (objVoucherSearch != null)
{
if (cbxPrintAfterSave.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesquotationMasterId);
}
else
{
Print(decSalesquotationMasterId);
}
}
this.Close();
}
}
else
{
Messages.ReferenceExistsMessageForUpdate();
}
}
catch (Exception ex)
{
MessageBox.Show("SQ:33" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to call the SaveOrEditFunction after checking negative balance
/// </summary>
public void SaveOrEdit()
{
try
{
if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, this.Name, btnSave.Text))
{
JournalMasterSP spJournalMaster = new JournalMasterSP();
//=====================================================
SettingsSP spSettings = new SettingsSP();
string strStatus = spSettings.SettingsStatusCheck("NegativeCashTransaction");
decimal decBalance = 0;
decimal decCalcAmount = 0;
AccountLedgerSP spAccountLedger = new AccountLedgerSP();
bool isNegativeLedger = false;
int inRowCount = dgvJournalVoucher.RowCount;
for (int i = 0; i < inRowCount - 1; i++)
{
decimal decledgerId = 0;
if (dgvJournalVoucher.Rows[i].Cells["dgvcmbAccountLedger"].Value != null && dgvJournalVoucher.Rows[i].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
decledgerId = Convert.ToDecimal(dgvJournalVoucher.Rows[i].Cells["dgvcmbAccountLedger"].Value.ToString());
decBalance = spAccountLedger.CheckLedgerBalance(decledgerId);
if (dgvJournalVoucher.Rows[i].Cells["dgvtxtAmount"].Value != null && dgvJournalVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString() != string.Empty)
{
decCalcAmount = decBalance - Convert.ToDecimal(dgvJournalVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString());
}
if (decCalcAmount < 0)
{
isNegativeLedger = true;
break;
}
}
}
//=========================================
if (isNegativeLedger)
{
if (strStatus == "Warn")
{
if (MessageBox.Show("Negative balance exists,Do you want to Continue", "Open miracle", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
SaveOrEditFunction();
}
}
else if (strStatus == "Block")
{
MessageBox.Show("Cannot continue ,due to negative balance", "Open miracle", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else
{
SaveOrEditFunction();
}
}
else
{
SaveOrEditFunction();
}
}
else
{
Messages.NoPrivillageMessage();
}
}
catch (Exception ex)
{
MessageBox.Show("JV18:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to check the settings for grid
/// </summary>
public void SalesQuotationSettingsCheck()
{
try
{
ShowBarcode();
ShowProductCode();
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
cmbCurrency.Enabled = true;
}
else
{
cmbCurrency.Enabled = false;
}
if (!ShowProductCode())
{
this.dgvProduct.Columns["dgvtxtProductCode"].Visible = false;
}
else
{
this.dgvProduct.Columns["dgvtxtProductCode"].Visible = true;
}
if (!ShowBarcode())
{
this.dgvProduct.Columns["dgvtxtBarcode"].Visible = false;
}
else
{
this.dgvProduct.Columns["dgvtxtBarcode"].Visible = true; ;
}
if (PrintAfetrSave())
{
cbxPrintAfterSave.Checked = true;
}
else
{
cbxPrintAfterSave.Checked = false;
}
if (spSettings.SettingsStatusCheck("AllowBatch") == "Yes")
{
this.dgvProduct.Columns["dgvcmbBatch"].Visible = true;
}
else
{
this.dgvProduct.Columns["dgvcmbBatch"].Visible = false;
}
if (spSettings.SettingsStatusCheck("ShowUnit") == "Yes")
{
this.dgvProduct.Columns["dgvcmbUnit"].Visible = true;
}
else
{
this.dgvProduct.Columns["dgvcmbUnit"].Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("SQ:38" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Currency Combofill function
/// </summary>
public void GridCurrencyComboFill()
{
try
{
DataTable dtbl = new DataTable();
TransactionsGeneralFill Obj = new TransactionsGeneralFill();
dtbl = Obj.CurrencyComboByDate(Convert.ToDateTime(txtDate.Text));
DataRow dr = dtbl.NewRow();
dr["exchangeRateId"] = "0";
dr["currencyName"] = string.Empty;
dtbl.Rows.InsertAt(dr, 0);
dgvcmbCurrency.DataSource = dtbl;
dgvcmbCurrency.DisplayMember = "currencyName";
dgvcmbCurrency.ValueMember = "exchangeRateId";
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
dgvcmbCurrency.ReadOnly = false;
}
else
{
dgvcmbCurrency.ReadOnly = true;
}
}
catch (Exception ex)
{
MessageBox.Show("PV5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Currency combo fill
/// </summary>
public void ComboCurrencyFill()
{
TransactionsGeneralFill transactionGeneralFillObj = new TransactionsGeneralFill();
SettingsSP SpSettings = new SettingsSP();
try
{
DataTable dtbl = new DataTable();
dtbl = transactionGeneralFillObj.CurrencyComboByDate(Convert.ToDateTime(txtSalesQuotationDate.Text));
cmbCurrency.DataSource = dtbl;
cmbCurrency.DisplayMember = "currencyName";
cmbCurrency.ValueMember = "exchangeRateId";
cmbCurrency.SelectedValue = 1m;
DataRow dr = dtbl.NewRow();
if (SpSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
cmbCurrency.Enabled = true;
}
else
{
cmbCurrency.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show("SQ:13" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Printing checkbox status checking
/// </summary>
public void PrintCheck()
{
try
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("TickPrintAfterSave") == "Yes")
{
cbxPrintafterSave.Checked = true;
}
else
{
cbxPrintafterSave.Checked = false;
}
}
catch (Exception ex)
{
MessageBox.Show("PV2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to clear
/// </summary>
public void Clear()
{
try
{
SettingsSP spSettings = new SettingsSP();
txtCustomerName.Text = string.Empty;
txtMailingName.Text = string.Empty;
txtOpeningBalance.Text = "0.00";
cmbDrorCr.Text = "Dr";
txtAccountNo.Text = string.Empty;
txtBranchName.Text = string.Empty;
txtBranchCode.Text = string.Empty;
txtMobile.Text = string.Empty;
txtphone.Text = string.Empty;
txtAddress.Text = string.Empty;
txtEmail.Text = string.Empty;
if (spSettings.SettingsStatusCheck("BillByBill") == "Yes")
{
cmbBillbyBill.Enabled = true;
cmbBillbyBill.Text = "No";
}
else
{
cmbBillbyBill.Enabled = false;
}
cmbBillbyBill.Text = "No";
cmbPricingLevel.SelectedIndex = 0;
txtCreditLimit.Text = string.Empty;
txtCreditPeriod.Text = string.Empty;
txtTin.Text = string.Empty;
txtPan.Text = string.Empty;
txtCST.Text = string.Empty;
txtCustomerName.Focus();
cmbArea.SelectedIndex = 0;
txtNarration.Text = string.Empty; ;
cmbRoute.SelectedIndex = 0;
txtCustomerNameSearch.Text = string.Empty;
cmbAreaSearch.SelectedIndex = 0;
cmbRoutSearch.SelectedIndex = 0;
btnDelete.Enabled = false;
btnSave.Text = "Save";
GridFill();
}
catch (Exception ex)
{
MessageBox.Show("Cus12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void FillGrid()
{
try
{
if (!isFormLoad)
{
DateValidation objValidation = new DateValidation();
objValidation.DateValidationFunction(txtToDate);
if (txtToDate.Text == string.Empty)
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
}
Font newFont = new Font(dgvReport.Font, FontStyle.Bold);
CurrencyInfo InfoCurrency = new CurrencyInfo();
CurrencySP SpCurrency = new CurrencySP();
InfoCurrency = SpCurrency.CurrencyView(1);
int inDecimalPlaces = InfoCurrency.NoOfDecimalPlaces;
dgvReport.Rows.Clear();
FinancialStatementSP SpFinance = new FinancialStatementSP();
DataSet DsetBalanceSheet = new DataSet();
DataTable dtbl = new DataTable();
SettingsInfo InfoSettings = new SettingsInfo();
SettingsSP SpSettings = new SettingsSP();
//--------------- Selection Of Calculation Method According To Settings ------------------//
if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
calculationMethod = "FIFO";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
calculationMethod = "Average Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
calculationMethod = "High Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
calculationMethod = "Low Cost";
}
else if (SpSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
calculationMethod = "Last Purchase Rate";
}
DsetBalanceSheet = SpFinance.BalanceSheet(PublicVariables._dtFromDate, DateTime.Parse(txtToDate.Text));
//------------------- Asset -------------------------------//
dtbl = DsetBalanceSheet.Tables[0];
foreach (DataRow rw in dtbl.Rows)
{
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Value = rw["Name"].ToString();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount1"].Value = rw["Balance"].ToString();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["GroupId1"].Value = rw["ID"].ToString();
}
decimal dcTotalAsset = 0;
if (dtbl.Rows.Count > 0)
{
dcTotalAsset = decimal.Parse(dtbl.Compute("Sum(Balance)", string.Empty).ToString());
}
//------------------------ Liability ---------------------//
dtbl = new DataTable();
dtbl = DsetBalanceSheet.Tables[1];
int index = 0;
foreach (DataRow rw in dtbl.Rows)
{
if (index < dgvReport.Rows.Count)
{
dgvReport.Rows[index].Cells["dgvtxtLiability"].Value = rw["Name"].ToString();
dgvReport.Rows[index].Cells["Amount2"].Value = rw["Balance"].ToString();
dgvReport.Rows[index].Cells["GroupId2"].Value = rw["ID"].ToString();
}
else
{
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Value = rw["Name"].ToString();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount2"].Value = rw["Balance"].ToString();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["GroupId2"].Value = rw["ID"].ToString();
}
index++;
}
decimal dcTotalLiability = 0;
if (dtbl.Rows.Count > 0)
{
dcTotalLiability = decimal.Parse(dtbl.Compute("Sum(Balance)", string.Empty).ToString());
}
decimal dcClosingStock = SpFinance.StockValueGetOnDate(Convert.ToDateTime(txtToDate.Text), calculationMethod, false, false);
dcClosingStock = Math.Round(dcClosingStock, inDecimalPlaces);
//---------------------Opening Stock---------------------------------------------------------------------------------------------------------------
decimal dcOpeninggStock = SpFinance.StockValueGetOnDate(PublicVariables._dtFromDate, calculationMethod, true, true);
decimal dcProfit = 0;
DataSet dsetProfitAndLoss = new DataSet();
dsetProfitAndLoss = SpFinance.ProfitAndLossAnalysisUpToaDateForBalansheet(PublicVariables._dtFromDate, DateTime.Parse(txtToDate.Text));
DataTable dtblProfit = new DataTable();
dtblProfit = dsetProfitAndLoss.Tables[0];
for (int i = 0; i < dsetProfitAndLoss.Tables.Count; ++i)
{
dtbl = dsetProfitAndLoss.Tables[i];
decimal dcSum = 0;
if (i == 0 || (i % 2) == 0)
{
if (dtbl.Rows.Count > 0)
{
dcSum = decimal.Parse(dtbl.Compute("Sum(Debit)", string.Empty).ToString());
dcProfit = dcProfit - dcSum;
}
}
else
{
if (dtbl.Rows.Count > 0)
{
dcSum = decimal.Parse(dtbl.Compute("Sum(Credit)", string.Empty).ToString());
dcProfit = dcProfit + dcSum;
}
}
}
decimal decCurrentProfitLoss = 0;
decCurrentProfitLoss = dcProfit + (dcClosingStock - dcOpeninggStock);
decimal dcProfitOpening = 0;
DataSet dsetProfitAndLossOpening = new DataSet();
dsetProfitAndLossOpening = SpFinance.ProfitAndLossAnalysisUpToaDateForPreviousYears(PublicVariables._dtFromDate);
DataTable dtblProfitOpening = new DataTable();
dtblProfitOpening = dsetProfitAndLossOpening.Tables[0];
for (int i = 0; i < dsetProfitAndLossOpening.Tables.Count; ++i)
{
dtbl = dsetProfitAndLossOpening.Tables[i];
decimal dcSum = 0;
if (i == 0 || (i % 2) == 0)
{
if (dtbl.Rows.Count > 0)
{
dcSum = decimal.Parse(dtbl.Compute("Sum(Debit)", string.Empty).ToString());
dcProfitOpening = dcProfitOpening - dcSum;
}
}
else
{
if (dtbl.Rows.Count > 0)
{
dcSum = decimal.Parse(dtbl.Compute("Sum(Credit)", string.Empty).ToString());
dcProfitOpening = dcProfitOpening + dcSum;
}
}
}
DataTable dtblProfitLedgerOpening = new DataTable();
dtblProfitLedgerOpening = DsetBalanceSheet.Tables[3];
decimal decProfitLedgerOpening = 0;
foreach (DataRow dRow in dtblProfitLedgerOpening.Rows)
{
decProfitLedgerOpening += decimal.Parse(dRow["Balance"].ToString());
}
DataTable dtblProf = new DataTable();
dtblProf = DsetBalanceSheet.Tables[2];
decimal decProfitLedger = 0;
if (dtblProf.Rows.Count > 0)
{
decProfitLedger = decimal.Parse(dtblProf.Compute("Sum(Balance)", string.Empty).ToString());
}
decimal decTotalProfitAndLoss = 0;
if (dcProfitOpening >= 0)
{
decTotalProfitAndLoss = decProfitLedger;
}
else if (dcProfitOpening < 0)
{
decTotalProfitAndLoss = decProfitLedger;
}
index = 0;
if (dcClosingStock >= 0)
{
//---------- Asset ----------//
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Value = "Closing Stock";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount1"].Value = Math.Round(dcClosingStock, inDecimalPlaces);
dcTotalAsset += dcClosingStock;
}
else
{
//--------- Liability ---------//
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Value = "Closing Stock";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount2"].Value = -(Math.Round(dcClosingStock, inDecimalPlaces));
dcTotalLiability += -dcClosingStock;
}
dgvReport.Rows.Add();
decimal decOpeningOfProfitAndLoss = decProfitLedgerOpening + dcProfitOpening;
decimal decTotalProfitAndLossOverAll = decTotalProfitAndLoss + decOpeningOfProfitAndLoss + decCurrentProfitLoss;
if (decTotalProfitAndLossOverAll <= 0)
{
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Value = "----------------------------------------";
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
foreach (DataRow dRow in dtblProf.Rows)
{
if (dRow["Name"].ToString() == "Profit And Loss Account")
{
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Value = dRow["Name"].ToString();
if (decCurrentProfitLoss < 0)
{
decCurrentProfitLoss = decCurrentProfitLoss * -1;
}
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount1"].Value = Math.Round(decTotalProfitAndLoss + decCurrentProfitLoss, PublicVariables._inNoOfDecimalPlaces);
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["GroupId1"].Value = dRow["ID"].ToString();
}
}
//-------------- Asset ---------------//
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Value = "Profit And Loss (Opening)";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount1"].Value = Math.Round(decTotalProfitAndLoss, PublicVariables._inNoOfDecimalPlaces);
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount1"].Style.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Style.ForeColor = Color.DarkSlateGray;
//-------------- Asset ---------------//
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Value = "Current Period";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount1"].Value = Math.Round(decCurrentProfitLoss, PublicVariables._inNoOfDecimalPlaces);
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount1"].Style.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Style.ForeColor = Color.DarkSlateGray;
dcTotalAsset = dcTotalAsset + (decCurrentProfitLoss + decTotalProfitAndLoss);
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Value = "----------------------------------------";
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
}
else if (decTotalProfitAndLossOverAll > 0)
{
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Value = "----------------------------------------";
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
foreach (DataRow dRow in dtblProf.Rows)
{
if (dRow["Name"].ToString() == "Profit And Loss Account")
{
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Value = dRow[1].ToString();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount2"].Value = Math.Round(decTotalProfitAndLoss + decCurrentProfitLoss, PublicVariables._inNoOfDecimalPlaces);
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["GroupId2"].Value = dRow[0].ToString();
}
}
//------------ Liability ------------//
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Value = "Profit And Loss (Opening)";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount2"].Value = Math.Round(decTotalProfitAndLoss, inDecimalPlaces);
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount2"].Style.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Style.ForeColor = Color.DarkSlateGray;
dcTotalLiability += decOpeningOfProfitAndLoss;
//------------ Liability ------------//
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Value = "Current Period";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount2"].Value = Math.Round(decCurrentProfitLoss, inDecimalPlaces);
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount2"].Style.ForeColor = Color.DarkSlateGray;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Style.ForeColor = Color.DarkSlateGray;
dcTotalLiability = dcTotalLiability + (decCurrentProfitLoss + decTotalProfitAndLoss); //dcProfit;
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Value = "----------------------------------------";
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
}
dgvReport.Rows.Add();
decimal dcDiffAsset = 0;
decimal dcDiffLiability = 0;
decimal dcTotalValue = dcTotalAsset;
if (dcTotalAsset != dcTotalLiability)
{
if (dcTotalAsset > dcTotalLiability)
{
//--------------- Liability exceeds so in asset side ----------------//
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Value = "Difference";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount2"].Value = Math.Round((dcTotalAsset - dcTotalLiability), inDecimalPlaces);
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.ForeColor = Color.DarkRed;
dcDiffLiability = dcTotalAsset - dcTotalLiability;
}
else
{
//--------------- Asset exceeds so in liability side ----------------//
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Value = "Difference";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount1"].Value = Math.Round((dcTotalLiability - dcTotalAsset), inDecimalPlaces);;
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.ForeColor = Color.DarkRed;
dcDiffAsset = dcTotalLiability - dcTotalAsset;
}
}
dgvReport.Rows.Add();
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount1"].Value = "__________________________";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount2"].Value = "__________________________";
dgvReport.Rows.Add();
dgvReport.Rows[dgvReport.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtLiability"].Value = "Total";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["dgvtxtAsset"].Value = "Total";
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount1"].Value = Math.Round((dcTotalAsset + dcDiffAsset), inDecimalPlaces);
dgvReport.Rows[dgvReport.Rows.Count - 1].Cells["Amount2"].Value = Math.Round((dcTotalLiability + dcDiffLiability), inDecimalPlaces);
if (dgvReport.Columns.Count > 0)
{
dgvReport.Columns["Amount1"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvReport.Columns["Amount2"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
decPrintOrNot = dcTotalAsset + dcDiffAsset;
decPrintOrNot1 = dcTotalLiability + dcDiffLiability;
if (inCurrenRowIndex >= 0 && dgvReport.Rows.Count > 0 && inCurrenRowIndex < dgvReport.Rows.Count)
{
if (dgvReport.Rows[inCurrenRowIndex].Cells[inCurentcolIndex].Visible)
{
dgvReport.CurrentCell = dgvReport.Rows[inCurrenRowIndex].Cells[inCurentcolIndex];
}
if (dgvReport.CurrentCell != null && dgvReport.CurrentCell.Visible)
{
dgvReport.CurrentCell.Selected = true;
}
}
inCurrenRowIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show("BS :1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Checking the general settings before loading the MDI page.
/// This either enables or disables the controls on the form depending on the current settings
/// </summary>
public void SettingsCheck()
{
try
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("Tax") == "Yes")
{
formMDI.MDIObj.taxToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.taxToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("Budget") == "Yes")
{
formMDI.MDIObj.budgetToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.budgetToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
formMDI.MDIObj.payrollToolStripMenuItem.Enabled = true;
formMDI.MDIObj.payrollToolStripMenuItem1.Enabled = true;
foreach (ToolStripMenuItem toolItem in formMDI.MDIObj.payrollToolStripMenuItem1.DropDownItems)
{
toolItem.Enabled = true;
}
}
else
{
formMDI.MDIObj.payrollToolStripMenuItem.Enabled = false;
formMDI.MDIObj.payrollToolStripMenuItem1.Enabled = false;
foreach (ToolStripMenuItem toolItem in formMDI.MDIObj.payrollToolStripMenuItem1.DropDownItems)
{
toolItem.Enabled = false;
}
}
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
formMDI.MDIObj.currencyToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.currencyToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("AllowBatch") == "Yes")
{
formMDI.MDIObj.batchToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.batchToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("AllowSize") == "Yes")
{
formMDI.MDIObj.sizeToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.sizeToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("AllowGodown") == "Yes")
{
formMDI.MDIObj.godownToolStripMenuItem.Enabled = true;
if (spSettings.SettingsStatusCheck("AllowRack") == "Yes")
{
formMDI.MDIObj.rackToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.rackToolStripMenuItem.Enabled = false;
}
}
else
{
formMDI.MDIObj.godownToolStripMenuItem.Enabled = false;
formMDI.MDIObj.rackToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("AllowModelNo") == "Yes")
{
formMDI.MDIObj.modelNumberToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.modelNumberToolStripMenuItem.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show("LOGIN:"******"OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to check settings for stock journal
/// </summary>
public void StockJournalSettingsCheck()
{
try
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("AllowGodown") == "Yes")
{
rbtnTransfer.Enabled = true;
dgvConsumption.Columns["dgvcmbConsumptionGodown"].Visible = true;
dgvProduction.Columns["dgvcmbProductionGodown"].Visible = true;
}
else
{
rbtnTransfer.Enabled = false;
dgvConsumption.Columns["dgvcmbConsumptionGodown"].Visible = false;
dgvProduction.Columns["dgvcmbProductionGodown"].Visible = false;
}
if (spSettings.SettingsStatusCheck("AllowRack") == "Yes")
{
dgvConsumption.Columns["dgvcmbConsumptionRack"].Visible = true;
dgvProduction.Columns["dgvcmbProductionRack"].Visible = true;
}
else
{
dgvConsumption.Columns["dgvcmbConsumptionRack"].Visible = false;
dgvProduction.Columns["dgvcmbProductionRack"].Visible = false;
}
if (spSettings.SettingsStatusCheck("ShowUnit") == "Yes")
{
dgvConsumption.Columns["dgvcmbConsumptionunitId"].Visible = true;
dgvProduction.Columns["dgvcmbProductionunitId"].Visible = true;
}
else
{
dgvConsumption.Columns["dgvcmbConsumptionunitId"].Visible = false;
dgvProduction.Columns["dgvcmbProductionunitId"].Visible = false;
}
if (spSettings.SettingsStatusCheck("ShowProductCode") == "Yes")
{
dgvConsumption.Columns["dgvtxtConsumptionProductCode"].Visible = true;
dgvProduction.Columns["dgvtxtProductionProductCode"].Visible = true;
}
else
{
dgvConsumption.Columns["dgvtxtConsumptionProductCode"].Visible = false;
dgvProduction.Columns["dgvtxtProductionProductCode"].Visible = false;
}
if (spSettings.SettingsStatusCheck("Barcode") == "Yes")
{
dgvConsumption.Columns["dgvtxtConsumptionBarcode"].Visible = true;
dgvProduction.Columns["dgvtxtProductionBarcode"].Visible = true;
}
else
{
dgvConsumption.Columns["dgvtxtConsumptionBarcode"].Visible = false;
dgvProduction.Columns["dgvtxtProductionBarcode"].Visible = false;
}
if (spSettings.SettingsStatusCheck("AllowBatch") == "Yes")
{
dgvConsumption.Columns["dgvcmbConsumptionBatch"].Visible = true;
dgvProduction.Columns["dgvcmbProductionBatch"].Visible = true;
}
else
{
dgvConsumption.Columns["dgvcmbConsumptionBatch"].Visible = false;
dgvProduction.Columns["dgvcmbProductionBatch"].Visible = false;
}
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
cmbCurrency.Enabled = true;
}
else
{
cmbCurrency.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show("SJ:4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Checking the general settings before loading the MDI page.
/// This either enables or disables the controls on the form depending on the current settings
/// </summary>
public void SettingsCheck()
{
try
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("Tax") == "Yes")
{
formMDI.MDIObj.taxToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.taxToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("Budget") == "Yes")
{
formMDI.MDIObj.budgetToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.budgetToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
formMDI.MDIObj.payrollToolStripMenuItem.Enabled = true;
formMDI.MDIObj.payrollToolStripMenuItem1.Enabled = true;
foreach (ToolStripMenuItem toolItem in formMDI.MDIObj.payrollToolStripMenuItem1.DropDownItems)
{
toolItem.Enabled = true;
}
}
else
{
formMDI.MDIObj.payrollToolStripMenuItem.Enabled = false;
formMDI.MDIObj.payrollToolStripMenuItem1.Enabled = false;
foreach (ToolStripMenuItem toolItem in formMDI.MDIObj.payrollToolStripMenuItem1.DropDownItems)
{
toolItem.Enabled = false;
}
}
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
formMDI.MDIObj.currencyToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.currencyToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("AllowBatch") == "Yes")
{
formMDI.MDIObj.batchToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.batchToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("AllowSize") == "Yes")
{
formMDI.MDIObj.sizeToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.sizeToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("AllowGodown") == "Yes")
{
formMDI.MDIObj.godownToolStripMenuItem.Enabled = true;
if (spSettings.SettingsStatusCheck("AllowRack") == "Yes")
{
formMDI.MDIObj.rackToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.rackToolStripMenuItem.Enabled = false;
}
}
else
{
formMDI.MDIObj.godownToolStripMenuItem.Enabled = false;
formMDI.MDIObj.rackToolStripMenuItem.Enabled = false;
}
if (spSettings.SettingsStatusCheck("AllowModelNo") == "Yes")
{
formMDI.MDIObj.modelNumberToolStripMenuItem.Enabled = true;
}
else
{
formMDI.MDIObj.modelNumberToolStripMenuItem.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show("LOGIN:"******"OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// To check the status of the product
/// </summary>
public void QuantityStatusCheck()
{
try
{
int inRowConsumption = dgvConsumption.RowCount;
int inRowProduction = dgvProduction.RowCount;
if (rbtnTransfer.Checked == true)
{
if (inRowConsumption - 1 == 0)
{
Messages.InformationMessage("Can't save Stock Journal without atleast one product with complete details");
dgvConsumption.Focus();
goto Exit;
}
if (inRowProduction - 1 == 0)
{
Messages.InformationMessage("Can't save Stock Journal without atleast one product with complete details");
dgvProduction.Focus();
goto Exit;
}
}
decimal decProductId = 0;
decimal decBatchId = 0;
decimal decCalcQty = 0;
StockPostingSP spStockPosting = new StockPostingSP();
SettingsSP spSettings = new SettingsSP();
string strStatus = spSettings.SettingsStatusCheck("NegativeStockStatus");
bool isNegativeLedger = false;
int inRowCount = dgvConsumption.RowCount;
for (int i = 0; i < inRowCount - 1; i++)
{
if (dgvConsumption.Rows[i].Cells["dgvtxtConsumptionProductId"].Value != null && dgvConsumption.Rows[i].Cells["dgvtxtConsumptionProductId"].Value.ToString() != string.Empty)
{
decProductId = Convert.ToDecimal(dgvConsumption.Rows[i].Cells["dgvtxtConsumptionProductId"].Value.ToString());
if (dgvConsumption.Rows[i].Cells["dgvcmbConsumptionBatch"].Value != null && dgvConsumption.Rows[i].Cells["dgvcmbConsumptionBatch"].Value.ToString() != string.Empty)
{
decBatchId = Convert.ToDecimal(dgvConsumption.Rows[i].Cells["dgvcmbConsumptionBatch"].Value.ToString());
}
decimal decCurrentStock = spStockPosting.StockCheckForProductSale(decProductId, decBatchId);
if (dgvConsumption.Rows[i].Cells["dgvtxtConsumptionQty"].Value != null && dgvConsumption.Rows[i].Cells["dgvtxtConsumptionQty"].Value.ToString() != string.Empty)
{
decCalcQty = decCurrentStock - Convert.ToDecimal(dgvConsumption.Rows[i].Cells["dgvtxtConsumptionQty"].Value.ToString());
}
if (decCalcQty < 0)
{
isNegativeLedger = true;
break;
}
}
}
if (isNegativeLedger)
{
if (strStatus == "Warn")
{
if (MessageBox.Show("Negative Stock balance exists,Do you want to Continue", "Open miracle", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
SaveOrEdit();
}
}
else if (strStatus == "Block")
{
MessageBox.Show("Cannot continue ,due to negative stock balance", "Open miracle", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else
{
SaveOrEdit();
}
}
else
{
SaveOrEdit();
}
Exit: ;
}
catch (Exception ex)
{
MessageBox.Show("SJ:39" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to get the status of settings
/// </summary>
public void CurrentSettings()
{
try
{
SettingsSP spSettings = new SettingsSP();
SettingsInfo infoSettings = new SettingsInfo();
if (spSettings.SettingsStatusCheck("AddConfirmationFor") == "Yes")
{
if (spSettings.SettingsStatusCheck("Add") == "Yes")
{
PublicVariables.isMessageAdd = true;
}
else
{
PublicVariables.isMessageAdd = false;
}
if (spSettings.SettingsStatusCheck("Edit") == "Yes")
{
PublicVariables.isMessageEdit = true;
}
else
{
PublicVariables.isMessageEdit = false;
}
if (spSettings.SettingsStatusCheck("Delete") == "Yes")
{
PublicVariables.isMessageDelete = true;
}
else
{
PublicVariables.isMessageDelete = false;
}
if (spSettings.SettingsStatusCheck("Close") == "Yes")
{
PublicVariables.isMessageClose = true;
}
else
{
PublicVariables.isMessageClose = false;
}
}
else
{
PublicVariables.isMessageAdd = PublicVariables.isMessageClose = PublicVariables.isMessageDelete = PublicVariables.isMessageEdit = false;
}
}
catch (Exception ex)
{
MessageBox.Show("MDI 3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill currency combobox
/// </summary>
public void CurrencyComboFill()
{
SettingsSP spSettings = new SettingsSP();
TransactionsGeneralFill TransactionGeneralFillObj = new TransactionsGeneralFill();
DataTable dtbl = new DataTable();
try
{
dtbl = TransactionGeneralFillObj.CurrencyComboByDate(dtpDate.Value);
cmbCurrency.DataSource = dtbl;
cmbCurrency.DisplayMember = "currencyName";
cmbCurrency.ValueMember = "exchangeRateId";
cmbCurrency.SelectedValue = 1m;
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
cmbCurrency.Enabled = true;
}
else
{
cmbCurrency.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show("SJ:51" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Calls the corresponding voucher on click in Quick Launch menu
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn1_Click(object sender, EventArgs e)
{
this.SendToBack();
Form frmObj = null;
Form open = null;
SettingsSP spSettings = new SettingsSP();
try
{
string str = ((Button)sender).Text;
btnFocus.Focus();
switch (str)
{
case "Contra Voucher":
formMDI.MDIObj.ContraVoucherClick();
break;
case "Payment Voucher":
formMDI.MDIObj.PaymentVoucherClick();
break;
case "Receipt Voucher":
formMDI.MDIObj.ReceiptVoucherClick();
break;
case "Journal Voucher":
formMDI.MDIObj.JournalVoucherClick();
break;
case "Sales Invoice":
formMDI.MDIObj.SalesInvoiceClick();
break;
case "Purchase Invoice":
formMDI.MDIObj.PurchaseInvoiceClick();
break;
case "POS":
formMDI.MDIObj.POSClick();
break;
case "PDC Payable":
formMDI.MDIObj.PDCPayableClick();
break;
case "PDC Receivable":
formMDI.MDIObj.PDCReceivableClick();
break;
case "PDC Clearance":
formMDI.MDIObj.PDCClearenceClick();
break;
case "Bank Reconciliation":
frmObj = new frmBankReconciliation();
open = Application.OpenForms["frmBankReconciliation"] as frmBankReconciliation;
break;
case "Purchase Order":
formMDI.MDIObj.PurchaseOrderClick();
break;
case "Material Reciept":
formMDI.MDIObj.MaterialReceiptClick();
break;
case "Rejection Out":
formMDI.MDIObj.RejectionOutClick();
break;
case "Purchase Return":
formMDI.MDIObj.PurchaseReturnClick();
break;
case "Sales Quotation":
formMDI.MDIObj.SalesQuotationClick();
break;
case "Sales Order":
formMDI.MDIObj.SalesOrderClick();
break;
case "Delivery Note":
formMDI.MDIObj.DeliveryNoteClick();
break;
case "Rejection In":
formMDI.MDIObj.RejectionInClick();
break;
case "Sales Return":
formMDI.MDIObj.SalesReturnClick();
break;
case "Physical Stock":
formMDI.MDIObj.PhysicalStockClick();
break;
case "Service Voucher":
formMDI.MDIObj.ServiceVoucherClick();
break;
case "Credit Note":
formMDI.MDIObj.CreditNoteClick();
break;
case "Debit Note":
formMDI.MDIObj.DebitNoteClick();
break;
case "Stock Journal":
//frmObj = new frmStockJournal();
//open = Application.OpenForms["frmStockJournal"] as frmStockJournal;
formMDI.MDIObj.StockJournalClick();
break;
case "Bill Allocation":
frmObj = new frmBillallocation();
open = Application.OpenForms["frmBillallocation"] as frmBillallocation;
break;
case "Account Group":
frmObj = new frmAccountGroup();
open = Application.OpenForms["frmAccountGroup"] as frmAccountGroup;
break;
case "Account Ledger":
frmObj = new frmAccountLedger();
open = Application.OpenForms["frmAccountLedger"] as frmAccountLedger;
break;
case "Multiple Account Ledgers":
frmObj = new frmmultipleAccountLedger();
open = Application.OpenForms["frmmultipleAccountLedger"] as frmmultipleAccountLedger;
break;
case "Product Group":
frmObj = new frmProductGroup();
open = Application.OpenForms["frmProductGroup"] as frmProductGroup;
break;
case "Product Creation":
frmObj = new frmProductCreation();
open = Application.OpenForms["frmProductCreation"] as frmProductCreation;
break;
case "Multiple Product Creation":
frmObj = new frmMultipleProductCreation();
open = Application.OpenForms["frmMultipleProductCreation"] as frmMultipleProductCreation;
break;
case "Batch":
if (spSettings.SettingsStatusCheck("AllowBatch") == "Yes")
{
frmObj = new frmBatch();
open = Application.OpenForms["frmBatch"] as frmBatch;
}
break;
case "Brand":
frmObj = new frmBrand();
open = Application.OpenForms["frmBrand"] as frmBrand;
break;
case "Model Number":
if (spSettings.SettingsStatusCheck("AllowModelNo") == "Yes")
{
frmObj = new frmModalNo();
open = Application.OpenForms["frmModalNo"] as frmModalNo;
}
break;
case "Size":
if (spSettings.SettingsStatusCheck("AllowSize") == "Yes")
{
frmObj = new frmSize();
open = Application.OpenForms["frmSize"] as frmSize;
}
break;
case "Unit":
frmObj = new frmUnit();
open = Application.OpenForms["frmUnit"] as frmUnit;
break;
case "Godown":
if (spSettings.SettingsStatusCheck("AllowGodown") == "Yes")
{
frmObj = new frmGodown();
open = Application.OpenForms["frmGodown"] as frmGodown;
}
break;
case "Rack":
if (spSettings.SettingsStatusCheck("AllowRack") == "Yes")
{
frmObj = new frmRack();
open = Application.OpenForms["frmRack"] as frmRack;
}
break;
case "Pricing Level":
frmObj = new frmPricingLevel();
open = Application.OpenForms["frmPricingLevel"] as frmPricingLevel;
break;
case "Price List":
frmObj = new frmPriceList();
open = Application.OpenForms["frmPriceList"] as frmPriceList;
break;
case "Standard Rate":
frmObj = new frmStandardRate();
open = Application.OpenForms["frmStandardRate"] as frmStandardRate;
break;
case "Tax":
if (spSettings.SettingsStatusCheck("Tax") == "Yes")
{
frmObj = new frmTax();
open = Application.OpenForms["frmTax"] as frmTax;
}
break;
case "Currency":
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
frmObj = new frmCurrency();
open = Application.OpenForms["frmCurrency"] as frmCurrency;
}
break;
case "Exchange Rate":
frmObj = new frmExchangeRate();
open = Application.OpenForms["frmExchangeRate"] as frmExchangeRate;
break;
case "Service Category":
frmObj = new frmServiceCategory();
open = Application.OpenForms["frmServiceCategory"] as frmServiceCategory;
break;
case "Services":
frmObj = new frmServices();
open = Application.OpenForms["frmServices"] as frmServices;
break;
case "Voucher Type":
frmObj = new frmVoucherType();
open = Application.OpenForms["frmVoucherType"] as frmVoucherType;
break;
case "Area":
frmObj = new frmArea();
open = Application.OpenForms["frmArea"] as frmArea;
break;
case "Route":
frmObj = new frmRoute();
open = Application.OpenForms["frmRoute"] as frmRoute;
break;
case "Counter":
frmObj = new frmCounter();
open = Application.OpenForms["frmCounter"] as frmCounter;
break;
case "Product Register":
frmObj = new frmProductRegister();
open = Application.OpenForms["frmProductRegister"] as frmProductRegister;
break;
case "Salesman":
frmObj = new frmSalesman();
open = Application.OpenForms["frmSalesman"] as frmSalesman;
break;
case "Contra Register":
frmObj = new frmContraRegister();
open = Application.OpenForms["frmContraRegister"] as frmContraRegister;
break;
case "Payment Register":
frmObj = new frmPaymentRegister();
open = Application.OpenForms["frmPaymentRegister"] as frmPaymentRegister;
break;
case "Receipt Register":
frmObj = new frmReceiptRegister();
open = Application.OpenForms["frmReceiptRegister"] as frmReceiptRegister;
break;
case "Journal Register":
frmObj = new frmJournalRegister();
open = Application.OpenForms["frmJournalRegister"] as frmJournalRegister;
break;
case "PDC Payable Register":
frmObj = new frmPDCPayableRegister();
open = Application.OpenForms["frmPDCPayableRegister"] as frmPDCPayableRegister;
break;
case "PDC Receivable Register":
frmObj = new frmPDCReceivableRegister();
open = Application.OpenForms["frmPDCReceivableRegister"] as frmPDCReceivableRegister;
break;
case "PDC Clearance Register":
frmObj = new frmPdcClearanceRegister();
open = Application.OpenForms["frmPdcClearanceRegister"] as frmPdcClearanceRegister;
break;
case "Purchase Order Register":
frmObj = new frmPurchaseOrderRegister();
open = Application.OpenForms["frmPurchaseOrderRegister"] as frmPurchaseOrderRegister;
break;
case "Material Receipt Register":
frmObj = new frmMaterialReceiptRegister();
open = Application.OpenForms["frmMaterialReceiptRegister"] as frmMaterialReceiptRegister;
break;
case "Rejection Out Register":
frmObj = new frmRejectionOutRegister();
open = Application.OpenForms["frmRejectionOutRegister"] as frmRejectionOutRegister;
break;
case "Purchase Invoice Register":
frmObj = new frmPurchaseInvoiceRegister();
open = Application.OpenForms["frmPurchaseInvoiceRegister"] as frmPurchaseInvoiceRegister;
break;
case "Purchase Return Register":
frmObj = new frmPurchaseReturnRegister();
open = Application.OpenForms["frmPurchaseReturnRegister"] as frmPurchaseReturnRegister;
break;
case "Sales Quotation Register":
frmObj = new frmSalesQuotationRegister();
open = Application.OpenForms["frmSalesQuotationRegister"] as frmSalesQuotationRegister;
break;
case "Sales Order Register":
frmObj = new frmSalesOrderRegister();
open = Application.OpenForms["frmSalesOrderRegister"] as frmSalesOrderRegister;
break;
case "Delivery Note Register":
frmObj = new frmDeliveryNoteRegister();
open = Application.OpenForms["frmDeliveryNoteRegister"] as frmDeliveryNoteRegister;
break;
case "Rejection In Register":
frmObj = new frmRejectionInRegister();
open = Application.OpenForms["frmRejectionInRegister"] as frmRejectionInRegister;
break;
case "Sales Invoice Register":
frmObj = new frmSalesInvoiceRegister();
open = Application.OpenForms["frmSalesInvoiceRegister"] as frmSalesInvoiceRegister;
break;
case "Sales Return Register":
frmObj = new frmSalesReturnRegister();
open = Application.OpenForms["frmSalesReturnRegister"] as frmSalesReturnRegister;
break;
case "Physical Stock Register":
frmObj = new frmPhysicalStockRegister();
open = Application.OpenForms["frmPhysicalStockRegister"] as frmPhysicalStockRegister;
break;
case "Service Voucher Register":
frmObj = new frmServiceVoucherRegister();
open = Application.OpenForms["frmServiceVoucherRegister"] as frmServiceVoucherRegister;
break;
case "Credit Note Register":
frmObj = new frmCreditNoteRegister();
open = Application.OpenForms["frmCreditNoteRegister"] as frmCreditNoteRegister;
break;
case "Debit Note Register":
frmObj = new frmDebitNoteRegister();
open = Application.OpenForms["frmDebitNoteRegister"] as frmDebitNoteRegister;
break;
case "Stock Journal Register":
frmObj = new frmStockJournalRegister();
open = Application.OpenForms["frmStockJournalRegister"] as frmStockJournalRegister;
break;
case "Designation":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmDesignation();
open = Application.OpenForms["frmDesignation"] as frmDesignation;
}
break;
case "Pay Head":
{
frmObj = new frmPayHead();
open = Application.OpenForms["frmPayHead"] as frmPayHead;
}
break;
case "Salary Package Creation":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmSalaryPackageCreation();
open = Application.OpenForms["frmSalaryPackageCreation"] as frmSalaryPackageCreation;
}
break;
case "Salary Package Register":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmSalaryPackageRegister();
open = Application.OpenForms["frmSalaryPackageRegister"] as frmSalaryPackageRegister;
}
break;
case "Employee Creation":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmEmployeeCreation();
open = Application.OpenForms["frmEmployeeCreation"] as frmEmployeeCreation;
}
break;
case "Employee Register":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmEmployeeRegister();
open = Application.OpenForms["frmEmployeeRegister"] as frmEmployeeRegister;
}
break;
case "Holiday Settings":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmHolydaySettings();
open = Application.OpenForms["frmHolydaySettings"] as frmHolydaySettings;
}
break;
case "Monthly Salary Settings":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmMonthlySalarySettings();
open = Application.OpenForms["frmMonthlySalarySettings"] as frmMonthlySalarySettings;
}
break;
case "Attendance":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmAttendance();
open = Application.OpenForms["frmAttendance"] as frmAttendance;
}
break;
case "Advance Payment":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmAdvancePayment();
open = Application.OpenForms["frmAdvancePayment"] as frmAdvancePayment;
}
break;
case "Advance Register":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmAdvanceRegister();
open = Application.OpenForms["frmAdvanceRegister"] as frmAdvanceRegister;
}
break;
case "Bonus Deduction":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmBonusDeduction();
open = Application.OpenForms["frmBonusDeduction"] as frmBonusDeduction;
}
break;
case "Bonus Deduction Register":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmBonusDeductionRegister();
open = Application.OpenForms["frmBonusDeductionRegister"] as frmBonusDeductionRegister;
}
break;
case "Monthly Salary Voucher":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmMonthlySalaryVoucher();
open = Application.OpenForms["frmMonthlySalaryVoucher"] as frmMonthlySalaryVoucher;
}
break;
case "Monthly Salary Register":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmMonthlySalaryRegister();
open = Application.OpenForms["frmMonthlySalaryRegister"] as frmMonthlySalaryRegister;
}
break;
case "Daily Salary Voucher":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmDailySalaryVoucher();
open = Application.OpenForms["frmDailySalaryVoucher"] as frmDailySalaryVoucher;
}
break;
case "Daily Salary Register":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmDailySalaryRegister();
open = Application.OpenForms["frmDailySalaryRegister"] as frmDailySalaryRegister;
}
break;
case "Pay Slip":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmPaySlip();
open = Application.OpenForms["frmPaySlip"] as frmPaySlip;
}
break;
case "Budget":
if (spSettings.SettingsStatusCheck("Budget") == "Yes")
{
frmObj = new frmBudget();
open = Application.OpenForms["frmBudget"] as frmBudget;
}
break;
case "Budget Variance":
if (spSettings.SettingsStatusCheck("Budget") == "Yes")
{
frmObj = new frmBudgetVariance();
open = Application.OpenForms["frmBudgetVariance"] as frmBudgetVariance;
}
break;
case "Change Current Date":
frmObj = new frmChangeCurrentDate();
open = Application.OpenForms["frmChangeCurrentDate"] as frmChangeCurrentDate;
break;
case "Settings":
frmObj = new frmSettings();
open = Application.OpenForms["frmSettings"] as frmSettings;
break;
case "Role":
frmObj = new frmRole();
open = Application.OpenForms["frmRole"] as frmRole;
break;
case "Role Privilege Settings":
frmObj = new frmRolePrivilegeSettings();
open = Application.OpenForms["frmRolePrivilegeSettings"] as frmRolePrivilegeSettings;
break;
case "User Creation":
frmObj = new frmUserCreation();
open = Application.OpenForms["frmUserCreation"] as frmUserCreation;
break;
case "Change Password":
frmObj = new frmChangePassword();
open = Application.OpenForms["frmChangePassword"] as frmChangePassword;
break;
case "New Financial Year":
frmObj = new frmNewFinancialYear();
open = Application.OpenForms["frmNewFinancialYear"] as frmNewFinancialYear;
break;
case "Change Financial Year":
frmObj = new frmChangeFinancialYear();
open = Application.OpenForms["frmChangeFinancialYear"] as frmChangeFinancialYear;
break;
case "Barcode Settings":
frmObj = new frmBarcodeSettings();
open = Application.OpenForms["frmBarcodeSettings"] as frmBarcodeSettings;
break;
case "Barcode Printing":
frmObj = new frmBarcodePrinting();
open = Application.OpenForms["frmBarcodePrinting"] as frmBarcodePrinting;
break;
case "Suffix Prefix Settings":
frmObj = new frmSuffixPrefixSettings();
open = Application.OpenForms["frmSuffixPrefixSettings"] as frmSuffixPrefixSettings;
break;
case "Change Product Tax":
frmObj = new frmChangeProductTax();
open = Application.OpenForms["frmChangeProductTax"] as frmChangeProductTax;
break;
case "Product Search":
frmObj = new frmProductSearch();
open = Application.OpenForms["frmProductSearch"] as frmProductSearch;
break;
case "Voucher Search":
frmObj = new frmVoucherSearch();
open = Application.OpenForms["frmVoucherSearch"] as frmVoucherSearch;
break;
case "Voucher Wise Product Search":
frmObj = new frmVoucherWiseProductSearch();
open = Application.OpenForms["frmVoucherWiseProductSearch"] as frmVoucherWiseProductSearch;
break;
case "Personal Reminder":
frmObj = new frmPersonalReminder();
open = Application.OpenForms["frmPersonalReminder"] as frmPersonalReminder;
break;
case "Overdue Purchase Order":
frmObj = new frmOverduePurchaseOrder();
open = Application.OpenForms["frmOverduePurchaseOrder"] as frmOverduePurchaseOrder;
break;
case "Overdue Sales Order":
frmObj = new frmOverdueSalesOrder();
open = Application.OpenForms["frmOverdueSalesOrder"] as frmOverdueSalesOrder;
break;
case "Short Expiry":
frmObj = new frmShortExpiry();
open = Application.OpenForms["frmShortExpiry"] as frmShortExpiry;
break;
case "Stock":
frmObj = new frmStock();
open = Application.OpenForms["frmStock"] as frmStock;
break;
case "Trial Balance":
frmObj = new frmTrialBalance();
open = Application.OpenForms["frmTrialBalance"] as frmTrialBalance;
break;
case "Balance Sheet":
frmObj = new frmBalanceSheet();
open = Application.OpenForms["frmBalanceSheet"] as frmBalanceSheet;
break;
case "Profit and Loss":
frmObj = new frmProfitAndLoss();
open = Application.OpenForms["frmProfitAndLoss"] as frmProfitAndLoss;
break;
case "Cash Flow":
frmObj = new frmCashFlow();
open = Application.OpenForms["frmCashFlow"] as frmCashFlow;
break;
case "Fund Flow":
frmObj = new frmFundFlow();
open = Application.OpenForms["frmFundFlow"] as frmFundFlow;
break;
case "Chart of Account":
frmObj = new frmChartOfAccount();
open = Application.OpenForms["frmChartOfAccount"] as frmChartOfAccount;
break;
case "Contra Report":
frmObj = new frmContraReport();
open = Application.OpenForms["frmContraReport"] as frmContraReport;
break;
case "Payment Report":
frmObj = new frmPaymentReport();
open = Application.OpenForms["frmPaymentReport"] as frmPaymentReport;
break;
case "Receipt Report":
frmObj = new frmReceiptReport();
open = Application.OpenForms["frmReceiptReport"] as frmReceiptReport;
break;
case "Journal Report":
frmObj = new frmJournalReport();
open = Application.OpenForms["frmJournalReport"] as frmJournalReport;
break;
case "PDC Payable Report":
frmObj = new frmPDCPayableReport();
open = Application.OpenForms["frmPDCPayableReport"] as frmPDCPayableReport;
break;
case "PDC Receivable Report":
frmObj = new frmPDCRecievableReport();
open = Application.OpenForms["frmPDCRecievableReport"] as frmPDCRecievableReport;
break;
case "PDC Clearance Report":
frmObj = new frmPDCClearanceReport();
open = Application.OpenForms["frmPDCClearanceReport"] as frmPDCClearanceReport;
break;
case "Purchase Order Report":
frmObj = new frmPurchaseOrderReport();
open = Application.OpenForms["frmPurchaseOrderReport"] as frmPurchaseOrderReport;
break;
case "Material Receipt Report":
frmObj = new frmMaterialReceiptReport();
open = Application.OpenForms["frmMaterialReceiptReport"] as frmMaterialReceiptReport;
break;
case "Rejection Out Report":
frmObj = new frmRejectionOutReport();
open = Application.OpenForms["frmRejectionOutReport"] as frmRejectionOutReport;
break;
case "Purchase Invoice Report":
frmObj = new frmPurchaseReport();
open = Application.OpenForms["frmPurchaseReport"] as frmPurchaseReport;
break;
case "Purchase Return Report":
frmObj = new frmPurchaseReturnReport();
open = Application.OpenForms["frmPurchaseReturnReport"] as frmPurchaseReturnReport;
break;
case "Sales Quotation Report":
frmObj = new frmSalesQuotationReport();
open = Application.OpenForms["frmSalesQuotationReport"] as frmSalesQuotationReport;
break;
case "Sales Order Report":
frmObj = new frmSalesOrderReport();
open = Application.OpenForms["frmSalesOrderReport"] as frmSalesOrderReport;
break;
case "Delivery Note Report":
frmObj = new frmDeliveryNoteReport();
open = Application.OpenForms["frmDeliveryNoteReport"] as frmDeliveryNoteReport;
break;
case "Rejection In Report":
frmObj = new frmRejectionInReport();
open = Application.OpenForms["frmRejectionInReport"] as frmRejectionInReport;
break;
case "Sales Invoice Report":
frmObj = new frmSalesReport();
open = Application.OpenForms["frmSalesReport"] as frmSalesReport;
break;
case "Sales Return Report":
frmObj = new frmSalesReturnReport();
open = Application.OpenForms["frmSalesReturnReport"] as frmSalesReturnReport;
break;
case "Physical Stock Report":
frmObj = new frmPhysicalStockReport();
open = Application.OpenForms["frmPhysicalStockReport"] as frmPhysicalStockReport;
break;
case "Service Report":
frmObj = new frmServiceReport();
open = Application.OpenForms["frmServiceReport"] as frmServiceReport;
break;
case "Credit Note Report":
frmObj = new frmCreditNoteReport();
open = Application.OpenForms["frmCreditNoteReport"] as frmCreditNoteReport;
break;
case "Debit Note Report":
frmObj = new frmDebitNoteReport();
open = Application.OpenForms["frmDebitNoteReport"] as frmDebitNoteReport;
break;
case "Stock Journal Report":
frmObj = new frmStockJournelReport();
open = Application.OpenForms["frmStockJournelReport"] as frmStockJournelReport;
break;
case "Employee Report":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmEmployeeReport();
open = Application.OpenForms["frmEmployeeReport"] as frmEmployeeReport;
}
break;
case "Daily Attendance Report":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmDailyAttendanceReport();
open = Application.OpenForms["frmDailyAttendanceReport"] as frmDailyAttendanceReport;
}
break;
case "Monthly Attendance Report":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmMonthlyAttendanceReport();
open = Application.OpenForms["frmMonthlyAttendanceReport"] as frmMonthlyAttendanceReport;
}
break;
case "Daily Salary Report":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmDailySalaryReport();
open = Application.OpenForms["frmDailySalaryReport"] as frmDailySalaryReport;
}
break;
case "Monthly Salary Report":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmMonthlySalaryReport();
open = Application.OpenForms["frmMonthlySalaryReport"] as frmMonthlySalaryReport;
}
break;
case "Payhead Report":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmPayHeadReport();
open = Application.OpenForms["frmPayHeadReport"] as frmPayHeadReport;
}
break;
case "Salary Package Report":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmSalaryPackageReport();
open = Application.OpenForms["frmSalaryPackageReport"] as frmSalaryPackageReport;
}
break;
case "Advance Payment Report":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmAdvancePaymentReport();
open = Application.OpenForms["frmAdvancePaymentReport"] as frmAdvancePaymentReport;
}
break;
case "Bonus Deduction Report":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmBonusDeductionReport();
open = Application.OpenForms["frmBonusDeductionReport"] as frmBonusDeductionReport;
}
break;
case "Employee Address Book Report":
if (spSettings.SettingsStatusCheck("Payroll") == "Yes")
{
frmObj = new frmEmployeeAddressBook();
open = Application.OpenForms["frmEmployeeAddressBook"] as frmEmployeeAddressBook;
}
break;
case "Day Book":
frmObj = new frmDayBook();
open = Application.OpenForms["frmDayBook"] as frmDayBook;
break;
case "Cash/Bank Book":
frmObj = new frmCashBankBookReport();
open = Application.OpenForms["frmCashBankBookReport"] as frmCashBankBookReport;
break;
case "Account Groupwise Report":
frmObj = new frmAccountGroupwiseReport();
open = Application.OpenForms["frmAccountGroupwiseReport"] as frmAccountGroupwiseReport;
break;
case "Account Ledger Report":
frmObj = new frmAccountLedgerReport();
open = Application.OpenForms["frmAccountLedgerReport"] as frmAccountLedgerReport;
break;
case "Outstanding Report":
frmObj = new frmOutstandingReport();
open = Application.OpenForms["frmOutstandingReport"] as frmOutstandingReport;
break;
case "Ageing Report":
frmObj = new frmAgeingReport();
open = Application.OpenForms["frmAgeingReport"] as frmAgeingReport;
break;
case "Party's Address Book":
frmObj = new frmPartyAddressBook();
open = Application.OpenForms["frmPartyAddressBook"] as frmPartyAddressBook;
break;
case "Stock Report":
frmObj = new frmStockReport();
open = Application.OpenForms["frmStockReport"] as frmStockReport;
break;
case "Short Expiry Report":
frmObj = new frmShortExpiryReport();
open = Application.OpenForms["frmShortExpiryReport"] as frmShortExpiryReport;
break;
case "Product Statistics":
frmObj = new frmProductStatistics();
open = Application.OpenForms["frmProductStatistics"] as frmProductStatistics;
break;
case "Price List Report":
frmObj = new frmPriceListReport();
open = Application.OpenForms["frmPriceListReport"] as frmPriceListReport;
break;
case "Tax Report":
frmObj = new frmTaxReport();
open = Application.OpenForms["frmTaxReport"] as frmTaxReport;
break;
case "VAT Report":
frmObj = new frmVatReturnReport();
open = Application.OpenForms["frmVatReturnReport"] as frmVatReturnReport;
break;
case "Cheque Report":
frmObj = new frmChequeReport();
open = Application.OpenForms["frmChequeReport"] as frmChequeReport;
break;
case "Free Sale Report":
frmObj = new frmFreeSaleReport();
open = Application.OpenForms["frmFreeSaleReport"] as frmFreeSaleReport;
break;
case "Product Vs Batch Report":
frmObj = new frmProductVsBatchReport();
open = Application.OpenForms["frmProductVsBatchReport"] as frmProductVsBatchReport;
break;
case "Customer":
frmObj = new frmCustomer();
open = Application.OpenForms["frmCustomer"] as frmCustomer;
break;
case "Supplier":
frmObj = new frmSupplier();
open = Application.OpenForms["frmSupplier"] as frmSupplier;
break;
}
if (frmObj != null)
{
if (open == null)
{
frmObj.MdiParent = formMDI.MDIObj;
frmObj.Show();
}
else
{
open.Activate();
if (open.WindowState == FormWindowState.Minimized)
{
open.WindowState = FormWindowState.Normal;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("QL:4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}