/// <summary> /// On datagridview cell double click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvExchangeRate_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { ExchangeRateBll BllExchangeRate = new ExchangeRateBll(); if (e.RowIndex != -1) { decId = Convert.ToDecimal(dgvExchangeRate.Rows[e.RowIndex].Cells["dgvtxtExchangeRateId"].Value.ToString()); bool Status = BllExchangeRate.ExchangeRateCheckExistanceForUpdationAndDelete(Convert.ToDateTime(txtDate.Text.ToString()), decId); if (Status) { FillControls(); btnSave.Text = "Update"; btnDelete.Enabled = true; cmbCurrency.Focus(); } else { Messages.ReferenceExistsMessageForUpdate(); } } } catch (Exception ex) { MessageBox.Show("ER25:" + 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 datagridview /// </summary> public void GridFill() { try { ExchangeRateBll BllExchangeRate = new ExchangeRateBll(); List <DataTable> listObj = new List <DataTable>(); listObj = BllExchangeRate.ExchangeRateSearch(cmbCurrencyRate.Text.ToString(), Convert.ToDateTime(txtDatefrom.Text.ToString()), Convert.ToDateTime(txtDateTo.Text.ToString())); dgvExchangeRate.DataSource = listObj[0]; } catch (Exception ex) { MessageBox.Show("ER9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public int NoofDecimalPlacesFind() { int inNoOfDecimalPlaces = 0; try { ExchangeRateBll BllExchangeRate = new ExchangeRateBll(); if (cmbCurrency.SelectedValue != null) { inNoOfDecimalPlaces = BllExchangeRate.NoOfDecimalNumberViewByCurrencyId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString())); } } catch (Exception) { throw; } return(inNoOfDecimalPlaces); }
/// <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 delete /// </summary> public void DeleteFunction() { try { ExchangeRateBll BllExchangeRate = new ExchangeRateBll(); if (BllExchangeRate.ExchangeRateCheckReferences(decId) == -1) { Messages.ReferenceExistsMessage(); } else { Messages.DeletedMessage(); Clear(); GridFill(); } } catch (Exception ex) { MessageBox.Show("ER10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }