public bool Update(MenhGia MenhGia)
{
try
{
var _MenhGia = _dbContext.MenhGias.FirstOrDefault(x => x.Id == MenhGia.Id);
_MenhGia.cardId = MenhGia.cardId;
_MenhGia.Point = MenhGia.Point;
_MenhGia.Price = MenhGia.Price;
_MenhGia.unit_Price = MenhGia.unit_Price;
return(true);
}
catch
{
return(false);
}
}
public MenhGia AddMenhGia(MenhGia MenhGia)
{
MenhGia.Id = Guid.NewGuid().ToString();
return(_dbContext.MenhGias.Add(MenhGia).Entity);
}
//lay gia tri tai khoan von hien thoi cua menh gia tuong ung
private decimal actual_tkv(MenhGia lgd)
{
using (SqlConnection conn = new SqlConnection(Global_Class.awsserver))
{
using (SqlCommand cmd = new SqlCommand())
{
decimal ketqua = 0;
cmd.Connection = conn;
cmd.CommandText = "SELECT * from TaiKhoanVon Where Currency = @currency";
cmd.Parameters.Add(new SqlParameter("@currency", SqlDbType.NVarChar));
switch (lgd)
{
case MenhGia.euro:
cmd.Parameters["@currency"].Value = "euro";
break;
case MenhGia.usd:
cmd.Parameters["@currency"].Value = "usd";
break;
case MenhGia.vnd:
cmd.Parameters["@currency"].Value = "vnd";
break;
default:
break;
}
try
{
conn.Open();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
string tempo_kq;
tempo_kq = reader["Amount"].ToString();
if (String.IsNullOrEmpty(tempo_kq))
{
ketqua = 0;
}
else
{
ketqua = Decimal.Parse(reader["Amount"].ToString());
}
}
}
try
{
conn.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc.ToString());
}
return(ketqua);
}
}
}
