public static ResponseBase InsertOrUpdate(ThoiGianTinhNhipDoTT obj)
{
var rs = new ResponseBase();
try
{
var db = new PMSEntities();
var old = db.ThoiGianTinhNhipDoTTs.FirstOrDefault(x => x.Ngay == obj.Ngay && x.MaChuyen == obj.MaChuyen);
if (old == null)
{
db.ThoiGianTinhNhipDoTTs.Add(obj);
}
else
{
old.ThoiGianBatDau = obj.ThoiGianBatDau;
}
db.SaveChanges();
rs.IsSuccess = true;
}
catch (Exception)
{
rs.IsSuccess = false;
}
return(rs);
}
public int SuaThongTinOBJ(ThoiGianTinhNhipDoTT obj)
{
int kq = 0;
try
{
string sql = "update ThoiGianTinhNhipDoTT set ThoiGianBatDau =N'" + obj.ThoiGianBatDau + "' where Ngay ='" + obj.Ngay + "' and MaChuyen=" + obj.MaChuyen + "";
kq = dbclass.TruyVan_XuLy(sql);
return(kq);
}
catch (Exception)
{
return(kq);
}
}
public int ThemOBJ(ThoiGianTinhNhipDoTT obj)
{
int kq = 0;
try
{
string sql = "insert into ThoiGianTinhNhipDoTT (Ngay, MaChuyen, ThoiGianBatDau) values(N'" + obj.Ngay + "'," + obj.MaChuyen + ",'" + obj.ThoiGianBatDau + "')";
kq = dbclass.TruyVan_XuLy(sql);
return(kq);
}
catch (Exception)
{
return(kq);
}
}
