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;
}
}
//List All Currencys
public List <CurrencyConversionDetailsModel> GetAllCurrencyConversions()
{
List <CurrencyConversionDetailsModel> lstCurr = new List <CurrencyConversionDetailsModel>();
CurrencyConversionDetailsModel objCurr;
StringBuilder sbQuery = new StringBuilder();
sbQuery.Append("SELECT C.Date,C.CC_Id,A.Currency,A.TandardRate, A.SellingRate,A.BuyingRate FROM currencyconversion C ");
sbQuery.Append("INNER JOIN currencyconversiondetails A ");
sbQuery.Append("ON A.CC_Id = C.CC_Id ");
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(sbQuery.ToString(), _dbHelper.GetConnObject());
while (dr.Read())
{
objCurr = new CurrencyConversionDetailsModel();
objCurr.Date = Convert.ToDateTime(dr["Date"]);
objCurr.id = Convert.ToInt32(dr["CC_Id"]);
objCurr.Currency = dr["Currency"].ToString();
objCurr.StandardRate = Convert.ToDecimal(dr["TandardRate"].ToString());
objCurr.SellingRate = Convert.ToDecimal(dr["SellingRate"].ToString());
objCurr.BuyingRate = Convert.ToDecimal(dr["BuyingRate"].ToString());
lstCurr.Add(objCurr);
}
return(lstCurr);
}
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);
}
