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