public bool UpdateBenh(DTO_Benh benh, string tenBenhMoi)
{
using (var context = new SQLServerDBContext())
{
var benhMatch = context.Benh.Where(t => t.TenBenh.Equals(tenBenhMoi, StringComparison.OrdinalIgnoreCase));
if (benhMatch == null)
{
return(false);
}
benh.TenBenh = tenBenhMoi;
return(true);
}
}
public async Task <DTO_Benh> AddBenhAsync(DTO_Benh benh)
{
ObservableCollection <DTO_Benh> benhs = await DALManager.BenhDAL.GetListBenhAsync();
//if (benhs.Any(b => b.TenBenh.Equals(benh.TenBenh, StringComparison.OrdinalIgnoreCase) && b.IsDeleted == true))
//{
// benhs.Where(b => b.TenBenh.Equals(benh.TenBenh, StringComparison.OrdinalIgnoreCase) && b.IsDeleted == true).FirstOrDefault().IsDeleted = false;
// return true;
//}
if (benhs.Any(b => b.TenBenh.Equals(benh.TenBenh, StringComparison.OrdinalIgnoreCase)))
{
return(null);
}
benh.MaBenh = await DALManager.BenhDAL.AddBenhAsync(benh);
return(benh);
}
public async Task <string> AddBenhAsync(DTO_Benh benh)
{
using (var context = new SQLServerDBContext())
{
string res = null;
try
{
var tenBenh = new SqlParameter("@1", System.Data.SqlDbType.NVarChar);
tenBenh.Value = benh.TenBenh;
res = await context.Database.SqlQuery <string>("exec proc_Benh_insert @1",
new SqlParameter[]
{
tenBenh
}).FirstOrDefaultAsync();
}
catch (Exception e)
{
Debug.WriteLine("[ERROR] " + e.Message);
}
return(res);
}
}
public bool UpdateBenh(DTO_Benh benh, string tenBenhMoi)
{
return(DALManager.BenhDAL.UpdateBenh(benh, tenBenhMoi));
}
