protected override void DoJob()
{
MagazineRepository rep = new MagazineRepository(OpConn);
string query = string.Format("DELETE FROM Magazine WHERE MagazineId = {0}", magazineId);
rep.BsExecute(query);
}
protected override void DoJob()
{
MagazineRepository rep = new MagazineRepository(OpConn);
string query = string.Format("UPDATE Magazine SET MagazineName = '{0}' WHERE MagazineId = {1}", magazine.MagazineName, magazine.MagazineId);
rep.BsExecute(query);
}
protected override void DoJob()
{
MagazineRepository rep = new MagazineRepository(OpConn);
string query = string.Format("DELETE FROM MagazineDate WHERE MagazineId = {0} AND Date = '{1}'",
obj.MagazineId, obj.Date.ToString("yyyy-MM-dd"));
rep.BsExecute(query);
}
protected override void DoJob()
{
MagazineRepository rep = new MagazineRepository(OpConn);
if (string.IsNullOrEmpty(magazineName))
{
throw new BsException("Boş girilemez", OpType.UserError);
}
List <Magazine> magazineList = rep.GetList();
if (magazineList.Any(mag => mag.MagazineName == magazineName))
{
throw new BsException("Zaten mevcut kayıt", OpType.UserError);
}
string query = string.Format("INSERT INTO Magazine (MagazineName) VALUES ('{0}')", magazineName);
rep.BsExecute(query);
}
