public int Delete(InterviewPanelModel Obj)
{
int result = 0;
using (TransactionScope Ts = new TransactionScope())
{
//Delete Panel Data
T_InterviewPanel objIP = new T_InterviewPanel();
objIP.PanelId = Obj.PanelId;
objIP = _IInterviewPanelRepository.SingleOrDefault(Obj.PanelId);
//Set The data which need to update
objIP.PanelId = Obj.PanelId;
objIP.IsActive = 0;
objIP.UpdatedBy = Obj.CreatedBy;
objIP.UpdatedDate = DateTime.Today;
result = _IInterviewPanelRepository.Delete(objIP);
//Delete Level
if (result == 1)
{
result = _IInterviewPanelRepository.DeleteInterviewPanel(Obj);
}
Ts.Complete();
return(1);
}
}
public int Insert(InterviewPanelModel Obj)
{
int PanelId = 0;
using (TransactionScope ts = new TransactionScope())
{
try
{
T_InterviewPanel ObjT_IP = new T_InterviewPanel();
ObjT_IP.EmpId = Obj.EmpId;
ObjT_IP.CandidateDesignations = Obj.CandidateDesignations;
ObjT_IP.CandidateDeptId = Obj.CandidateDeptId;
ObjT_IP.SecondarySkills = Obj.SecondarySkills;
ObjT_IP.LevelIds = Obj.LevelIds;
ObjT_IP.TrainingAttended = Convert.ToInt32(Obj.TrainingAttended);
ObjT_IP.Inducted = Convert.ToInt32(Obj.Inducted);
ObjT_IP.CreatedBy = Obj.CreatedBy;
ObjT_IP.IsActive = 1;
ObjT_IP.CreatedDate = DateTime.Now;
ObjT_IP = _IInterviewPanelRepository.Insert(ObjT_IP);
PanelId = ObjT_IP.PanelId;
//Save Level in Child table
string[] strLevel = Obj.LevelIds.Split(',');
for (int i = 0; i < strLevel.Length; i++)
{
T_IP_PanelLevel objIPL = new T_IP_PanelLevel();
objIPL.PanelId = ObjT_IP.PanelId;
objIPL.Empid = ObjT_IP.EmpId;
objIPL.LevelId = Convert.ToInt32(strLevel[i]);
objIPL.CreatedBy = Obj.CreatedBy;
objIPL.CreatedDate = DateTime.Now;
objIPL.IsActive = 1;
objIPL = _objIIPanelLevelRepository.Insert(objIPL);
//Save Designation againt Level
string[] strDesign = Obj.CandidateDesignations.Split(',');
for (int j = 0; j < strDesign.Length; j++)
{
T_IP_PanelDesignation objDes = new T_IP_PanelDesignation();
objDes.PanelId = ObjT_IP.PanelId;
objDes.Empid = ObjT_IP.EmpId;
objDes.LevelId = Convert.ToInt32(strLevel[i]);
objDes.DesignationId = Convert.ToInt32(strDesign[j]);
objDes.CreatedBy = Obj.CreatedBy;
objDes.CreatedDate = DateTime.Now;
objDes.IsActive = 1;
bool IslevelwiseDesignExist = _IInterviewPanelRepository.IsAlreadyExist(Convert.ToInt32(objDes.Empid), Convert.ToInt32(objDes.LevelId), Convert.ToInt32(objDes.DesignationId));
//If exist, skip furture save
if (IslevelwiseDesignExist)
{
ts.Dispose();
return(0);
}
objDes = _objIIPaneldesignationRepository.Insert(objDes);
}
}
ts.Complete();
}
catch (Exception ex)
{
ts.Dispose();
throw ex;
}
}
return(PanelId);
}
