//Save
public bool SaveCurrencyconversion(CurrencyConversionModel objCurcov)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@CurrencyDate", objCurcov.Date, System.Data.DbType.Date));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertCurrencyConversion", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
int id = 0;
dr.Read();
id = Convert.ToInt32(dr[0]);
SaveCurrencyConDetails(objCurcov.CurrenyDetails, id);
isSaved = true;
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (dtDate.Text.Equals(string.Empty))
{
MessageBox.Show("Date can not be blank!");
return;
}
CurrencyConversionModel objcurconv = new CurrencyConversionModel();
objcurconv.Date = Convert.ToDateTime(dtDate.Text.Trim());
CurrencyConversionDetailsModel objCurrency;
List <CurrencyConversionDetailsModel> lstCurrency = new List <CurrencyConversionDetailsModel>();
for (int i = 0; i < dvgCurrencyConvDetails.DataRowCount; i++)
{
DataRow row = dvgCurrencyConvDetails.GetDataRow(i);
objCurrency = new CurrencyConversionDetailsModel();
objCurrency.Currency = row["Currency"].ToString();
objCurrency.StandardRate = Convert.ToDecimal(row["TandardRate"].ToString());
objCurrency.SellingRate = Convert.ToDecimal(row["SellingRate"].ToString());
objCurrency.BuyingRate = Convert.ToDecimal(row["BuyingRate"].ToString());
lstCurrency.Add(objCurrency);
}
objcurconv.CurrenyDetails = lstCurrency;
bool isSuccess = objConBal.SaveCurrencyconversion(objcurconv);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
ClearFormValues();
Con_Id = 0;
}
}
//Save
public bool SaveCurrencyconversion(CurrencyConversionModel objCurcov)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Date", objCurcov.Date));
Query = "INSERT INTO CurrencyConversion(`Date`) " +
"VALUES(@Date)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public CurrencyConversionModel CalculateAmountForCurrencyConversion(CurrencyConversionModel currencyConversionModel)
{
CurrencyRecord firstDesiredCurrency = GetDesiredCurrency(currencyConversionModel.FirstCurrency, currencyConversionModel.Date);
CurrencyRecord secondDesiredCurrency = GetDesiredCurrency(currencyConversionModel.SecondCurrency, currencyConversionModel.Date);
currencyConversionModel.AmountSecondCurrency = currencyConversionModel.AmountFirstCurrency * firstDesiredCurrency.Close / secondDesiredCurrency.Close;
return(currencyConversionModel);
}
public async Task <CurrencyConversionModel> GetCurrencyConversionById(int currencyConversionId)
{
CurrencyConversionModel currencyConversionModel = null;
IList <CurrencyConversionModel> currencyConversionModelList = await GetCurrencyConversionList(currencyConversionId, 0);
if (null != currencyConversionModelList && currencyConversionModelList.Any())
{
currencyConversionModel = currencyConversionModelList.FirstOrDefault();
}
return(currencyConversionModel); // returns.
}
public async Task <bool> UpdateCurrencyConversion(CurrencyConversionModel currencyConversionModel)
{
bool isUpdated = false;
// get record.
Currencyconversion currencyConversion = await GetByIdAsync(w => w.ConversionId == currencyConversionModel.ConversionId);
if (null != currencyConversion)
{
// assign values.
currencyConversion.EffectiveDateTime = currencyConversionModel.EffectiveDateTime;
currencyConversion.ExchangeRate = currencyConversionModel.ExchangeRate;
isUpdated = await Update(currencyConversion);
}
return(isUpdated); // returns.
}
public async Task <CurrencyConversionModel> GetExchangeRateByCurrencyId(int currencyId, DateTime invoiceDate)
{
CurrencyConversionModel currencyConversionModel = null;
// create query.
if (await Any(w => w.CurrencyId == currencyId && w.EffectiveDateTime <= invoiceDate))
{
Currencyconversion currencyConversion =
await GetQueryByCondition(w => w.CurrencyId == currencyId && w.EffectiveDateTime <= invoiceDate)
.Include(w => w.Currency).Include(w => w.Company).Include(w => w.PreparedByUser)
.OrderByDescending(w => w.EffectiveDateTime).FirstOrDefaultAsync();
currencyConversionModel = await AssignValueToModel(currencyConversion);
}
return(currencyConversionModel); // returns.
}
private async Task <CurrencyConversionModel> AssignValueToModel(Currencyconversion currencyConversion)
{
return(await Task.Run(() =>
{
CurrencyConversionModel currencyConversionModel = new CurrencyConversionModel();
currencyConversionModel.ConversionId = currencyConversion.ConversionId;
currencyConversionModel.CompanyId = currencyConversion.CompanyId;
currencyConversionModel.CurrencyId = currencyConversion.CurrencyId;
currencyConversionModel.EffectiveDateTime = currencyConversion.EffectiveDateTime;
currencyConversionModel.ExchangeRate = currencyConversion.ExchangeRate;
// ###
currencyConversionModel.CompanyName = currencyConversion.Company.CompanyName;
currencyConversionModel.CurrencyName = currencyConversion.Currency.CurrencyName;
currencyConversionModel.PreparedByName = currencyConversion.PreparedByUser.UserName;
return currencyConversionModel;
}));
}
public async Task <int> CreateCurrencyConversion(CurrencyConversionModel currencyConversionModel)
{
int currencyConversionId = 0;
// assign values.
Currencyconversion currencyConversion = new Currencyconversion();
currencyConversion.ConversionId = currencyConversionModel.ConversionId;
currencyConversion.CompanyId = currencyConversionModel.CompanyId;
currencyConversion.CurrencyId = currencyConversionModel.CurrencyId;
currencyConversion.EffectiveDateTime = currencyConversionModel.EffectiveDateTime;
currencyConversion.ExchangeRate = currencyConversionModel.ExchangeRate;
await Create(currencyConversion);
currencyConversionId = currencyConversion.ConversionId;
return(currencyConversionId); // returns.
}
public async Task <JsonResult> GetExchangeRateByCurrencyId(int currencyId, DateTime invoiceDate)
{
JsonData <JsonStatus> data = new JsonData <JsonStatus>(new JsonStatus());
CurrencyConversionModel currencyConversionModel = await
_currencyConversion.GetExchangeRateByCurrencyId(currencyId, invoiceDate);
if (null != currencyConversionModel)
{
data.Result.Status = true;
data.Result.Data = currencyConversionModel.ExchangeRate;
}
else
{
data.Result.Data = "0";
}
return(Json(data)); // returns.
}
public IActionResult ShowResultCurrencyConversion(CurrencyConversionModel model)
{
if (!ModelState.IsValid)
{
return(View("FormOfCurrencyConversion", model));
}
if (!_currencyNameChecker.CheckingIfCurrencyNamesAreDifferent(model.FirstCurrency, model.SecondCurrency))
{
ViewBag.ResultChekingCurrencyNameInConversion = "Currencies name must different";
return(View("FormOfCurrencyConversion", model));
}
if (!_dateChecker.CheckingIfDateExistsForTwoCurrencies(model.Date, model.FirstCurrency, model.SecondCurrency))
{
ViewBag.DateRangeForConversion = _dateRange.GetDateRangeTwoCurrencies(model.FirstCurrency, model.SecondCurrency);
return(View("FormOfCurrencyConversion", model));
}
return(View(_currencyConversionService.CalculateAmountForCurrencyConversion(model)));
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (Date.Text.Equals(string.Empty))
{
MessageBox.Show("Date can not be blank!");
return;
}
CurrencyConversionModel objcurconv = new CurrencyConversionModel();
objcurconv.Date = Convert.ToDateTime(Date.Text.Trim());
bool isSuccess = objCurcov.SaveCurrencyconversion(objcurconv);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
}
}
public async Task <IActionResult> ShowResultCurrencyConversion(CurrencyConversionModel model)
{
ViewData["currencyCodes"] = await _currenciesSelectList.GetCurrencyCodes(User.Identity.Name);
if (!ModelState.IsValid)
{
return(View("FormOfCurrencyConversion", model));
}
if (!_currencyNameChecker.AreDifferent(model.FirstCurrency, model.SecondCurrency))
{
ViewBag.NameErrorInfo = "Currencies name must different";
return(View("FormOfCurrencyConversion", model));
}
if (!(await _dateChecker.CheckIfDateExistsForTwoCurrencies(model.Date, model.FirstCurrency, model.SecondCurrency)))
{
ViewBag.CommonDateRangeInfo = await _dateRange.GetCommonDateRangeForTwoCurrencies(model.FirstCurrency, model.SecondCurrency);
return(View("FormOfCurrencyConversion", model));
}
return(View(await _currencyConversionService.CalculateCurrencyConversionAmount(model)));
}
private void btnUpdate_Click(object sender, EventArgs e)
{
CurrencyConversionModel objcurconv = new CurrencyConversionModel();
objcurconv.Date = Convert.ToDateTime(dtDate.Text.Trim());
CurrencyConversionDetailsModel objCurrency;
List <CurrencyConversionDetailsModel> lstCurrency = new List <CurrencyConversionDetailsModel>();
for (int i = 0; i < dvgCurrencyConvDetails.DataRowCount; i++)
{
DataRow row = dvgCurrencyConvDetails.GetDataRow(i);
objCurrency = new CurrencyConversionDetailsModel();
objCurrency.Currency = row["Currency"].ToString();
objCurrency.StandardRate = Convert.ToDecimal(row["TandardRate"].ToString());
objCurrency.SellingRate = Convert.ToDecimal(row["SellingRate"].ToString());
objCurrency.BuyingRate = Convert.ToDecimal(row["BuyingRate"].ToString());
if (Con_Id != 0)
{
objCurrency.id = Convert.ToInt32(row["id"].ToString() == string.Empty?"0":row["id"].ToString());
objCurrency.ParentId = Convert.ToInt32(row["ParentId"].ToString() == string.Empty?"0": row["ParentId"].ToString());
}
lstCurrency.Add(objCurrency);
}
objcurconv.CurrenyDetails = lstCurrency;
objcurconv.CcID = Con_Id;
bool isSuccess = objConBal.UpdateCurrencyconversion(objcurconv);
if (isSuccess)
{
MessageBox.Show("Update Successfully!");
ClearFormValues();
Con_Id = 0;
Administration.List.CurrencyconversionList frmList = new Administration.List.CurrencyconversionList();
frmList.StartPosition = FormStartPosition.CenterScreen;
frmList.ShowDialog();
FillCurrencyConversionInfo();
}
}
//Get List of Currency Conversions
public List <CurrencyConversionModel> GetCurrencyConversionbyId(int id)
{
List <CurrencyConversionModel> lstCurrCon = new List <CurrencyConversionModel>();
CurrencyConversionModel objCurrCon;
string Query = "SELECT * FROM `currencyconversion` WHERE `CC_Id`=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objCurrCon = new CurrencyConversionModel();
objCurrCon.CcID = Convert.ToInt32(dr["CC_Id"]);
objCurrCon.Date = Convert.ToDateTime(dr["Date"].ToString());
//SELECT Currency Conversion Details
string CurrQuery = "SELECT * FROM `currencyconversiondetails` WHERE `CC_Id`=" + id;
System.Data.IDataReader drConn = _dbHelper.ExecuteDataReader(CurrQuery, _dbHelper.GetConnObject());
objCurrCon.CurrenyDetails = new List <CurrencyConversionDetailsModel>();
CurrencyConversionDetailsModel objCurrency;
while (drConn.Read())
{
objCurrency = new CurrencyConversionDetailsModel();
objCurrency.id = Convert.ToInt32(drConn["Currency_Id"]);
objCurrency.ParentId = Convert.ToInt32(drConn["CC_Id"]);
objCurrency.StandardRate = Convert.ToDecimal(drConn["TandardRate"]);
objCurrency.SellingRate = Convert.ToDecimal(drConn["SellingRate"]);
objCurrency.BuyingRate = Convert.ToDecimal(drConn["BuyingRate"]);
objCurrency.Currency = drConn["Currency"].ToString();
objCurrCon.CurrenyDetails.Add(objCurrency);
}
lstCurrCon.Add(objCurrCon);
}
return(lstCurrCon);
}
public async void CurrencyConversionService_is_conversion_correct()
{
//Arange
CurrencyConversionService testService = CreateCurrencyConversionService();
CurrencyConversionModel currencyConversionModel = new CurrencyConversionModel();
currencyConversionModel.FirstCurrency = _firstCurrencyName;
currencyConversionModel.SecondCurrency = _secondCurrencyName;
currencyConversionModel.AmountFirstCurrency = 10;
currencyConversionModel.Date = _commonDate;
float expectedResult = currencyConversionModel.AmountFirstCurrency * _firstCurrencyCloseValue / _secondCurrencyCloseValue;
bool resultFlag = false;
//Act
currencyConversionModel = await testService.CalculateCurrencyConversionAmount(currencyConversionModel);
if (currencyConversionModel.AmountSecondCurrency == expectedResult)
{
resultFlag = true;
}
//Asert
Assert.True(resultFlag);
}
public async Task <CurrencyConversionModel> CalculateCurrencyConversionAmount(CurrencyConversionModel currencyConversionModel)
{
CurrencyRecord firstDesiredCurrency = await GetDesiredCurrency(currencyConversionModel.FirstCurrency, currencyConversionModel.Date);
CurrencyRecord secondDesiredCurrency = await GetDesiredCurrency(currencyConversionModel.SecondCurrency, currencyConversionModel.Date);
currencyConversionModel.AmountSecondCurrency = currencyConversionModel.AmountFirstCurrency * firstDesiredCurrency.Close / secondDesiredCurrency.Close;
return(currencyConversionModel);
}
//UPDATE Currency Convresion
public bool UpdateCurrencyconversion(CurrencyConversionModel objCurcov)
{
string Query = string.Empty;
bool isUpdate = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@CurrencyDate", objCurcov.Date, System.Data.DbType.Date));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ParentId", objCurcov.CcID));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spUpdateCurrencyConversion", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
List <CurrencyConversionDetailsModel> lstConn = new List <CurrencyConversionDetailsModel>();
//UPDATE Currency Conversion Grid
foreach (CurrencyConversionDetailsModel conver in objCurcov.CurrenyDetails)
{
if (conver.id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ParentId", (conver.ParentId)));
paramCollection.Add(new DBParameter("@Currency", (conver.Currency)));
paramCollection.Add(new DBParameter("@TandardRate", conver.StandardRate, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@SellingRate", conver.SellingRate, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@BuyingRate", conver.BuyingRate, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@CurrencyId", conver.id));
System.Data.IDataReader drcurr =
_dbHelper.ExecuteDataReader("spUpdateCurrencyConversionDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@ParentId", (objCurcov.CcID)));
paramCollection.Add(new DBParameter("@Currency", (conver.Currency)));
paramCollection.Add(new DBParameter("@TandardRate", conver.StandardRate, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@SellingRate", conver.SellingRate, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@BuyingRate", conver.BuyingRate, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
//paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
System.Data.IDataReader drcurr =
_dbHelper.ExecuteDataReader("spInsertCurrencyConversionDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
}
}
isUpdate = true;
}
catch (Exception ex)
{
isUpdate = false;
throw ex;
}
return(isUpdate);
}