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