public void Add(Model.Rate rate)
{
_ema1.Add(rate);
_ema2.Add(rate);
_signal.Add(new Model.Rate()
{
Bid = MACDLineBid, Ask = MACDLineAsk, CurrencyPair = rate.CurrencyPair, RateDateTime = rate.RateDateTime
});
}
public string UpdateRate1(string code, string Id, string cn, string tw, string en, string th, string vn, string uName, string Rate)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("");
}
string json = "";
if (json != "stop")
{
Model.Rate rate = new Model.Rate();
rate.Name_cn = cn;
rate.Name_tw = tw;
rate.Name_en = en;
rate.Name_th = th;
rate.Name_vn = vn;
rate.Code = code;
rate.Id = Convert.ToInt32(Id);
rate.Rate1 = Convert.ToDecimal(Rate);
rate.Lasttime = DateTime.Now;
Model.Manager m = Session[ProjectConfig.ADMINUSER] as Model.Manager;
rate.Operator = m.ManagerId;
string strHostName = Dns.GetHostName();
System.Net.IPAddress[] addressList = Dns.GetHostByName(Dns.GetHostName()).AddressList;
rate.Ip = addressList[0].ToString();
bool reval = BLL.RateManager.UpdateRate(rate);
if (reval)
{
bool ret = BLL.RatehistoryManager.AddRatehistory(rate);
if (ret)
{
//Rates rates = new Rates();
Model.Rate rates = new Model.Rate();
rates.Name_cn = cn;
rates.Name_tw = tw;
rates.Name_en = en;
rates.Name_th = th;
rates.Name_vn = vn;
rates.Rate1 = Convert.ToDecimal(Rate);
rates.Lasttime = DateTime.Now;
rates.Operator = m.ManagerId;
rates.Ip = addressList[0].ToString();
json = DAL.ObjectToJson.ObjectsToJson <Model.Rate>(rates);
}
else
{
json = "none";
}
}
}
return(json);
}
public string AddRate(string code, string Name, string Rate, string Language)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("");
}
Model.Rate rate = new Model.Rate();
if (Language == "cn")
{
rate.Name_cn = Name;
}
if (Language == "tw")
{
rate.Name_tw = Name;
}
if (Language == "en")
{
rate.Name_en = Name;
}
if (Language == "th")
{
rate.Name_th = Name;
}
if (Language == "vn")
{
rate.Name_vn = Name;
}
rate.Rate1 = Convert.ToDecimal(Rate);
rate.Lasttime = DateTime.Now;
Model.Manager m = Session[ProjectConfig.ADMINUSER] as Model.Manager;
rate.Operator = m.ManagerId;
rate.Code = code;
string strHostName = Dns.GetHostName();
System.Net.IPAddress[] addressList = Dns.GetHostByName(Dns.GetHostName()).AddressList;
rate.Ip = addressList[0].ToString();
bool reval = BLL.RateManager.AddRate(rate);
if (reval)
{
Rates rates = new Rates();
rates.Name = Name;
rates.Rate = Convert.ToDecimal(Rate);
rates.Lasttime = DateTime.Now;
rates.Operator = m.ManagerId;
rates.Ip = addressList[0].ToString();
return(DAL.ObjectToJson.ObjectsToJson <Rates>(rates));
}
else
{
return("none");
}
}
public static bool SaveRate(Model.Rate rate)
{
using (SqlConnection con = new SqlConnection(@"Data Source = VIVEK-PC\SQLEXPRESS; Initial Catalog=Forex; Integrated Security=SSPI;"))
{
con.Open();
using (SqlCommand comm = new SqlCommand("dbo.SaveRates", con))
{
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add(new SqlParameter("@currency", rate.CurrencyPair));
comm.Parameters.Add(new SqlParameter("@inDate", rate.RateDateTime));
comm.Parameters.Add(new SqlParameter("@bid", rate.Bid));
comm.Parameters.Add(new SqlParameter("@ask", rate.Ask));
comm.ExecuteNonQuery();
}
con.Close();
}
return(true);
}
public string UpdateRate(string Id, string Name, string uName, string Rate, string Language)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("");
}
string json = "";
if (Name != uName)
{
if (RateManager.CeliName(Name, Language))
{
json = "stop";
}
}
if (json != "stop")
{
Model.Rate rate = new Model.Rate();
if (Language == "cn")
{
rate.Name_cn = Name;
}
if (Language == "tw")
{
rate.Name_tw = Name;
}
if (Language == "en")
{
rate.Name_en = Name;
}
if (Language == "th")
{
rate.Name_th = Name;
}
if (Language == "vn")
{
rate.Name_vn = Name;
}
rate.Id = Convert.ToInt32(Id);
rate.Rate1 = Convert.ToDecimal(Rate);
rate.Lasttime = DateTime.Now;
Model.Manager m = Session[ProjectConfig.ADMINUSER] as Model.Manager;
rate.Operator = m.ManagerId;
string strHostName = Dns.GetHostName();
System.Net.IPAddress[] addressList = Dns.GetHostByName(Dns.GetHostName()).AddressList;
rate.Ip = addressList[0].ToString();
bool reval = BLL.RateManager.UpdateRate(rate);
if (reval)
{
bool ret = BLL.RatehistoryManager.AddRatehistory(rate);
if (ret)
{
Rates rates = new Rates();
rates.Name = Name;
rates.Rate = Convert.ToDecimal(Rate);
rates.Lasttime = DateTime.Now;
rates.Operator = m.ManagerId;
rates.Ip = addressList[0].ToString();
json = DAL.ObjectToJson.ObjectsToJson <Rates>(rates);
}
else
{
json = "none";
}
}
}
return(json);
}
