public int DeleteInterviewPanel(InterviewPanelModel objUpdate) { using (var db = new RMS_Entities()) { var list = from data in db.T_IP_PanelLevel where data.PanelId == objUpdate.PanelId select data; //Delete Level foreach (T_IP_PanelLevel i in list) { var c = (from singledata in db.T_IP_PanelLevel where singledata.LevelId == i.LevelId && singledata.IsActive == 1 select singledata).FirstOrDefault(); if (c != null) { T_IP_PanelLevel objIPL = new T_IP_PanelLevel(); c.IsActive = 0; c.UpdatedBy = objUpdate.CreatedBy; c.UpdatedDate = DateTime.Today; } db.SaveChanges(); } //Delete Level var listDesign = from data in db.T_IP_PanelDesignation where data.PanelId == objUpdate.PanelId select data; //Delete Level foreach (T_IP_PanelDesignation i in listDesign) { var c = (from singledata in db.T_IP_PanelDesignation where singledata.PanelDesignationId == i.PanelDesignationId && singledata.IsActive == 1 select singledata).FirstOrDefault(); if (c != null) { T_IP_PanelDesignation objIPLD = new T_IP_PanelDesignation(); // c.PanelDesignationId = objIPLD.PanelDesignationId; c.IsActive = 0; c.UpdatedBy = objUpdate.CreatedBy; c.UpdatedDate = DateTime.Today; } db.SaveChanges(); } return(1); } }
public void Commit() { _db.SaveChanges(); _transaction.Complete(); }