/// <summary>
///
/// </summary>
/// <param name="guid"></param>
/// <param name="date"></param>
/// <param name="famount"></param>
/// <param name="fcurrency"></param>
/// <param name="tamount"></param>
/// <param name="tcurrency"></param>
/// <returns></returns>
public string UpdCurrencyAndExchangeRate(string guid, DateTime date, Decimal famount, string fcurrency, Decimal tamount, string tcurrency)
{
bool result = false;
string msg = string.Empty;
T_RateHistory form = new T_RateHistory();
form.GUID = guid;
form.Date = date;
form.FAmount = famount;
form.FCurrency = fcurrency;
form.TAmount = tamount;
form.TCurrency = tcurrency;
form.C_GUID = Session["CurrentCompany"].ToString();
result = new CurrencySvc().UpdRateHistory(form);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
public bool UpdRateHistory(T_RateHistory rec)
{
DBHelper dh = new DBHelper();
dh.BeginTran();
try
{
dh.strCmd = "SP_UpdRateHistory";
dh.AddPare("@GUID", SqlDbType.NVarChar, 40, rec.GUID);
dh.AddPare("@Date", SqlDbType.DateTime, 0, rec.Date);
dh.AddPare("@FAmount", SqlDbType.Decimal, 0, rec.FAmount);
dh.AddPare("@FCurrency", SqlDbType.NVarChar, 40, rec.FCurrency);
dh.AddPare("@TAmount", SqlDbType.Decimal, 0, rec.TAmount);
dh.AddPare("@TCurrency", SqlDbType.NVarChar, 40, rec.TCurrency);
dh.AddPare("@C_GUID", SqlDbType.NVarChar, 40, rec.C_GUID);
dh.NonQuery();
dh.CleanPara();
dh.CommitTran();
return(true);
}
catch
{
dh.RollBackTran();
return(false);
}
}
