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