/// <summary>
/// Datevalidation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDateSearch_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
bool isInvalide = obj.DateValidationFunction(txtFromDateSearch);
if (!isInvalide)
{
txtFromDateSearch.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
if (txtFromDateSearch.Text == string.Empty)
{
txtFromDateSearch.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
//---for change date in Date time picker----//
string strdate = txtFromDateSearch.Text;
dtpFromDateSeach.Value = Convert.ToDateTime(strdate.ToString());
//------------------//
}
catch (Exception ex)
{
MessageBox.Show("PREM16:" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// For date validation and set the date as text box date
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
bool isInvalid = obj.DateValidationFunction(txtFromDate);
if (!isInvalid)
{
txtFromDate.Text = strFromDateToKeep;
}
else
{
string date = txtFromDate.Text;
dtpFromDate.Value = Convert.ToDateTime(date);
}
dtpToDate.MinDate = Convert.ToDateTime(txtFromDate.Text);
//dtpToDate.Value = dtpFromDate.Value;
//txtToDate.Clear();
}
catch (Exception ex)
{
MessageBox.Show("NFY 16 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// For date validation and set the date as text box date
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
bool isInvalid = obj.DateValidationFunction(txtFromDate);
if (!isInvalid)
{
txtFromDate.Text = strFromDateToKeep;
}
else
{
string date = txtFromDate.Text;
dtpFromDate.Value = Convert.ToDateTime(date);
}
dtpToDate.MinDate = Convert.ToDateTime(txtFromDate.Text);
//dtpToDate.Value = dtpFromDate.Value;
//txtToDate.Clear();
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "NFY 14 : " + ex.Message;
}
}
/// <summary>
/// For date validation and set the date as text box date
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtToDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
bool isInvalid = obj.DateValidationFunction(txtToDate);
if (!isInvalid)
{
txtToDate.Text = strToDateToKeep;
}
}
catch (Exception ex)
{
MessageBox.Show("NFY 17 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On 'Search' button click fills Datagridview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
DateValidation ObjValidation = new DateValidation();
ObjValidation.DateValidationFunction(txtTodate);
if (Convert.ToDateTime(txtTodate.Text) < Convert.ToDateTime(txtFromDate.Text))
{
MessageBox.Show("todate should be greater than fromdate", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtTodate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
txtFromDate.Text = PublicVariables._dtFromDate.ToString("dd-MMM-yyyy");
GridFill();
}
else
{
GridFill();
}
}
catch (Exception ex)
{
MessageBox.Show("TB:13" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On leave from txttodate
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txttodate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
obj.DateValidationFunction(txttodate);
if (txttodate.Text == string.Empty)
{
txttodate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
//---for change date in Date time picker----
string strdate = txttodate.Text;
dtptodate.Value = Convert.ToDateTime(strdate.ToString());
}
catch (Exception ex)
{
MessageBox.Show("OR:17" + 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>
/// Date validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtVoucherDateTo_Leave(object sender, EventArgs e)
{
try
{
DateValidation objDateValidation = new DateValidation();
objDateValidation.DateValidationFunction(txtVoucherDateTo);
if (txtVoucherDateTo.Text == string.Empty)
{
txtVoucherDateTo.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
}
catch (Exception ex)
{
MessageBox.Show("DSR16" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On textbox leave event for Data validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation objVal = new DateValidation();
bool isInvalid = objVal.DateValidationFunction(txtFromDate);
if (!isInvalid)
{
txtFromDate.Text = PublicVariables._dtFromDate.ToString("dd-MMM-yyyy");
}
dtpFrmDate.Value = Convert.ToDateTime(txtFromDate.Text);
}
catch (Exception ex)
{
MessageBox.Show("PRRT:07" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On leave from txtToDate
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtToDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation DateValidationObj = new DateValidation();
DateValidationObj.DateValidationFunction(txtToDate);
if (txtToDate.Text == string.Empty)
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
}
}
catch (Exception ex)
{
MessageBox.Show("AR20:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// text box StatementFrom leave for change date in date time picker
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtStatementFrom_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
obj.DateValidationFunction(txtStatementFrom);
if (txtStatementFrom.Text == string.Empty)
{
txtStatementFrom.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
dtpStatementFrom.Value = Convert.ToDateTime(txtStatementFrom.Text);
}
catch (Exception ex)
{
MessageBox.Show("BR:11" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Bank reconciliation Cell value changed event for Set the statement date
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvBankReconciliation_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
DateValidation objVal = new DateValidation();
TextBox txtDate = new TextBox();
if (!dgvBankReconciliation.Rows[e.RowIndex].Cells["dgvtxtStatementDate"].ReadOnly)
{
if (dgvBankReconciliation.Rows[e.RowIndex].Cells["dgvtxtStatementDate"].Value != null && dgvBankReconciliation.Rows[e.RowIndex].Cells["dgvtxtStatementDate"].Value.ToString() != string.Empty)
{
txtDate.Text = dgvBankReconciliation.Rows[e.RowIndex].Cells["dgvtxtStatementDate"].Value.ToString();
bool isDate = objVal.DateValidationFunction(txtDate);
if (isDate)
{
dgvBankReconciliation.Rows[e.RowIndex].Cells["dgvtxtStatementDate"].Value = txtDate.Text;
}
else
{
dgvBankReconciliation.Rows[e.RowIndex].Cells["dgvtxtStatementDate"].Value = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("BR:16" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void dtpDueDate_Leave(object sender, EventArgs e)
{
DateValidation ObjValidation = new DateValidation();
ObjValidation.DateValidationFunction(txtDueDate);
if (Convert.ToDateTime(txtDate.Text) > Convert.ToDateTime(txtDueDate.Text))
{
MessageBox.Show("DueDate should be greater than Date", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtDueDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
txtDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
DateTime dt;
DateTime.TryParse(txtDueDate.Text, out dt);
dtpDate.Value = dt;
}
txtDueDays.Text = string.Empty;
}
/// <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());
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
DataSet dsetFinancial = new DataSet();
SettingsInfo InfoSettings = new SettingsInfo();
SettingsBll BllSettings = new SettingsBll();
//--------------- Selection Of Calculation Method According To Settings ------------------//
if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
strCalculationMethod = "FIFO";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
strCalculationMethod = "Average Cost";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
strCalculationMethod = "High Cost";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
strCalculationMethod = "Low Cost";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
strCalculationMethod = "Last Purchase Rate";
}
dsetFinancial = bllFinancialStatement.FundFlow(strFromDate, strTodate);
DataTable dtbl = new DataTable();
Font newFont = new Font(dgvFundFlow.Font, FontStyle.Bold);
CurrencyInfo InfoCurrency = new CurrencyInfo();
CurrencyBll BllCurrency = new CurrencyBll();
InfoCurrency = BllCurrency.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 = bllFinancialStatement.StockValueGetOnDate(Convert.ToDateTime(txtFundflowToDate.Text), strCalculationMethod, false, false);
dcClosingStock = Math.Round(dcClosingStock, inDecimalPlaces);
//---------------------Opening Stock-----------------------
decimal dcOpeninggStock = bllFinancialStatement.StockValueGetOnDate(Convert.ToDateTime(txtFundFlowFromDate.Text), strCalculationMethod, true, false);
//------------- Profit Or Loss -----------// With Calculation
decimal dcProfit = 0;
DataSet dsetProfitAndLoss = new DataSet();
dsetProfitAndLoss = bllFinancialStatement.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)
{
MessageBox.Show("FF:06" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <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>
/// To set dtp value based on Textbox changed
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
obj.DateValidationFunction(txtDate);
if (txtDate.Text == string.Empty)
{
txtDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
string strdate = txtDate.Text;
dtpDate.Value = Convert.ToDateTime(strdate.ToString());
CurrencyComboFill();
}
catch (Exception ex)
{
MessageBox.Show("DN:94" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for initial date settings
/// </summary>
public void InitialDateSettings()
{
try
{
dtpAgeingDate.Value = PublicVariables._dtToDate;
dtpAgeingDate.MinDate = PublicVariables._dtFromDate;
dtpAgeingDate.MaxDate = PublicVariables._dtToDate;
DateValidation objValidation = new DateValidation();
objValidation.DateValidationFunction(txtToDate);
if (txtToDate.Text == string.Empty)
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
}
}
catch (Exception ex)
{
MessageBox.Show("AR10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On 'Search' button click fills datagridview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnRefresh_Click(object sender, EventArgs e)
{
try
{
DateValidation ObjValidation = new DateValidation();
ObjValidation.DateValidationFunction(txtToDate);
if (Convert.ToDateTime(txtToDate.Text) < Convert.ToDateTime(txtFromDate.Text))
{
MessageBox.Show("To-Date should be greater than From-Date", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtToDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
txtFromDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
DateTime dt;
DateTime.TryParse(txtToDate.Text, out dt);
dtpToDate.Value = dt;
dtpFromDate.Value = dt;
}
GridFill();
}
catch (Exception ex)
{
MessageBox.Show("DNREG10:" + 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>
/// On leave from txtBooksBegining
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtBooksBegining_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
bool isInvalid = obj.DateValidationFunction(txtBooksBegining);
if (!isInvalid)
{
txtBooksBegining.Text = System.DateTime.Now.ToString("dd-MMM-yyyy");
}
string date = txtBooksBegining.Text;
dtpBooksBegining.Value = Convert.ToDateTime(date);
}
catch (Exception ex)
{
MessageBox.Show("CR22:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On 'Search' button click for filter the data
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
DateValidation ObjValidation = new DateValidation();
ObjValidation.DateValidationFunction(txtToDate);
if (Convert.ToDateTime(txtToDate.Text) < Convert.ToDateTime(txtFromDate.Text))
{
MessageBox.Show("todate should be greater than fromdate", "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
txtFromDate.Text = PublicVariables._dtFromDate.ToString("dd-MMM-yyyy");
DateTime dt;
DateTime.TryParse(txtToDate.Text, out dt);
dtpToDate.Value = dt;
PurchaseReturnReportGridFill();
}
else
{
DateTime dt;
DateTime.TryParse(txtToDate.Text, out dt);
dtpToDate.Value = dt;
PurchaseReturnReportGridFill();
}
}
catch (Exception ex)
{
MessageBox.Show("PRRT:15" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <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();
CurrencyBll BllCurrency = new CurrencyBll();
InfoCurrency = BllCurrency.CurrencyView(1);
int inDecimalPlaces = InfoCurrency.NoOfDecimalPlaces;
dgvProfitAndLoss.Rows.Clear();
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
DataTable dtblFinancial = new DataTable();
DataSet DsetProfitAndLoss = new DataSet();
SettingsInfo infoSettings = new SettingsInfo();
SettingsBll BllSettings = new SettingsBll();
//---------check calculation method
if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
calculationMethod = "FIFO";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
calculationMethod = "Average Cost";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
calculationMethod = "High Cost";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
calculationMethod = "Low Cost";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
calculationMethod = "Last Purchase Rate";
}
DsetProfitAndLoss = bllFinancialStatement.ProfitAndLossAnalysis(DateTime.Parse(txtFromDate.Text), DateTime.Parse(txtToDate.Text));
//---- Opening Stock
dgvProfitAndLoss.Rows.Add();
decimal dcOpeningStock = bllFinancialStatement.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 = bllFinancialStatement.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)
{
MessageBox.Show("PAL :01" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtVoucherDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation objVal = new DateValidation();
bool isInvalid = objVal.DateValidationFunction(txtVoucherDate);
if (!isInvalid)
{
txtVoucherDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
dtpVoucherDate.Value = Convert.ToDateTime(txtVoucherDate.Text);
//-------------Re fill ---------------------------//
if (!isEditMode)
{
voucherNumberGeneration();
}
}
catch (Exception ex)
{
MessageBox.Show("MSV27:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date Validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
bool isValidate = obj.DateValidationFunction(txtDate);
if (!isValidate)
{
txtDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
//---for change date in Date time picker----//
dtpDate.Value = Convert.ToDateTime(txtDate.Text);
if (!isEditmode)//Re fill
{
VoucherNumberGeneration();
}
}
catch (Exception ex)
{
MessageBox.Show("DSV35:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// changing Fromdate as per textbox changed
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
obj.DateValidationFunction(txtFromDate);
if (txtFromDate.Text == String.Empty)
txtFromDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
dtpFromDate.Value = DateTime.Parse(txtFromDate.Text);
}
catch (Exception ex)
{
MessageBox.Show("SPS17" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date vakidation and fills Datagridview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtSalaryDate_Leave(object sender, EventArgs e)
{
DailySalaryVoucherBll BllDailySalaryVoucher = new DailySalaryVoucherBll();
try
{
DateValidation obj = new DateValidation();
obj.DateValidationFunction(txtSalaryDate);
if (txtSalaryDate.Text == string.Empty)
{
txtSalaryDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
//---for change date in Date time picker----//
string strdate = txtSalaryDate.Text;
dtpSalaryDate.Value = Convert.ToDateTime(strdate.ToString());
List<DataTable> listObj = new List<DataTable>();
listObj = BllDailySalaryVoucher.DailySalaryVoucherDetailsGridViewAll(txtSalaryDate.Text.ToString(), isEditmode, strVoucherNoforEdit);
dgvDailySalaryVoucher.DataSource = listObj[0];
}
catch (Exception ex)
{
MessageBox.Show("DSV30:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview after calculation
/// </summary>
public void GridFill()
{
try
{
if (!isFormLoad)
{
string calculationMethod = string.Empty;
SettingsInfo InfoSettings = new SettingsInfo();
SettingsBll BllSettings = new SettingsBll();
//--------------- Selection Of Calculation Method According To Settings ------------------//
if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "FIFO")
{
calculationMethod = "FIFO";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Average Cost")
{
calculationMethod = "Average Cost";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "High Cost")
{
calculationMethod = "High Cost";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Low Cost")
{
calculationMethod = "Low Cost";
}
else if (BllSettings.SettingsStatusCheck("StockValueCalculationMethod") == "Last Purchase Rate")
{
calculationMethod = "Last Purchase Rate";
}
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
DataTable dtbl1 = new DataTable();
CurrencyInfo InfoCurrency = new CurrencyInfo();
CurrencyBll BllCurrency = new CurrencyBll();
int inDecimalPlaces = InfoCurrency.NoOfDecimalPlaces;
decimal dcClosingStock = bllFinancialStatement.StockValueGetOnDate(Convert.ToDateTime(txtTodate.Text), calculationMethod, false, false);
dcClosingStock = Math.Round(dcClosingStock, inDecimalPlaces);
//---------------------Opening Stock-----------------------
decimal dcOpeninggStock = bllFinancialStatement.StockValueGetOnDate(PublicVariables._dtFromDate, calculationMethod, true, true);
decimal dcProfit = 0;
DataSet dsetProfitAndLoss = new DataSet();
dsetProfitAndLoss = bllFinancialStatement.ProfitAndLossAnalysisUpToaDateForBalansheet(PublicVariables._dtFromDate, DateTime.Parse(txtTodate.Text));
DataTable dtblProfit = new DataTable();
dtblProfit = dsetProfitAndLoss.Tables[0];
for (int i = 0; i < dsetProfitAndLoss.Tables.Count; ++i)
{
dtbl1 = dsetProfitAndLoss.Tables[i];
decimal dcSum = 0;
if (i == 0 || (i % 2) == 0)
{
if (dtbl1.Rows.Count > 0)
{
dcSum = decimal.Parse(dtbl1.Compute("Sum(Debit)", string.Empty).ToString());
}
}
else
{
if (dtbl1.Rows.Count > 0)
{
dcSum = decimal.Parse(dtbl1.Compute("Sum(Credit)", string.Empty).ToString());
}
}
}
DateValidation objValidation = new DateValidation();
objValidation.DateValidationFunction(txtTodate);
if (txtTodate.Text == string.Empty)
txtTodate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
Font newFont = new Font(dgvTrailBalance.Font, FontStyle.Bold);
DataSet DsetTrailbalance = new DataSet();
DataTable dtbl = new DataTable();
decimal dcTotalCredit = 0;
decimal dcTotalDebit = 0;
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");
}
DataTable dtblTrail = new DataTable();
DataTable dtblTrail1 = new DataTable();
DataTable dtblProfitAndLossAcc = new DataTable();
DataTable dtblProfitAndLossAcc1 = new DataTable();
DataSet dsTrial = new DataSet();
Font newfont = new Font(dgvTrailBalance.Font, FontStyle.Bold);
dgvTrailBalance.Rows.Clear();
dsTrial = bllFinancialStatement.TrialBalance(DateTime.Parse(txtFromDate.Text), DateTime.Parse(txtTodate.Text), 0);
dtblTrail = dsTrial.Tables[0];
dtblProfitAndLossAcc = dsTrial.Tables[1];
if (dgvTrailBalance.RowCount > 0)
{
dcTotalCredit = decimal.Parse(dtblTrail.Compute("Sum(credit)", string.Empty).ToString());
dcTotalDebit = decimal.Parse(dtblTrail.Compute("Sum(debit)", string.Empty).ToString());
}
for (int i = 0; i < dtblTrail.Rows.Count; ++i)
{
dgvTrailBalance.Rows.Add();
if (Convert.ToDecimal(dtblTrail.Rows[i]["accountGroupId"].ToString()) != 6)
{
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtAccountGroupId"].Value = dtblTrail.Rows[i]["accountGroupId"];
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["accountGroupName"].Value = dtblTrail.Rows[i]["name"];
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["openingBalance"].Value = dtblTrail.Rows[i]["OpeningBalance"];
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtBalance"].Value = dtblTrail.Rows[i]["Balance"];
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["credit"].Value = dtblTrail.Rows[i]["credit"];
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["debit"].Value = dtblTrail.Rows[i]["debit"];
dcTotalCredit += decimal.Parse(dtblTrail.Rows[i]["credit"].ToString());
dcTotalDebit += decimal.Parse(dtblTrail.Rows[i]["debit"].ToString());
}
else
{
decimal decOpBalance = dcOpeninggStock + Convert.ToDecimal(dtblTrail.Rows[i]["OpBalance"].ToString());
decimal decBalance = dcOpeninggStock + Convert.ToDecimal(dtblTrail.Rows[i]["Balance1"].ToString());
string strOpBalance = string.Empty;
string strBalance = string.Empty;
if (decOpBalance < 0)
{
strOpBalance = Math.Round(decOpBalance, PublicVariables._inNoOfDecimalPlaces).ToString() + "Cr";
}
else
{
strOpBalance = Math.Round(decOpBalance, PublicVariables._inNoOfDecimalPlaces).ToString() + "Dr";
}
if (decBalance < 0)
{
strBalance = Math.Round(decBalance, PublicVariables._inNoOfDecimalPlaces).ToString() + "Cr";
}
else
{
strBalance = Math.Round(decBalance, PublicVariables._inNoOfDecimalPlaces).ToString() + "Dr";
}
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtAccountGroupId"].Value = dtblTrail.Rows[i]["accountGroupId"];
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["accountGroupName"].Value = dtblTrail.Rows[i]["name"];
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["openingBalance"].Value = strOpBalance;
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtBalance"].Value = strBalance;
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["credit"].Value = dtblTrail.Rows[i]["credit"];
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["debit"].Value = dtblTrail.Rows[i]["debit"];
dcTotalCredit += decimal.Parse(dtblTrail.Rows[i]["credit"].ToString());
dcTotalDebit += decimal.Parse(dtblTrail.Rows[i]["debit"].ToString());
}
}
decimal OpeningProfit;
dtblProfitAndLossAcc1 = dsTrial.Tables[2];
if (dgvTrailBalance.RowCount > 0)
{
decimal dcTotalCredit1 = decimal.Parse(dtblTrail.Compute("Sum(credit)", string.Empty).ToString());
decimal dcTotalDebit1 = decimal.Parse(dtblTrail.Compute("Sum(debit)", string.Empty).ToString());
OpeningProfit = dcTotalCredit1 + dcTotalDebit1;
}
DataSet DsetBalanceSheet = new DataSet();
DsetBalanceSheet = bllFinancialStatement.BalanceSheet(PublicVariables._dtFromDate, DateTime.Parse(txtTodate.Text));
DataTable dtblProf = new DataTable();
decimal dcProfitOpening = 0;
dtblProf = DsetBalanceSheet.Tables[2];
decimal decProfitLedger = 0;
if (dtblProf.Rows.Count > 0)
{
decProfitLedger = decimal.Parse(dtblProf.Compute("Sum(Balance)", string.Empty).ToString());
}
DataTable dtblProfitLedgerOpening = new DataTable();
dtblProfitLedgerOpening = DsetBalanceSheet.Tables[3];
decimal decProfitLedgerOpening = 0;
foreach (DataRow dRow in dtblProfitLedgerOpening.Rows)
{
decProfitLedgerOpening += decimal.Parse(dRow["Balance"].ToString());
}
decimal decTotalProfitAndLoss = decProfitLedger;
decimal OpeningProfit1;
decimal openingBalance;
dgvTrailBalance.Rows.Add();
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtSlNo"].Value = " ";
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["accountGroupName"].Value = "Profit and Loss";
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtAccountGroupId"].Value = "0";
openingBalance = Convert.ToDecimal(dtblProfitAndLossAcc.Rows[0]["OpeningBalance"].ToString());
{
if (openingBalance > 0)
{
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["openingBalance"].Value = openingBalance + "Dr";
}
else
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["openingBalance"].Value = (-1) * openingBalance + "Cr";
}
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtSlNo"].Value = dgvTrailBalance.Rows.Count.ToString();
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].DefaultCellStyle.ForeColor = Color.Blue;
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].DefaultCellStyle.Font = new Font(dgvTrailBalance.Font, FontStyle.Regular);
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["credit"].Value = dtblProfitAndLossAcc.Rows[0]["credit"].ToString();
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["debit"].Value = dtblProfitAndLossAcc.Rows[0]["debit"].ToString();
OpeningProfit1 = (Convert.ToDecimal(dtblProfitAndLossAcc.Rows[0]["OpeningBalance"].ToString())) + Convert.ToDecimal(dtblProfitAndLossAcc.Rows[0]["debit"].ToString()) - Convert.ToDecimal(dtblProfitAndLossAcc.Rows[0]["credit"].ToString());
{
if (OpeningProfit1 > 0)
{
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtBalance"].Value = decTotalProfitAndLoss + dcProfit + "Dr";
}
else
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtBalance"].Value = (-1) * decTotalProfitAndLoss - dcProfit + "Cr";
};
dcTotalCredit = dcTotalCredit + Convert.ToDecimal(dtblProfitAndLossAcc.Rows[0]["credit"].ToString());
dcTotalDebit = dcTotalDebit + Convert.ToDecimal(dtblProfitAndLossAcc.Rows[0]["debit"].ToString());
//=================================Net profit and NetLoss transation for previousyear==============
decimal decprofitLossbal = 0;
decimal decbalance = 0;
decimal decProfitAndLossOfPrevious = decProfitLedgerOpening;
dgvTrailBalance.Rows.Add();
if (dcProfitOpening > 0)
{
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["openingBalance"].Value = dcProfitOpening + "Dr";
decprofitLossbal = dcProfitOpening;
}
if (dcProfitOpening <= 0)
{
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["openingBalance"].Value = (-1) * dcProfitOpening + "Cr";
decprofitLossbal = dcProfitOpening;
}
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtSlNo"].Value = " ";
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["accountGroupName"].Value = "Profit and Loss Opening";
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["openingBalance"].Value = "0.00Dr";
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].DefaultCellStyle.ForeColor = Color.Brown;
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].DefaultCellStyle.Font = new Font(dgvTrailBalance.Font, FontStyle.Regular);
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtAccountGroupId"].Value = "0";
if (decProfitAndLossOfPrevious > 0)
{
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["debit"].Value = decProfitAndLossOfPrevious;
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["credit"].Value = "0.00";
decbalance = (decProfitAndLossOfPrevious);
}
if (decProfitAndLossOfPrevious <= 0)
{
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["credit"].Value = (-1) * (decProfitAndLossOfPrevious);
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["debit"].Value = "0.00";
decbalance = ((decProfitAndLossOfPrevious));
}
if (decbalance >= 0)
{
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtBalance"].Value = decbalance + decprofitLossbal + "Dr";
}
if (decbalance < 0)
{
decbalance = -(decbalance);
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtBalance"].Value = decbalance + decprofitLossbal + "Cr";
}
dgvTrailBalance.Rows.Add();
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtSlNo"].Value = " ";
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["accountGroupName"].Value = "Total:";
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["dgvtxtSlNo"].Value = string.Empty;
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].DefaultCellStyle.ForeColor = Color.Red;
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].DefaultCellStyle.Font = new Font(dgvTrailBalance.Font, FontStyle.Bold);
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["credit"].Value = dcTotalCredit;
dgvTrailBalance.Rows[dgvTrailBalance.Rows.Count - 1].Cells["debit"].Value = dcTotalDebit;
if (dgvTrailBalance.Columns.Count > 0)
{
dgvTrailBalance.Columns["credit"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvTrailBalance.Columns["debit"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvTrailBalance.Columns["openingBalance"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvTrailBalance.Columns["dgvtxtBalance"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
dgvTrailBalance.ScrollBars = ScrollBars.Both;
dgvTrailBalance.ClearSelection();
if (inCurrenRowIndex > 0 && dgvTrailBalance.Rows.Count > 0 && inCurrenRowIndex < dgvTrailBalance.Rows.Count)
{
if (dgvTrailBalance.Rows[inCurrenRowIndex].Cells[inCurrentColIndex].Visible)
{
dgvTrailBalance.CurrentCell = dgvTrailBalance.Rows[inCurrenRowIndex].Cells[inCurrentColIndex];
}
else
{
dgvTrailBalance.CurrentCell = dgvTrailBalance.Rows[inCurrenRowIndex].Cells["debit"];
}
dgvTrailBalance.CurrentCell.Selected = true;
}
inCurrenRowIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show("Tb:2" + 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>
/// For date validation and set the date as text box date
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
bool isInvalid = obj.DateValidationFunction(txtFromDate);
if (!isInvalid)
{
txtFromDate.Text = strFromDateToKeep;
}
else
{
string date = txtFromDate.Text;
dtpFromDate.Value = Convert.ToDateTime(date);
}
dtpToDate.MinDate = Convert.ToDateTime(txtFromDate.Text);
//dtpToDate.Value = dtpFromDate.Value;
//txtToDate.Clear();
}
catch (Exception ex)
{
MessageBox.Show("NFY 16 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtTodate_TextChanged(object sender, EventArgs e)
{
try
{
if (txtTodate.Text == string.Empty && !txtTodate.Focused)
{
DateValidation obj = new DateValidation();
bool isInvalid = obj.DateValidationFunction(txtTodate);
if (!isInvalid)
{
txtTodate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
string date = txtTodate.Text;
dtpTodate.Value = Convert.ToDateTime(date);
}
}
catch (Exception ex)
{
MessageBox.Show("POREG10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On leave from txtDate, validates date
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
bool isInvalid = obj.DateValidationFunction(txtDate);
if (!isInvalid)
{
txtDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
string date = txtDate.Text;
dtpDate.Value = Convert.ToDateTime(date);
}
catch (Exception ex)
{
MessageBox.Show("SJ:64" + 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>
/// 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");
}
DateTime strFromDate = DateTime.Parse(txtFromDate.Text.ToString());
DateTime strTodate = DateTime.Parse(txttoDate.Text.ToString());
FinancialStatementSP spFinancial = new FinancialStatementSP();
DataSet dsetFinancial = new DataSet();
SettingsInfo InfoSettings = new SettingsInfo();
SettingsSP SpSettings = new SettingsSP();
dsetFinancial = spFinancial.CashFlow(strFromDate, strTodate);
DataTable dtbl = new DataTable();
Font newFont = new Font(dgvCashflow.Font, FontStyle.Bold);
CurrencyInfo InfoCurrency = new CurrencyInfo();
CurrencySP SpCurrency = new CurrencySP();
InfoCurrency = SpCurrency.CurrencyView(1);
int inDecimalPlaces = InfoCurrency.NoOfDecimalPlaces;
dgvCashflow.Rows.Clear();
for (int i = 0; i < 8; i++)
{
dtbl = dsetFinancial.Tables[i];
foreach (DataRow rw in dtbl.Rows)
{
dgvCashflow.Rows.Add();
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtParticulars"].Value = rw["accountGroupName"].ToString();
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtinflow"].Value = rw["Balance"].ToString();
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtID1"].Value = rw["accountGroupId"].ToString();
}
}
//-------------------------------Calculating TotalInflow-----------------------------------------
decimal dcTotalInflow = 0m;
if (dtbl.Rows.Count > 0)
{
for (int i = 0; i < dgvCashflow.Rows.Count; i++)
{
decimal dcTotalIn = decimal.Parse(dgvCashflow.Rows[i].Cells["dgvtxtinflow"].Value.ToString());
dcTotalInflow += dcTotalIn;
}
dcTotInflow = dcTotalInflow;
}
//-----------------Outflow------------------------------
int index = 0;
for (int i = 8; i < 15; i++)
{
dtbl = new DataTable();
dtbl = dsetFinancial.Tables[i];
foreach (DataRow rw in dtbl.Rows)
{
if (index < dgvCashflow.Rows.Count)
{
dgvCashflow.Rows[index].Cells["dgvtxtParticulars1"].Value = rw["accountGroupName1"].ToString();
dgvCashflow.Rows[index].Cells["dgvtxtoutflow"].Value = rw["Balance1"].ToString();
dgvCashflow.Rows[index].Cells["dgvtxtID2"].Value = rw["accountGroupId"].ToString();
}
else
{
dgvCashflow.Rows.Add();
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtParticulars1"].Value = rw["accountGroupName1"].ToString();
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtoutflow"].Value = rw["Balance1"].ToString();
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtID2"].Value = rw["accountGroupId"].ToString();
}
index++;
}
}
//-------------------------------Calculating TotalOutflow-----------------------------------------
decimal dcTotalOutflow = 0m;
if (dtbl.Rows.Count > 0)
{
for (int i = 0; i < dgvCashflow.Rows.Count - 1; i++)
{
decimal dcTotalIn = decimal.Parse(dgvCashflow.Rows[i].Cells["dgvtxtoutflow"].Value.ToString());
dcTotalOutflow += dcTotalIn;
}
dcTotOutflow = dcTotalOutflow;
}
dgvCashflow.Rows.Add();
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtinflow"].Value = "_______________________";
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtoutflow"].Value = "_______________________";
dgvCashflow.Rows.Add();
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].DefaultCellStyle.Font = newFont;
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtParticulars"].Value = "Total";
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtParticulars1"].Value = "Total";
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtinflow"].Value = Math.Round((dcTotalInflow), inDecimalPlaces);
dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtoutflow"].Value = Math.Round((dcTotalOutflow), inDecimalPlaces);
if (dgvCashflow.Columns.Count > 0)
{
dgvCashflow.Columns["dgvtxtinflow"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvCashflow.Columns["dgvtxtoutflow"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
if (inCurrenRowIndex >= 0 && dgvCashflow.Rows.Count > 0 && inCurrenRowIndex < dgvCashflow.Rows.Count)
{
if (dgvCashflow.Rows[inCurrenRowIndex].Cells[inCurentcolIndex].Visible)
{
dgvCashflow.CurrentCell = dgvCashflow.Rows[inCurrenRowIndex].Cells[inCurentcolIndex];
}
if (dgvCashflow.CurrentCell != null && dgvCashflow.CurrentCell.Visible)
{
dgvCashflow.CurrentCell.Selected = true;
}
}
inCurrenRowIndex = 0;
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "CF1:" + ex.Message;
}
}
/// <summary>
/// Call the totalamount,SlNo,InvalidEntry functions to do the all are the process even if change one value of the grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvContraVoucher_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
if (dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbBankorCashAccount"].Value != null && dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbBankorCashAccount"].Value.ToString() != "")
{
if (dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value == null || dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value.ToString() == "")
{
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(1);//PublicVariables._decCurrencyId;
}
}
TotalAmount();
SlNo();
if (dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbBankorCashAccount"].Value != null)
{
decimal decLedger = Convert.ToDecimal(dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbBankorCashAccount"].Value.ToString());
isBankAcocunt = bllAccountGroup.AccountGroupwithLedgerId(decLedger);
if (isBankAcocunt)
{
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].ReadOnly = false;
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeNo"].ReadOnly = false;
}
else
{
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].ReadOnly = true;
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeNo"].ReadOnly = true;
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = string.Empty;
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeNo"].Value = string.Empty;
}
}
CheckColumnMissing(e);
if (!dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].ReadOnly)
{
DateValidation objVal = new DateValidation();
TextBox txtDate = new TextBox();
if (dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value != null)
{
txtDate.Text = dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value.ToString();
bool isDate = objVal.DateValidationFunction(txtDate);
if (isDate)
{
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = txtDate.Text;
}
else
{
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("CV:42" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On leave from dtpAgeingDate
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dtpAgeingDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation objValidation = new DateValidation();
objValidation.DateValidationFunction(txtToDate);
if (txtToDate.Text == string.Empty)
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
DateTime dt;
DateTime.TryParse(txtToDate.Text, out dt);
dtpAgeingDate.Value = dt;
}
catch (Exception ex)
{
MessageBox.Show("AR18:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save function
/// </summary>
public void SaveFunction()
{
try
{
DateValidation Objdatevalidation = new DateValidation();
OtherDateValidationFunction ObjotherdateValidation = new OtherDateValidationFunction();
Objdatevalidation.DateValidationFunction(txtVoucherDate);
ObjotherdateValidation.DateValidationFunction(txtCheckDate, false);
DataTable dtblMaster = new DataTable();
SettingsBll BllSettings = new SettingsBll();
PDCRecivebleBll BllPdcreceivable = new PDCRecivebleBll();
PDCReceivableMasterInfo InfopdcRecivable = new PDCReceivableMasterInfo();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
InfopdcRecivable.VoucherNo = strVoucherNo;
InfopdcRecivable.InvoiceNo = txtVoucherNo.Text.Trim();
InfopdcRecivable.Date = DateTime.Parse(txtVoucherDate.Text);
InfopdcRecivable.LedgerId = Convert.ToDecimal(cmbAccountLedger.SelectedValue.ToString());
InfopdcRecivable.Amount = decimal.Parse(txtAmount.Text);
InfopdcRecivable.Narration = txtNarration.Text;
if (txtcheckNo.Text != string.Empty)
InfopdcRecivable.ChequeNo = txtcheckNo.Text;
else
InfopdcRecivable.ChequeNo = string.Empty;
if (txtCheckDate.Text != string.Empty)
InfopdcRecivable.ChequeDate = Convert.ToDateTime(txtCheckDate.Text);
else
InfopdcRecivable.ChequeDate = DateTime.Now;
InfopdcRecivable.UserId = PublicVariables._decCurrentUserId;
InfopdcRecivable.VoucherTypeId = decPDCReceivableVoucherTypeId;
if (cmbBank.SelectedValue != null && cmbBank.SelectedValue.ToString() != string.Empty)
{
InfopdcRecivable.BankId = Convert.ToDecimal(cmbBank.SelectedValue.ToString());
}
else
InfopdcRecivable.BankId = 0;
InfopdcRecivable.ExtraDate = DateTime.Now;
InfopdcRecivable.Extra1 = string.Empty;
InfopdcRecivable.Extra2 = string.Empty;
if (!isInEditMode)
{
decimal decIdentity = BllPdcreceivable.PDCReceivableMasterAdd(InfopdcRecivable);
LedgerPosting();
PartyBalanceAddOrEdit();
Messages.SavedMessage();
if (cbxPrint.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decIdentity);
}
else
{
Print(decIdentity);
}
}
ClearFunction();
}
else
{
decimal decIdentity = decPDCReceivableEditId;
InfopdcRecivable.PdcReceivableMasterId = decPDCReceivableEditId;
BllPdcreceivable.PDCReceivableMasterEdit(InfopdcRecivable);
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
BllLedgerPosting.LedgerPostingDeleteByVoucherNoVoucherTypeIdAndLedgerId(strVoucherNo, decPDCReceivableVoucherTypeId, 12);
BllPartyBalance.PartyBalanceDeleteByVoucherTypeAndVoucherNo(decPDCReceivableVoucherTypeId, strVoucherNo);
PartyBalanceAddOrEdit();
LedgerPostingEdit(decPDCReceivableEditId);
Messages.UpdatedMessage();
if (cbxPrint.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decIdentity);
}
else
{
Print(decIdentity);
}
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("PR9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
///// <summary>
/////
///// </summary>
///// <param name="txt"></param>
///// <param name="dtp"></param>
//public void dtpCloseUpEventFunction(TextBox txt, DateTimePicker dtp)
//{
// try
// {
// txt.Text = dtp.Value.ToString("dd-MMM-yyyy");
// txt.Focus();
// txt.SelectionStart = 0;
// txt.SelectionLength = 0;
// }
// catch (Exception ex)
// {
// MessageBox.Show("SV 31 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
// }
//}
/// <summary>
/// date validation function
/// </summary>
/// <param name="txt"></param>
/// <param name="dtp"></param>
public void DateValidation(TextBox txt, DateTimePicker dtp)
{
try
{
DateValidation obj = new DateValidation();
obj.DateValidationFunction(txt);
if (txt.Text == String.Empty)
{
txt.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
dtp.Value = DateTime.Parse(txt.Text);
}
catch (Exception ex)
{
MessageBox.Show("SV 28 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On leave from txtToDate
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtToDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
obj.DateValidationFunction(txtToDate);
if (txtToDate.Text == string.Empty || txtToDate.SelectionStart == 0)
txtToDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
dtpToDate.Value = Convert.ToDateTime(txtToDate.Text);
}
catch (Exception ex)
{
MessageBox.Show("TR:8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
