public bool remove(string c)
{
List <CaseHearingDate> list = db.CaseHearingDates.Where(x => x.CaseId == c).ToList();
foreach (CaseHearingDate i in list)
{
db.CaseHearingDates.Remove(i);
}
return(db.SaveChanges() > 0);
}
public bool saveChangesToDB(Client x)
{
Client changeClient = db.Clients.FirstOrDefault(s => s.ClientId == x.ClientId);
changeClient.ClientId = x.ClientId;
changeClient.ClientName = x.ClientName;
changeClient.ClientContact = x.ClientContact;
changeClient.ClientFname = x.ClientFname;
changeClient.ClientAddress = x.ClientAddress;
return(db.SaveChanges() > 0);
}
public bool deleteFromDB(UserAccount u)
{
MessageBoxResult result = 0;
UserAccount employee;
employee = db.UserAccounts.Where(x => u.userId == x.userId).FirstOrDefault();
db.UserAccounts.Remove(employee);
try
{
return(db.SaveChanges() > 0);
}
catch (DbUpdateException e)
{
result = MessageBox.Show("You cannot delete this record because " +
"Some Case records are associated this client ", "Information");
return(false);
}
}
public bool insertNewCase(Case c)
{
db.Cases.Add(c);
return(db.SaveChanges() > 0);
}
public bool insertNewCourt(Court court)
{
db.Courts.Add(court);
return(db.SaveChanges() > 0);
}
public void addNewRole(UserRole role)
{
db.UserRoles.Add(role);
db.SaveChanges();
}
