private string saveAllPostRows() { List<PostRowData> dd = getPostRowDatas(); if (dd == null) return "no data"; using (DB db = new DB(DBHelper.GetConnectionString(_currentClient))) { DowntimeReason dr; foreach (var item in dd) { var levels = item.Path.Split('>'); if (levels.Length < 3) Array.Resize(ref levels, 3); if (string.IsNullOrEmpty(levels[0]) && string.IsNullOrEmpty(levels[1]) && string.IsNullOrEmpty(levels[2])) continue; if (item.Id <= 0) { dr = new DowntimeReason { Level1 = levels[0], Level2 = levels[1], Level3 = levels[2], Duration = item.Duration, Client = _currentClient, HideReasonInReports = item.HideReasonInReports, Line = (!string.IsNullOrEmpty(Line) ? Line : "company-demo"), IsChangeOver = item.IsChangeOver }; db.AddToDowntimeReasonSet(dr); } else { var q = from o in db.DowntimeReasonSet where o.ID == item.Id && o.Client == _currentClient select o; dr = q.FirstOrDefault(); if (dr == null) continue; if ((string.IsNullOrEmpty(dr.Line) || dr.Line == "company-demo") && (!string.IsNullOrEmpty(Line) && Line != "company-demo"))//assumes it is a global reason code and they're adding a Line specific { DowntimeReason reason = new DowntimeReason { Level1 = levels[0], Level2 = levels[1], Level3 = levels[2], Duration = item.Duration, HideReasonInReports = item.HideReasonInReports, Line = (!string.IsNullOrEmpty(Line) ? Line : "company-demo"), IsChangeOver = item.IsChangeOver, Client = _currentClient }; db.AddToDowntimeReasonSet(reason); } else { dr.Level1 = levels[0]; dr.Level2 = levels[1]; dr.Level3 = levels[2]; dr.Duration = item.Duration; dr.HideReasonInReports = item.HideReasonInReports; dr.Line = (!string.IsNullOrEmpty(Line) ? Line : "company-demo"); dr.IsChangeOver = item.IsChangeOver; } } } //delete rows foreach (var item in getPostRowDatasDeleteRows()) { var q = from o in db.DowntimeReasonSet where o.ID == item && o.Client == _currentClient select o; dr = q.FirstOrDefault(); if (dr == null) continue; if(dr.Line == Line)//Don't want to accidently delete another Line's reason code db.DeleteObject(dr); } db.SaveChanges(); return "true"; } }
public string DeleteOption() { int id; int.TryParse(request.Form["id"], out id); if (id <= -1) return "FAILED"; using (DB db = new DB(DBHelper.GetConnectionString(_currentClient))) { Options tp = (from o in db.Options where o.Id == id select o).FirstOrDefault(); if (tp == null) return "FAILED"; db.DeleteObject(tp); int results = db.SaveChanges(); if (results >= 0) return "SUCCESS"; } return "FAILED"; }
private string delRecords() { string ids = request["ids"]; if (string.IsNullOrEmpty(ids)) return "Invald args."; using (DB db = new DB(DBHelper.GetConnectionString(_currentClient))) { foreach (var item in ids.Split(',')) { int id; if (!int.TryParse(item, out id)) continue; var q = from o in db.DowntimeDataSet where o.ID == id select o; var row = q.FirstOrDefault(); if (row != null) { db.DeleteObject(row); } } db.SaveChanges(); } return "true"; }
public static bool DeleteGoal(int id) { using (DB db = new DB()) { var q = from o in db.GoalSet where o.Id == id select o; Goal goal = q.FirstOrDefault(); if (goal == null) return false; db.DeleteObject(goal); return db.SaveChanges() > 0; } }
public static bool Delete(int id) { using (DB db = new DB(DBHelper.GetConnectionString())) { DigestEmail email = (from o in db.DigestEmails where o.Id == id select o).FirstOrDefault(); if (email != null) { db.DeleteObject(email); return db.SaveChanges() > 0; } } return false; }
public static void DeleteLine(int emailId, string line) { using (DB db = new DB(DBHelper.GetConnectionString())) { DigestEmail email = (from o in db.DigestEmails where o.Id == emailId select o).FirstOrDefault(); if (email != null) { email.DigestEmailLines.Load(); DigestEmailLine emailLine = (from o in email.DigestEmailLines where o.Line == line select o).FirstOrDefault(); if (emailLine != null) { db.DeleteObject(emailLine); db.SaveChanges(); } } } }
public static bool DeleteFromClient(int id, string client) { using (DB db = new DB(DBHelper.GetConnectionString())) { DigestEmail email = (from o in db.DigestEmails where o.Id == id && o.Client == client select o).FirstOrDefault(); if (email != null) { email.DigestEmailLines.Load(); foreach (DigestEmailLine line in email.DigestEmailLines.ToList()) db.DeleteObject(line); db.DeleteObject(email); return db.SaveChanges() > 0; } } return false; }