public static void ChangeStatus(SurveyHedear survey)
{
try
{
using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities())
{
db.SurveyHedear.AddOrUpdate(survey);
// db.Entry(survey).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
//get all
//get by id
//add
//update
//delete
//todo
//public static long GetSurvey(int id)
//{
// using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities())
// {
// return db.SurveyHedears.Where();
// }
//}
public static long AddNewSurveyHeader(SurveyHedear surveyHedear)
{
try
{
using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities())
{
db.SurveyHedear.Add(surveyHedear);
db.SaveChanges();
return(surveyHedear.SurveyHedearId);
}
}
catch (Exception ex)
{
throw ex;
}
}
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 DeleteSurveyDetails(SurveyHedear survey)
{
using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities())
{
}
}