/// <summary>
/// Function to insert particular values to ExchangeRate Table
/// </summary>
/// <param name="exchangerateinfo"></param>
public void ExchangeRateAddParticularFields(ExchangeRateInfo exchangerateinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ExchangeRateAddParticularFields", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@currencyId", SqlDbType.Decimal);
sprmparam.Value = exchangerateinfo.CurrencyId;
sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam.Value = exchangerateinfo.Date;
sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal);
sprmparam.Value = exchangerateinfo.Rate;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = exchangerateinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = exchangerateinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = exchangerateinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to save
/// </summary>
public void SaveFunction()
{
try
{
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
infoExchangeRate.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoExchangeRate.Date = Convert.ToDateTime(dtpDate.Text.Trim().ToString());
infoExchangeRate.Rate = Convert.ToDecimal(txtExchangeRate.Text.Trim().ToString());
infoExchangeRate.Narration = txtNarration.Text.Trim();
infoExchangeRate.Extra1 = string.Empty;
infoExchangeRate.Extra2 = string.Empty;
if (spExchangeRate.ExchangeRateCheckExistence(Convert.ToDateTime(txtDate.Text.Trim().ToString()), Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()), 0) == false)
{
if (ExchangeRateCheck())
{
spExchangeRate.ExchangeRateAddParticularFields(infoExchangeRate);
Messages.SavedMessage();
Clear();
}
}
else
{
Messages.ReferenceExistsMessageForUpdate();
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "ER2:" + ex.Message;
}
}
/// <summary>
/// Function to edit
/// </summary>
public void Editfunction()
{
try
{
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
infoExchangeRate.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoExchangeRate.Date = Convert.ToDateTime(dtpDate.Text.Trim().ToString());
infoExchangeRate.Rate = Convert.ToDecimal(txtExchangeRate.Text.Trim().ToString());
infoExchangeRate.Narration = txtNarration.Text.Trim();
infoExchangeRate.Extra1 = String.Empty;
infoExchangeRate.Extra2 = String.Empty;
infoExchangeRate.ExchangeRateId = decId;
if (spExchangeRate.ExchangeRateCheckExistence(Convert.ToDateTime(txtDate.Text.Trim().ToString()), Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()), decExchangeRateId) == false)
{
if (ExchangeRateCheck())
{
spExchangeRate.ExchangeRateEdit(infoExchangeRate);
Messages.UpdatedMessage();
SearchClear();
Clear();
}
}
else
{
Messages.InformationMessage("Already exists");
cmbCurrency.Focus();
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "ER3:" + ex.Message;
}
}
/// <summary>
/// Function to save
/// </summary>
public void SaveFunction()
{
try
{
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
infoExchangeRate.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoExchangeRate.Date = Convert.ToDateTime(dtpDate.Text.Trim().ToString());
infoExchangeRate.Rate = Convert.ToDecimal(txtExchangeRate.Text.Trim().ToString());
infoExchangeRate.Narration = txtNarration.Text.Trim();
infoExchangeRate.Extra1 = string.Empty;
infoExchangeRate.Extra2 = string.Empty;
if (spExchangeRate.ExchangeRateCheckExistence(Convert.ToDateTime(txtDate.Text.Trim().ToString()), Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()), 0) == false)
{
if (ExchangeRateCheck())
{
spExchangeRate.ExchangeRateAddParticularFields(infoExchangeRate);
Messages.SavedMessage();
Clear();
}
}
else
{
Messages.ReferenceExistsMessageForUpdate();
}
}
catch (Exception ex)
{
MessageBox.Show("ER2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save
/// </summary>
public void SaveFunction()
{
try
{
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
infoExchangeRate.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoExchangeRate.Date = Convert.ToDateTime(dtpDate.Text.Trim().ToString());
infoExchangeRate.Rate = Convert.ToDecimal(txtExchangeRate.Text.Trim().ToString());
infoExchangeRate.Narration = txtNarration.Text.Trim();
infoExchangeRate.Extra1 = string.Empty;
infoExchangeRate.Extra2 = string.Empty;
if (BllExchangeRate.ExchangeRateCheckExistence(Convert.ToDateTime(txtDate.Text.Trim().ToString()), Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()), 0) == false)
{
if (ExchangeRateCheck())
{
BllExchangeRate.ExchangeRateAddParticularFields(infoExchangeRate);
Messages.SavedMessage();
Clear();
}
}
else
{
Messages.ReferenceExistsMessageForUpdate();
}
}
catch (Exception ex)
{
MessageBox.Show("ER2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to edit
/// </summary>
public void Editfunction()
{
try
{
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
infoExchangeRate.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoExchangeRate.Date = Convert.ToDateTime(dtpDate.Text.Trim().ToString());
infoExchangeRate.Rate = Convert.ToDecimal(txtExchangeRate.Text.Trim().ToString());
infoExchangeRate.Narration = txtNarration.Text.Trim();
infoExchangeRate.Extra1 = String.Empty;
infoExchangeRate.Extra2 = String.Empty;
infoExchangeRate.ExchangeRateId = decId;
if (BllExchangeRate.ExchangeRateCheckExistence(Convert.ToDateTime(txtDate.Text.Trim().ToString()), Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()), decExchangeRateId) == false)
{
if (ExchangeRateCheck())
{
BllExchangeRate.ExchangeRateEdit(infoExchangeRate);
Messages.UpdatedMessage();
SearchClear();
Clear();
}
}
else
{
Messages.InformationMessage("Already exists");
cmbCurrency.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("ER3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill controls for update
/// </summary>
public void FillControls()
{
try
{
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
infoExchangeRate = spExchangeRate.ExchangeRateView(decId);
int inNoOfDecimalPlaces = spExchangeRate.NoOfDecimalNumberViewByExchangeRateId(decId);
cmbCurrency.SelectedValue = infoExchangeRate.CurrencyId.ToString();
dtpDate.Text = infoExchangeRate.Date.ToString();
txtExchangeRate.Text = Math.Round(Convert.ToDecimal(infoExchangeRate.Rate.ToString()), inNoOfDecimalPlaces).ToString();
txtNarration.Text = infoExchangeRate.Narration;
decExchangeRateId = infoExchangeRate.ExchangeRateId;
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "ER13:" + ex.Message;
}
}
/// <summary>
/// Function to fill controls for update
/// </summary>
public void FillControls()
{
try
{
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
infoExchangeRate = BllExchangeRate.ExchangeRateView(decId);
int inNoOfDecimalPlaces = BllExchangeRate.NoOfDecimalNumberViewByExchangeRateId(decId);
cmbCurrency.SelectedValue = infoExchangeRate.CurrencyId.ToString();
dtpDate.Text = infoExchangeRate.Date.ToString();
txtExchangeRate.Text = Math.Round(Convert.ToDecimal(infoExchangeRate.Rate.ToString()), inNoOfDecimalPlaces).ToString();
txtNarration.Text = infoExchangeRate.Narration;
decExchangeRateId = infoExchangeRate.ExchangeRateId;
}
catch (Exception ex)
{
MessageBox.Show("ER13:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to get particular values from ExchangeRate Table based on the parameter
/// </summary>
/// <param name="exchangeRateId"></param>
/// <returns></returns>
public ExchangeRateInfo ExchangeRateView(decimal exchangeRateId)
{
ExchangeRateInfo exchangerateinfo = new ExchangeRateInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ExchangeRateView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal);
sprmparam.Value = exchangeRateId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
exchangerateinfo.ExchangeRateId = decimal.Parse(sdrreader[0].ToString());
exchangerateinfo.CurrencyId = decimal.Parse(sdrreader[1].ToString());
exchangerateinfo.Date = DateTime.Parse(sdrreader[2].ToString());
exchangerateinfo.Rate = decimal.Parse(sdrreader[3].ToString());
exchangerateinfo.Narration = sdrreader[4].ToString();
exchangerateinfo.ExtraDate = DateTime.Parse(sdrreader[5].ToString());
exchangerateinfo.Extra1 = sdrreader[6].ToString();
exchangerateinfo.Extra2 = sdrreader[7].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return(exchangerateinfo);
}
/// <summary>
/// Function to Update values in ExchangeRate Table
/// </summary>
/// <param name="exchangerateinfo"></param>
public void ExchangeRateEdit(ExchangeRateInfo exchangerateinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ExchangeRateEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal);
sprmparam.Value = exchangerateinfo.ExchangeRateId;
sprmparam = sccmd.Parameters.Add("@currencyId", SqlDbType.Decimal);
sprmparam.Value = exchangerateinfo.CurrencyId;
sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam.Value = exchangerateinfo.Date;
sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal);
sprmparam.Value = exchangerateinfo.Rate;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = exchangerateinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = exchangerateinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = exchangerateinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function for Save
/// </summary>
public void SaveFunction()
{
try
{
CompanyInfo infoCompany = new CompanyInfo();
CompanySP spCompany = new CompanySP();
CompanyPathInfo infoCompanyPath = new CompanyPathInfo();
CompanyPathSP spCompanyPath = new CompanyPathSP();
UserInfo infoUser = new UserInfo();
UserSP spUser = new UserSP();
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
infoCompany.CompanyName = txtCompanyName.Text.Trim();
infoCompany.MailingName = txtMailingName.Text.Trim();
infoCompany.Address = txtAddress.Text.Trim();
infoCompany.Phone = txtPhoneNo.Text.Trim();
infoCompany.Mobile = txtMobile.Text.Trim();
infoCompany.EmailId = txtEmail.Text.Trim();
infoCompany.Web = txtWeb.Text.Trim();
infoCompany.Country = txtCountry.Text.Trim();
infoCompany.State = txtState.Text.Trim();
infoCompany.Pin = txtPincode.Text.Trim();
infoCompany.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
decCurrencyIdForStatus = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoCompany.FinancialYearFrom = Convert.ToDateTime(txtFinancialYearFrom.Text.Trim().ToString());
infoCompany.BooksBeginingFrom = Convert.ToDateTime(txtBooksBegining.Text.Trim().ToString());
infoCompany.Tin = txtTinNo.Text.Trim();
infoCompany.Cst = txtCstNo.Text.Trim();
infoCompany.Pan = txtPanNo.Text.Trim();
infoCompany.CurrentDate = DateTime.Now;
infoCompany.Logo = logo;
infoCompany.Extra1 = string.Empty;
infoCompany.Extra2 = string.Empty;
infoCompanyPath.CompanyName = txtCompanyName.Text.Trim();
infoCompanyPath.IsDefault = cbxSetAsDefault.Checked;
infoCompanyPath.Extra1 = string.Empty;
infoCompanyPath.Extra2 = string.Empty;
infoUser.UserName = txtAdminUserName.Text.Trim();
infoUser.Password = txtPassword.Text.Trim();
infoUser.Active = true;
infoUser.Extra1 = string.Empty;
infoUser.Extra2 = string.Empty;
infoUser.Narration = string.Empty;
infoUser.RoleId = 1;
if (spCompany.CompanyCheckExistence(txtCompanyName.Text.Trim().ToString(), 0) == false)
{
decimal decCompanyId = spCompany.CompanyAddParticularFeilds(infoCompany);
PublicVariables._decCurrentCompanyId = decCompanyId;
infoCompanyPath.CompanyPath = Application.StartupPath + "\\Data\\" + PublicVariables._decCurrentCompanyId;
spCompanyPath.CompanyPathAdd(infoCompanyPath);
if (formMDI.demoProject || CreateCompany())
{
if (!formMDI.demoProject)
{
infoCompanyPath.CompanyPath = strPath;
}
else
{
infoCompanyPath.CompanyPath = Application.StartupPath + "\\Data";
PublicVariables._decCurrentCompanyId = 0;
}
CompanyInfo infoNewCompany = new CompanyInfo();
CompanySP spNewCompany = new CompanySP();
CompanyPathInfo infoNewCompanyPath = new CompanyPathInfo();
CompanyPathSP spNewCompanyPath = new CompanyPathSP();
UserInfo infoNewUser = new UserInfo();
UserSP spNewUser = new UserSP();
ExchangeRateInfo infoNewExchangeRate = new ExchangeRateInfo();
ExchangeRateSP spNewExchangeRate = new ExchangeRateSP();
infoNewCompany = infoCompany;
infoNewCompanyPath = infoCompanyPath;
infoNewUser = infoUser;
decCompanyId = spNewCompany.CompanyAddParticularFeilds(infoNewCompany);
spNewUser.UserAdd(infoNewUser);
spNewCompanyPath.CompanyPathAdd(infoNewCompanyPath);
Messages.SavedMessage();
formMDI.MDIObj.MenuStripEnabling();
// To set default currencyId.............//
infoNewExchangeRate.CurrencyId = infoNewCompany.CurrencyId;
infoNewExchangeRate.Rate = 1;
infoNewExchangeRate.Narration = string.Empty;
infoNewExchangeRate.Extra1 = string.Empty;
infoNewExchangeRate.Extra2 = string.Empty;
infoNewExchangeRate.ExtraDate = System.DateTime.Now;
infoNewExchangeRate.Date = System.DateTime.Now;
spNewExchangeRate.ExchangeRateAdd(infoNewExchangeRate);
CurrencySP spCurrency = new CurrencySP();
spCurrency.DefaultCurrencySet(decCurrencyIdForStatus);
AfterCompanyCreation();
Clear();
this.Close();
}
else
{
Messages.InformationMessage("Company creation failed");
}
}
else
{
Messages.InformationMessage("Companyname already exist");
txtCompanyName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("CR1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Edit
/// </summary>
public void EditFunction()
{
try
{
CompanyInfo infoCompany = new CompanyInfo();
CompanySP spCompany = new CompanySP();
CompanyPathInfo infoCompanyPath = new CompanyPathInfo();
CompanyPathSP spCompanyPath = new CompanyPathSP();
UserInfo infoUser = new UserInfo();
UserSP spUser = new UserSP();
infoCompany.CompanyName = txtCompanyName.Text.Trim();
infoCompany.MailingName = txtMailingName.Text.Trim();
infoCompany.Address = txtAddress.Text.Trim();
infoCompany.Phone = txtPhoneNo.Text.Trim();
infoCompany.Mobile = txtMobile.Text.Trim();
infoCompany.EmailId = txtEmail.Text.Trim();
infoCompany.Web = txtWeb.Text.Trim();
infoCompany.Country = txtCountry.Text.Trim();
infoCompany.State = txtState.Text.Trim();
infoCompany.Pin = txtPincode.Text.Trim();
infoCompany.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoCompany.FinancialYearFrom = Convert.ToDateTime(txtFinancialYearFrom.Text.Trim().ToString());
infoCompany.BooksBeginingFrom = Convert.ToDateTime(txtBooksBegining.Text.Trim().ToString());
infoCompany.Tin = txtTinNo.Text.Trim();
infoCompany.Cst = txtCstNo.Text.Trim();
infoCompany.Pan = txtPanNo.Text.Trim();
infoCompany.CurrentDate = DateTime.Now;
infoCompany.Logo = logo;
infoCompany.Extra1 = string.Empty;
infoCompany.Extra2 = string.Empty;
infoCompanyPath.CompanyName = txtCompanyName.Text.Trim();
infoCompanyPath.IsDefault = cbxSetAsDefault.Checked;
strPath = Application.StartupPath + "\\Data\\" + PublicVariables._decCurrentCompanyId;
infoCompanyPath.CompanyPath = strPath;
infoCompanyPath.Extra1 = string.Empty;
infoCompanyPath.Extra2 = string.Empty;
infoCompanyPath.ExtraDate = DateTime.Now;
infoUser.UserName = txtAdminUserName.Text.Trim();
infoUser.Password = txtPassword.Text.Trim();
infoUser.Active = true;
infoUser.Extra1 = string.Empty;
infoUser.Extra2 = string.Empty;
infoUser.Narration = string.Empty;
infoUser.RoleId = 1;
infoCompanyPath.CompanyId = 1;
infoCompany.CompanyId = 1;
infoUser.UserId = PublicVariables._decCurrentUserId;
spCompany.CompanyEdit(infoCompany);
spCompanyPath.CompanyPathEdit(infoCompanyPath);
spUser.UserEdit(infoUser);
Messages.UpdatedMessage();
// To set default currencyId...........In exchangeRate..//
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
infoExchangeRate.ExchangeRateId = 1;
infoExchangeRate.Date = PublicVariables._dtCurrentDate;
infoExchangeRate.CurrencyId = infoCompany.CurrencyId;
infoExchangeRate.ExtraDate = PublicVariables._dtCurrentDate;
infoExchangeRate.Narration = string.Empty;
infoExchangeRate.Rate = 1;
infoExchangeRate.Extra1 = string.Empty;
infoExchangeRate.Extra2 = string.Empty;
spExchangeRate.ExchangeRateEdit(infoExchangeRate);
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
FinancialYearSP spFinancialYear = new FinancialYearSP();
decimal decIdentity;
infoFinancialYear.FromDate = PublicVariables._dtFromDate;
infoFinancialYear.ToDate = PublicVariables._dtToDate;
infoFinancialYear.ExtraDate = DateTime.Now;
infoFinancialYear.Extra1 = string.Empty;
infoFinancialYear.Extra2 = string.Empty;
bool isExist = spFinancialYear.FinancialYearExistenceCheck(PublicVariables._dtFromDate, PublicVariables._dtToDate);
if (!isExist)
{
decIdentity = spFinancialYear.FinancialYearAddWithReturnIdentity(infoFinancialYear);
}
//===========Add companyDetails in ExternalDb =====================//
decimal decCompanyIdForTemp = PublicVariables._decCurrentCompanyId;
PublicVariables._decCurrentCompanyId = 0;
CompanySP spExCompany = new CompanySP();
CompanyPathSP spExCompanyPath = new CompanyPathSP();
CompanyInfo infoExCompany = new CompanyInfo();
CompanyPathInfo infoExCompanyPath = new CompanyPathInfo();
infoExCompany = infoCompany;
infoExCompanyPath = infoCompanyPath;
infoExCompany.CompanyId = decCompanyIdForTemp;
infoExCompanyPath.CompanyId = decCompanyIdForTemp;
spExCompany.CompanyEdit(infoExCompany);
spExCompanyPath.CompanyPathEdit(infoExCompanyPath);
PublicVariables._decCurrentCompanyId = decCompanyIdForTemp;
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("CR2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Fill the corresponding details of party and calculations on cell value changed
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvPartyBalance_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
PartyBalanceSP SpPartyBalance = new PartyBalanceSP();
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
if (dgvPartyBalance.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value == null || dgvPartyBalance.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value.ToString() == string.Empty)
{
dgvPartyBalance.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(1);//decExchangeRateId;
}
if (dgvPartyBalance.Rows[e.RowIndex].Cells[e.ColumnIndex].OwningColumn.Name == "dgvtxtAmount" || dgvPartyBalance.Rows[e.RowIndex].Cells[e.ColumnIndex].OwningColumn.Name == "dgvcmbCurrency")
{
TotalAmount();
}
//---------------------check column missing---------------------------------//
CheckColumnMissing(e);
//==========================================================================//
if (dgvPartyBalance.Rows[e.RowIndex].Cells[e.ColumnIndex].OwningColumn.Name == "dgvcmbReference")
{
if (dgvPartyBalance.CurrentRow.Cells["dgvcmbReference"].Value != null)//&& dgvPartyBalance.CurrentRow.Cells["dgvcmbReference"].Value.ToString() != string.Empty)
{
//to fill combo without filling the already selected value
if (dgvPartyBalance.CurrentRow.Cells["dgvcmbReference"].Value.ToString() == "Against")
{
dgvPartyBalance.CurrentRow.Cells["dgvcmbVoucherType"].ReadOnly = false;
if (frmJournalVoucherObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = strDebitOrCredit;
}
else if (frmPaymentVoucherObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Dr";
}
else if (frmReceiptVoucherObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Cr";
}
else if (frmPdcpayableObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Dr";
}
else if (frmPdcReceivableObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Cr";
}
}
else if (dgvPartyBalance.CurrentRow.Cells["dgvcmbReference"].Value.ToString() == "New")
{
dgvPartyBalance.CurrentRow.Cells["dgvcmbVoucherType"].ReadOnly = true;
dgvPartyBalance.CurrentRow.Cells["dgvcmbVoucherType"].Value = string.Empty;
dgvPartyBalance.CurrentRow.Cells["dgvtxtVoucherNo"].Value = null;
dgvPartyBalance.CurrentRow.Cells["dgvtxtPending"].Value = null;
dgvPartyBalance.CurrentRow.Cells["dgvcmbCurrency"].ReadOnly = false;
if (frmJournalVoucherObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = strDebitOrCredit;
}
else if (frmPaymentVoucherObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Dr";
}
else if (frmReceiptVoucherObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Cr";
}
else if (frmPdcpayableObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Dr";
}
else if (frmPdcReceivableObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Cr";
}
}
//
else if (dgvPartyBalance.CurrentRow.Cells["dgvcmbReference"].Value.ToString() == "OnAccount")
{
dgvPartyBalance.CurrentRow.Cells["dgvcmbVoucherType"].ReadOnly = true;
dgvPartyBalance.CurrentRow.Cells["dgvcmbVoucherType"].Value = string.Empty;
dgvPartyBalance.CurrentRow.Cells["dgvtxtVoucherNo"].Value = null;
dgvPartyBalance.CurrentRow.Cells["dgvtxtPending"].Value = null;
dgvPartyBalance.CurrentRow.Cells["dgvcmbCurrency"].ReadOnly = false;
if (frmJournalVoucherObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = strDebitOrCredit;
}
else if (frmPaymentVoucherObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Dr";
}
else if (frmReceiptVoucherObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Cr";
}
else if (frmPdcpayableObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Dr";
}
else if (frmPdcReceivableObj != null)
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtCrDr"].Value = "Cr";
}
}
}
}
else if (dgvPartyBalance.Rows[e.RowIndex].Cells[e.ColumnIndex].OwningColumn.Name == "dgvcmbVoucherType")
{
if (dgvPartyBalance.CurrentRow.Cells["dgvcmbVoucherType"].Value != null && dgvPartyBalance.CurrentRow.Cells["dgvcmbVoucherType"].Value.ToString().Trim() != string.Empty)
{
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
string str = dgvPartyBalance.CurrentRow.Cells["dgvcmbVoucherType"].Value.ToString();
string[] words;
words = str.Split('_');
DataTable dtbl = new DataTable();
dtbl = SpPartyBalance.PartyBalanceComboViewByLedgerId(decLedgerId, strDebitOrCredit, decVoucherTypeId, strVoucherNo);
for (int inD = 0; inD < dtbl.Rows.Count; inD++)
{
if (dgvPartyBalance.Rows[e.RowIndex].Cells["dgvcmbVoucherType"].Value.ToString() == dtbl.Rows[inD]["value"].ToString())
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtVoucherNo"].Value = dtbl.Rows[inD]["voucherNo"].ToString();
dgvPartyBalance.CurrentRow.Cells["dgvtxtPending"].Value = Math.Round(Convert.ToDecimal(dtbl.Rows[inD]["balance"].ToString()), PublicVariables._inNoOfDecimalPlaces);
dgvPartyBalance.CurrentRow.Cells["dgvtxtOldExchangeRateId"].Value = dtbl.Rows[inD]["exchangeRateId"].ToString();
if (Convert.ToDecimal(dtbl.Rows[inD]["exchangeRateId"].ToString()) != 1m)
{
infoExchangeRate = spExchangeRate.ExchangeRateView(Convert.ToDecimal(dtbl.Rows[inD]["exchangeRateId"].ToString()));
decimal decCurrentExchangeRateId = spExchangeRate.GetExchangeRateId(infoExchangeRate.CurrencyId, dtmVoucherDate);
if (decCurrentExchangeRateId == 0)
{
CurrencySP spCurrency = new CurrencySP();
CurrencyInfo infoCurrency = new CurrencyInfo();
infoCurrency = spCurrency.CurrencyView(infoExchangeRate.CurrencyId);
dgvPartyBalance.CurrentRow.Cells["dgvcmbCurrency"].Value = decCurrentExchangeRateId;
Messages.InformationMessage("Set ExchangeRate for "+infoCurrency.CurrencyName);
}
else
{
dgvPartyBalance.CurrentRow.Cells["dgvcmbCurrency"].Value = decCurrentExchangeRateId;
}
}
else
{
dgvPartyBalance.CurrentRow.Cells["dgvcmbCurrency"].Value = 1m;
}
dgvPartyBalance.CurrentRow.Cells["dgvtxtInvoiceNo"].Value = dtbl.Rows[inD]["invoiceNo"].ToString();
}
}
dgvPartyBalance.CurrentRow.Cells["dgvtxtAmount"].Value = null;
dgvPartyBalance.CurrentRow.Cells["dgvcmbCurrency"].ReadOnly = true;
}
//to make voucherno,pendingamount,invoiceno,currency as null when vouchertype is selected as empty
else
{
dgvPartyBalance.CurrentRow.Cells["dgvtxtVoucherNo"].Value = null;
dgvPartyBalance.CurrentRow.Cells["dgvtxtPending"].Value = null;
dgvPartyBalance.CurrentRow.Cells["dgvtxtAmount"].Value = null;
dgvPartyBalance.CurrentRow.Cells["dgvtxtInvoiceNo"].Value = null;
dgvPartyBalance.CurrentRow.Cells["dgvcmbCurrency"].Value = null;
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
dgvcmbCurrency.ReadOnly = false;
}
else
{
dgvcmbCurrency.ReadOnly = true;
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PB:16" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill controls for update
/// </summary>
public void FillControls()
{
try
{
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
infoExchangeRate = spExchangeRate.ExchangeRateView(decId);
int inNoOfDecimalPlaces = spExchangeRate.NoOfDecimalNumberViewByExchangeRateId(decId);
cmbCurrency.SelectedValue = infoExchangeRate.CurrencyId.ToString();
dtpDate.Text = infoExchangeRate.Date.ToString();
txtExchangeRate.Text = Math.Round(Convert.ToDecimal(infoExchangeRate.Rate.ToString()), inNoOfDecimalPlaces).ToString();
txtNarration.Text = infoExchangeRate.Narration;
decExchangeRateId = infoExchangeRate.ExchangeRateId;
}
catch (Exception ex)
{
MessageBox.Show("ER13:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to edit
/// </summary>
public void Editfunction()
{
try
{
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
infoExchangeRate.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoExchangeRate.Date = Convert.ToDateTime(dtpDate.Text.Trim().ToString());
infoExchangeRate.Rate = Convert.ToDecimal(txtExchangeRate.Text.Trim().ToString());
infoExchangeRate.Narration = txtNarration.Text.Trim();
infoExchangeRate.Extra1 = String.Empty;
infoExchangeRate.Extra2 = String.Empty;
infoExchangeRate.ExchangeRateId = decId;
if (spExchangeRate.ExchangeRateCheckExistence(Convert.ToDateTime(txtDate.Text.Trim().ToString()), Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()), decExchangeRateId) == false)
{
if (ExchangeRateCheck())
{
spExchangeRate.ExchangeRateEdit(infoExchangeRate);
Messages.UpdatedMessage();
SearchClear();
Clear();
}
}
else
{
Messages.InformationMessage("Already exists");
cmbCurrency.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("ER3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to get particular values from ExchangeRate Table based on the parameter
/// </summary>
/// <param name="exchangeRateId"></param>
/// <returns></returns>
public ExchangeRateInfo ExchangeRateView(decimal exchangeRateId)
{
ExchangeRateInfo exchangerateinfo = new ExchangeRateInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ExchangeRateView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal);
sprmparam.Value = exchangeRateId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
exchangerateinfo.ExchangeRateId = decimal.Parse(sdrreader[0].ToString());
exchangerateinfo.CurrencyId = decimal.Parse(sdrreader[1].ToString());
exchangerateinfo.Date = DateTime.Parse(sdrreader[2].ToString());
exchangerateinfo.Rate = decimal.Parse(sdrreader[3].ToString());
exchangerateinfo.Narration = sdrreader[4].ToString();
exchangerateinfo.ExtraDate = DateTime.Parse(sdrreader[5].ToString());
exchangerateinfo.Extra1 = sdrreader[6].ToString();
exchangerateinfo.Extra2 = sdrreader[7].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return exchangerateinfo;
}
