/// <summary>
/// On leave from txtToDate
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtToDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation dv = new DateValidation();
dv.DateValidationFunction(txtToDate);
if (txtToDate.Text == string.Empty)
{
txtToDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
string d = txtToDate.Text;
dtpToDate.Value = Convert.ToDateTime(d.ToString());
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "VRR12:" + ex.Message;
}
}
/// <summary>
/// For date validation and set the dtp value as text box value
/// </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 = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
string date = txtToDate.Text;
dtpToDate.Value = Convert.ToDateTime(date);
}
catch (Exception ex)
{
MessageBox.Show("ROREP16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date Validation in Text leave event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtCompanyCurrentdate_Leave(object sender, EventArgs e)
{
bool isValid = true;
try
{
DateValidation obj = new DateValidation();
isValid = obj.DateValidationFunction(txtCompanyCurrentdate);
if (!isValid)
{
txtCompanyCurrentdate.Text = string.Empty;
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "CCD 9 : " + ex.Message;
}
}
/// <summary>
/// For enter key and backspace navigation
/// </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");
}
string strdate = txtFromDate.Text;
dtpFrmDate.Value = Convert.ToDateTime(strdate.ToString());
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "PRREP21:" + ex.Message;
}
}
/// <summary>
/// DateValidation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation dateValidationObj = new DateValidation();
dateValidationObj.DateValidationFunction(txtFromDate);
if (txtFromDate.Text == String.Empty)
{
txtFromDate.Text = PublicVariables._dtFromDate.ToString("dd-MMM-yyyy");
}
dtpFrmDate.Value = DateTime.Parse(txtFromDate.Text);
}
catch (Exception ex)
{
MessageBox.Show("RIReport:12" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// For date validation and set the dtp value as text box value
/// </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 = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
string date = txtToDate.Text;
dtpToDate.Value = Convert.ToDateTime(date);
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "ROREP16:" + ex.Message;
}
}
/// <summary>
/// Date validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation DateValidationObj = new DateValidation();
DateValidationObj.DateValidationFunction(txtFromDate);
if (txtFromDate.Text == string.Empty)
{
txtFromDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
//---for change date in Date time picker----//
dtpFromDate.Value = Convert.ToDateTime(txtFromDate.Text);
}
catch (Exception ex)
{
MessageBox.Show("PSR:6" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date validation
/// </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");
}
string strdate = txtFromDate.Text;
dtpFromDate.Value = Convert.ToDateTime(strdate.ToString());
}
catch (Exception ex)
{
MessageBox.Show("SRR11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date Validation in Text leave event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtCompanyCurrentdate_Leave(object sender, EventArgs e)
{
bool isValid = true;
try
{
DateValidation obj = new DateValidation();
isValid = obj.DateValidationFunction(txtCompanyCurrentdate);
if (!isValid)
{
txtCompanyCurrentdate.Text = string.Empty;
}
}
catch (Exception ex)
{
MessageBox.Show("CCD 9 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date validation and fill datagridview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtCompanyCurrentdate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
obj.DateValidationFunction(txtCompanyCurrentdate);
if (txtCompanyCurrentdate.Text == String.Empty)
{
txtCompanyCurrentdate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
dtpCompanyCurrentDate.Value = DateTime.Parse(txtCompanyCurrentdate.Text);
GridFill();
HolidayIndication();
}
catch (Exception ex)
{
MessageBox.Show("A24" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txttoDate_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);
dtpToDate.Value = dt;
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "CF8:" + ex.Message;
}
}
/// <summary>
/// DateValidation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtSalaryMonth_Leave(object sender, EventArgs e)
{
try
{
DateValidation DateValidationObj = new DateValidation();
DateValidationObj.DateValidationFunction(txtSalaryMonth);
if (txtSalaryMonth.Text == string.Empty)
{
txtSalaryMonth.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
//---for change date in Date time picker----//
string strDate = txtSalaryMonth.Text;
dtpSalaryMonth.Value = Convert.ToDateTime(strDate.ToString());
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "APR:15 " + ex.Message;
}
}
/// <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)
{
formMDI.infoError.ErrorString = "AR10:" + ex.Message;
}
}
/// <summary>
/// DateValidation
/// </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._dtCurrentDate.ToString("dd-MMM-yyyy");
}
dtpToDate.Value = DateTime.Parse(txtToDate.Text);
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "RIReport14:" + ex.Message;
}
}
/// <summary>
/// On textbox leave event for Date validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDate_Leave(object sender, EventArgs e)
{
try
{
DateValidation ObjValidation = new DateValidation();
ObjValidation.DateValidationFunction(txtFromDate);
if (txtFromDate.Text == string.Empty)
{
txtFromDate.Text = PublicVariables._dtFromDate.ToString("dd-MMM-yyyy");
}
DateTime dt;
DateTime.TryParse(txtFromDate.Text, out dt);
dtpFromDate.Value = dt;
}
catch (Exception ex)
{
MessageBox.Show("PORP:9" + ex.Message, "Open Miracle", 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>
/// Datevalidation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtSalaryMonth_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
obj.DateValidationFunction(txtSalaryMonth);
if (txtSalaryMonth.Text == string.Empty)
{
txtSalaryMonth.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
//---for change date in Date time picker----//
string strdate = txtSalaryMonth.Text;
dtpSalaryMonth.Value = Convert.ToDateTime(strdate.ToString());
}
catch (Exception ex)
{
MessageBox.Show("MSR:14" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date validation
/// </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.Trim();
dtpToDate.Value = Convert.ToDateTime(strdate);
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "CR9:" + ex.Message;
}
}
/// <summary>
/// Date validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtToDate_Leave(object sender, EventArgs e)
{
try
{
if (txtToDate.Text == string.Empty)
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
}
DateValidation DateValidationObj = new DateValidation();
DateValidationObj.DateValidationFunction(txtToDate);
if (txtToDate.Text == string.Empty)
{
txtToDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
}
catch (Exception ex)
{
MessageBox.Show("PAL :13" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtToDate_Leave(object sender, EventArgs e)
{
try
{
if (txtToDate.Text == string.Empty)
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
}
DateValidation DateValidationObj = new DateValidation();
DateValidationObj.DateValidationFunction(txtToDate);
if (txtToDate.Text == string.Empty)
{
txtToDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "PAL13:" + ex.Message;
}
}
/// <summary>
/// Date validation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDate_TextChanged(object sender, EventArgs e)
{
try
{
if (txtFromDate.Text == string.Empty && !txtFromDate.Focused)
{
DateValidation obj = new DateValidation();
bool isInvalid = obj.DateValidationFunction(txtFromDate);
if (!isInvalid)
{
txtFromDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
string date = txtFromDate.Text;
dtpFromDate.Value = Convert.ToDateTime(date);
}
}
catch (Exception ex)
{
MessageBox.Show("PIREG19:" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to check or validate dates
/// </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 (txtFromDate.Text == String.Empty)
{
txt.Text = PublicVariables._dtFromDate.ToString("dd-MMM-yyyy");
}
if (txtToDate.Text == String.Empty)
{
txt.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
dtp.Value = DateTime.Parse(txt.Text);
}
catch (Exception ex)
{
MessageBox.Show("SVRT 11 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to check or validate dates
/// </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 (txtFromDate.Text == String.Empty)
{
txt.Text = PublicVariables._dtFromDate.ToString("dd-MMM-yyyy");
}
if (txtToDate.Text == String.Empty)
{
txt.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
dtp.Value = DateTime.Parse(txt.Text);
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "SVRT11:" + ex.Message;
}
}
/// <summary>
/// Date validation and set dtp's value as textbox text
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFromDate_TextChanged(object sender, EventArgs e)
{
try
{
if (txtFromDate.Text == string.Empty && !txtFromDate.Focused)
{
DateValidation obj = new DateValidation();
bool isInvalid = obj.DateValidationFunction(txtFromDate);
if (!isInvalid)
{
txtFromDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
string date = txtFromDate.Text;
dtpFromDate.Value = Convert.ToDateTime(date);
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "PIREP19:" + ex.Message;
}
}
/// <summary>
/// Fills Datagirdview on 'Search' button click
/// </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);
dtFromDate = Convert.ToDateTime(txtFromDate.Text);
dtToDate = Convert.ToDateTime(txtToDate.Text);
decVoucherType = Convert.ToDecimal(cmbVoucherType.SelectedValue);
strVocherNo = txtVoucherNo.Text;
decCashOrParty = Convert.ToDecimal(cmbCashorParty.SelectedValue);
if (cmbDeliveryNoteNo.SelectedIndex != -1)
{
decDeliveryNoteNo = Convert.ToDecimal(cmbDeliveryNoteNo.SelectedValue.ToString());
}
decSalesManId = Convert.ToDecimal(cmbSalesMan.SelectedValue);
strProductCode = txtProductCode.Text;
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;
RejectionInReportFill();
}
else
{
DateTime dt;
DateTime.TryParse(txtToDate.Text, out dt);
dtpToDate.Value = dt;
RejectionInReportFill();
}
}
catch (Exception ex)
{
MessageBox.Show("RIReport:15" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date validation and fill dtp value into the todate textbox
/// </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 && txtFromDate.Text != string.Empty)
{
if (Convert.ToDateTime(txtToDate.Text) <= Convert.ToDateTime(txtFromDate.Text))
{
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;
}
else
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
DateTime dt;
DateTime.TryParse(txtToDate.Text, out dt);
dtpToDate.Value = dt;
}
}
else
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
DateTime dt;
DateTime.TryParse(txtToDate.Text, out dt);
dtpToDate.Value = dt;
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "VPS :17" + ex.Message;
}
}
/// <summary>
/// Date validation and fill dtp value into the todate textbox
/// </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 && txtFromDate.Text != string.Empty)
{
if (Convert.ToDateTime(txtToDate.Text) <= Convert.ToDateTime(txtFromDate.Text))
{
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;
}
else
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
DateTime dt;
DateTime.TryParse(txtToDate.Text, out dt);
dtpToDate.Value = dt;
}
}
else
{
txtToDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy");
DateTime dt;
DateTime.TryParse(txtToDate.Text, out dt);
dtpToDate.Value = dt;
}
}
catch (Exception ex)
{
MessageBox.Show("VPS :17" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On 'Search' button click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnRefersh_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;
}
StockJournalRegisterGrideFill();
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "SJREG7:" + ex.Message;
}
}
/// <summary>
/// Search button click call the search function
/// </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");
Search();
}
else
{
Search();
}
}
catch (Exception ex)
{
MessageBox.Show("PRREP12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Date validation and fill datagridview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtCompanyCurrentdate_Leave(object sender, EventArgs e)
{
try
{
DateValidation obj = new DateValidation();
obj.DateValidationFunction(txtCompanyCurrentdate);
if (txtCompanyCurrentdate.Text == String.Empty)
{
txtCompanyCurrentdate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
if (DateTime.Parse(txtCompanyCurrentdate.Text) > PublicVariables._dtCurrentDate)
{
txtCompanyCurrentdate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
dtpCompanyCurrentDate.Value = DateTime.Parse(txtCompanyCurrentdate.Text);
GridFill();
HolidayIndication();
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "A25:" + ex.Message;
}
}
/// <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>
/// 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);
}
}
/// <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>
/// 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>
/// 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 '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>
/// 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>
/// 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>
/// 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>
/// 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 '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>
/// 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>
/// 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>
/// 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>
/// 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>
/// 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);
}
}
/// <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 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>
/// Save Function
/// </summary>
public void Save()
{
try
{
int inGridRowCount = dgvPaymentVoucher.RowCount;
int inTableRowCount = dtblPartyBalance.Rows.Count;
int inB = 0;
PaymentMasterInfo InfoPaymentMaster = new PaymentMasterInfo();
PaymentMasterSP SpPaymentMaster = new PaymentMasterSP();
PaymentDetailsInfo InfoPaymentDetails = new PaymentDetailsInfo();
PaymentDetailsSP SpPaymentDetails = new PaymentDetailsSP();
PartyBalanceSP SpPartyBalance = new PartyBalanceSP();
PartyBalanceInfo InfopartyBalance = new PartyBalanceInfo();
DateValidation objVal = new DateValidation();
TextBox txtDate1 = new TextBox();
InfoPaymentMaster.Date = dtpDate.Value;
InfoPaymentMaster.Extra1 = string.Empty;
InfoPaymentMaster.Extra2 = string.Empty;
InfoPaymentMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoPaymentMaster.InvoiceNo = txtVoucherNo.Text.Trim(); ;
InfoPaymentMaster.LedgerId = Convert.ToDecimal(cmbBankorCash.SelectedValue.ToString());
InfoPaymentMaster.Narration = txtNarration.Text.Trim();
InfoPaymentMaster.SuffixPrefixId = decDailySuffixPrefixId;
decimal decTotalAmount = TotalAmountCalculation();
InfoPaymentMaster.TotalAmount = decTotalAmount;
InfoPaymentMaster.UserId = PublicVariables._decCurrentUserId;
InfoPaymentMaster.VoucherNo = strVoucherNo;
InfoPaymentMaster.VoucherTypeId = decPaymentVoucherTypeId;
decimal decPaymentMasterId = SpPaymentMaster.PaymentMasterAdd(InfoPaymentMaster);
if (decPaymentMasterId != 0)
{
MasterLedgerPosting();
}
for (int inI = 0; inI < inGridRowCount - 1; inI++)
{
if (dgvPaymentVoucher.Rows[inI].HeaderCell.Value.ToString() != "X")
{
InfoPaymentDetails.Amount = Convert.ToDecimal(dgvPaymentVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
InfoPaymentDetails.ExchangeRateId = Convert.ToDecimal(dgvPaymentVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString());
InfoPaymentDetails.Extra1 = string.Empty;
InfoPaymentDetails.Extra2 = string.Empty;
InfoPaymentDetails.LedgerId = Convert.ToDecimal(dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString());
InfoPaymentDetails.PaymentMasterId = decPaymentMasterId;
if (dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value != null && dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
InfoPaymentDetails.LedgerId = Convert.ToDecimal(dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString());
}
if (dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
InfoPaymentDetails.ChequeNo = dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString();
if (dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value != null && dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
InfoPaymentDetails.ChequeDate = Convert.ToDateTime(dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value);
}
else
{
InfoPaymentDetails.ChequeDate = DateTime.Now;
}
}
else
{
InfoPaymentDetails.ChequeNo = string.Empty;
InfoPaymentDetails.ChequeDate = DateTime.Now;
}
decimal decPaymentDetailsId = SpPaymentDetails.PaymentDetailsAdd(InfoPaymentDetails);
if (decPaymentDetailsId != 0)
{
for (int inJ = 0; inJ < inTableRowCount; inJ++)
{
if (dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() == dtblPartyBalance.Rows[inJ]["LedgerId"].ToString())
{
PartyBalanceAddOrEdit(inJ);
}
}
inB++;
DetailsLedgerPosting(inI, decPaymentDetailsId);
}
}
}
Messages.SavedMessage();
if (cbxPrintafterSave.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPaymentmasterId);
}
else
{
Print(decPaymentMasterId);
}
}
Clear();
}
catch (Exception ex)
{
MessageBox.Show("PV17:" + 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>
/// 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>
/// 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>
/// 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>
/// 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>
/// 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>
/// Gridview cell value changed , doing basic calculations and checking invalid entries
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvPaymentVoucher_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
TotalAmount();
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value != null && dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value == null || dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value.ToString() == string.Empty)
{
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(1);
}
}
AccountGroupSP spAccountGroup = new AccountGroupSP();
AccountLedgerSP SpAccountLedger = new AccountLedgerSP();
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value != null && dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value.ToString().Trim() != string.Empty)
{
if (dgvPaymentVoucher.CurrentCell.ColumnIndex == dgvPaymentVoucher.CurrentRow.Cells["dgvcmbAccountLedger"].ColumnIndex)
{
/*************Remove partybalance while changing the ledger ************/
if (inUpdatingRowIndexForPartyRemove != -1)
{
int inTableRowCount = dtblPartyBalance.Rows.Count;
for (int inJ = 0; inJ < inTableRowCount; inJ++)
{
if (dtblPartyBalance.Rows.Count == inJ)
{
break;
}
if (Convert.ToDecimal(dtblPartyBalance.Rows[inJ]["ledgerId"].ToString()) == decUpdatingLedgerForPartyremove)
{
if (dtblPartyBalance.Rows[inJ]["PartyBalanceId"].ToString() != "0")
{
arrlstOfDeletedPartyBalanceRow.Add(dtblPartyBalance.Rows[inJ]["PartyBalanceId"]);
}
dtblPartyBalance.Rows.RemoveAt(inJ);
inJ--;
}
}
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
decUpdatingLedgerForPartyremove = 0;
inUpdatingRowIndexForPartyRemove = -1;
}
/*************************************************************************/
decimal decLedgerId = Convert.ToDecimal(dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value.ToString());
bool IsBankAccount = spAccountGroup.AccountGroupwithLedgerId(decLedgerId);
decimal decI = Convert.ToDecimal(SpAccountLedger.AccountGroupIdCheck(dgvPaymentVoucher.CurrentRow.Cells["dgvcmbAccountLedger"].FormattedValue.ToString()));
if (decI > 0)//to make amount and currency read only when party is choosen as ledger
{
dgvPaymentVoucher.CurrentRow.Cells["dgvtxtAmount"].ReadOnly = true;
dgvPaymentVoucher.CurrentRow.Cells["dgvtxtAmount"].Value = string.Empty;
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(1);
dgvPaymentVoucher.CurrentRow.Cells["dgvcmbCurrency"].ReadOnly = true;
}
else
{
dgvPaymentVoucher.CurrentRow.Cells["dgvtxtAmount"].ReadOnly = false;
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
dgvcmbCurrency.ReadOnly = false;
}
else
{
dgvcmbCurrency.ReadOnly = true;
}
}
}
}
CheckColumnMissing();
DateValidation objVal = new DateValidation();
TextBox txtDate1 = new TextBox();
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value != null)
{
txtDate1.Text = dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value.ToString();
bool isDate = objVal.DateValidationFunction(txtDate1);
if (isDate)
{
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = txtDate1.Text;
}
else
{
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PV48:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On 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>
/// 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>
/////
///// </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>
/// 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);
}
}
