public static void RemoveTenant(tenant_tbl tenant)
{
using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities())
{
db.Entry(tenant).State = EntityState.Deleted;
db.SaveChanges();
}
}
public static void RemoveUserNotification(user_notification_tbl u)
{
using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities())
{
//db.user_notification_tbl.Remove(u);
db.Entry(u).State = EntityState.Deleted;
db.SaveChanges();
}
}
public static void DeleteSurvey(SurveyHedear survey)
{
try
{
using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities())
{
db.Entry(survey).State = EntityState.Deleted;
List <SurveyDetails> sd = db.SurveyDetails.Where(s => s.SurveyHedearId == survey.SurveyHedearId).ToList();
foreach (var item in sd)
{
db.Entry(item).State = EntityState.Deleted;
}
db.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateStatus(fault_tbl fault)
{
try
{
using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities())
{
db.Entry(fault).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
catch
{
throw;
}
}
public static void UpdateTenantDetails(tenant_tbl tenant)
{
try
{
using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities())
{
db.Entry(tenant).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
}
