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