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)); }