public ActionResult EditInterviewPanel(InterviewPanelViewModel obj, FormCollection objf)
{
InterviewPanelModel objI = new InterviewPanelModel();
if (obj.Mode == "A")
{
int result = AddIP(obj, objf);
if (result == 0)
{
TempData["Message"] = "Interview Panel has not added";
return(RedirectToAction("AddInterviewPanel"));
}
//TempData["Message"] = "Interview Panel added successfully";
return(RedirectToAction("AddInterviewPanel"));
}
if (obj.Mode == "U")
{
objI.PanelId = Convert.ToInt32(CheckAccessAttribute.Decode(objf["InterviewPanelId"]));
objI.EmpId = obj.EmpId;
objI.CandidateDesignations = objf["lstDesignation"];
objI.SecondarySkills = objf["lstSkill"];
objI.LevelIds = objf["chkLevel"];
objI.TrainingAttended = obj.TrainingAttendedId;
objI.Inducted = obj.InductedId;
objI.CreatedBy = Convert.ToInt32(Session["EmpID"]);
int result = _objIInterviewPanelService.UpdateInterviewPanel(objI);
if (objI.PanelId != 0)
{
TempData["Message"] = "Interview Panel updated successfully";
return(RedirectToAction("AddInterviewPanel"));
}
}
return(View());
}
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 UpdateInterviewPanel(InterviewPanelModel objUpdate)
{
using (var _context = new RMS_Entities())
{
var GetIPList = _context.Usp_IP_UpdateIP(objUpdate.PanelId, objUpdate.EmpId, objUpdate.CandidateDeptId, objUpdate.CandidateDesignations, objUpdate.SecondarySkills, objUpdate.LevelIds, objUpdate.Inducted, objUpdate.TrainingAttended, objUpdate.CreatedBy)
.ToList();
return(0);
}
}
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 List <InterviewPanelModel> GetInterviewPanelSearch(string Technology, string Level, string DeptId, string Designation,
string BusinessVertical, string Skill)
{
List <InterviewPanelModel> objIPList = new List <InterviewPanelModel>();
InterviewPanelModel objIP;
using (var result = new RMS_Entities())
{
var GetIPList = result.USP_IP_GetInterviewPanelSearch(Convert.ToInt32(Technology),
Convert.ToInt32(Level),
Convert.ToInt32(DeptId),
Convert.ToInt32(Designation),
Convert.ToInt32(BusinessVertical)
, Skill).ToList <USP_IP_GetInterviewPanelSearch_Result>();
foreach (var obj in GetIPList)
{
objIP = new InterviewPanelModel();
objIP.PanelId = obj.PANELID;
objIP.PanelIdEncr = CommonRepository.Encode(obj.PANELID.ToString());
objIP.EmpId = Convert.ToInt32(obj.EMPID);
objIP.EmpName = obj.EMPNAME;
objIP.DesignationName = obj.DesignationName;
objIP.LINEMANAGER = obj.LINEMANAGER;
objIP.BusinessVertical = obj.BUSINESSVERTICAL;
objIP.EmpSecondarySkill = obj.SECONDARYSKILL;
objIP.PrimarySkillName = obj.PRIMARYSKILLNAME;
objIP.CandidateDeptId = Convert.ToInt32(obj.CANDIDATEDEPTID);
objIP.DEPTName = obj.DEPTNAME;
objIP.CandidateDesignations = obj.CANDIDATEDESIGNATIONS;
objIP.CandidateDesignationName = obj.CANDIDATEDESIGNATIONNAME;
objIP.SecondarySkills = obj.SECONDARYSKILLS;
objIP.SecondarySkillname = obj.SECONDARYSKILLNAME;
objIP.LevelIds = obj.LEVELIDS;
objIP.levelidName = obj.LEVELIDNAME;
objIP.Inducted = Convert.ToInt32(obj.INDUCTED);
objIP.InductedName = obj.INDUCTEDNAME;
objIP.TrainingAttended = Convert.ToInt32(obj.TRAININGATTENDED);
objIP.TrainingAttendedName = obj.TRAININGATTENDEDNAME;
objIP.PageMode = "S";
objIPList.Add(objIP);
}
}
return(objIPList);
}
public string IsAlreadyExist(InterviewPanelModel Obj)
{
string strResult = "";
//using (TransactionScope ts = new TransactionScope())
//{
try
{
string[] strLevel = Obj.LevelIds.Split(',');
for (int i = 0; i < strLevel.Length; i++)
{
//Save Designation againt Level
string[] strDesg = Obj.CandidateDesignations.Split(',');
for (int j = 0; j < strDesg.Length; j++)
{
bool IslevelwiseDesignExist = _IInterviewPanelRepository.IsAlreadyExist(Convert.ToInt32(Obj.EmpId),
Convert.ToInt32(strLevel[i]), Convert.ToInt32(strDesg[j]));
//If exist, skip furture save
if (IslevelwiseDesignExist)
{
T_Master objLevel = new T_Master();
objLevel = _objIMasterRepository.SingleOrDefault(Convert.ToInt32(strLevel[i]));
//SelectList SL = _objEmployeeService.GetSkillTypesCategory();
IEnumerable <SelectListItem> SL = _objEmployeeService.FillDesignationList(Convert.ToInt32(Obj.CandidateDeptId));
string DesignationName = SL.Where(p => p.Value == strDesg[j]).First().Text;
strResult = DesignationName + " Designation has already been entered for " + objLevel.Name + " Level";
//ts.Dispose();
return(strResult);
}
}
}
//ts.Complete();
}
catch (Exception ex)
{
//ts.Dispose();
throw ex;
}
//}
return(strResult);
}
public ActionResult DeleteInterviewPanel(string InterviewPanelId)
{
InterviewPanelViewModel objVm = new InterviewPanelViewModel();
int _InterviewPanelid = Convert.ToInt32(CheckAccessAttribute.Decode(InterviewPanelId));
InterviewPanelModel objI = new InterviewPanelModel();
objI.PanelId = _InterviewPanelid;
//Get single list
int i = _objIInterviewPanelService.Delete(objI);
if (i > 0)
{
objVm.Message = "Interview Panel deleted successfully";
TempData["Message"] = "Interview Panel deleted successfully";
return(RedirectToAction("AddInterviewPanel"));
}
return(View());
}
int AddIP(InterviewPanelViewModel obj, FormCollection objf)
{
InterviewPanelModel objI = new InterviewPanelModel();
if (obj.Mode == "A")
{
objI.EmpId = obj.EmpId;
//objI.EmpId = Convert.ToInt32(objf["hfldEmpid"]);
objI.CandidateDeptId = obj.CandidateDeptId;
objI.CandidateDesignations = objf["lstDesignation"];
objI.SecondarySkills = objf["lstSkill"];
objI.LevelIds = objf["chkLevel"];
objI.TrainingAttended = obj.TrainingAttendedId;
objI.Inducted = obj.InductedId;
objI.CreatedBy = Convert.ToInt32(Session["EmpID"]);
string strErrorMessage = _objIInterviewPanelService.IsAlreadyExist(objI);
if (strErrorMessage == "")
{
objI.PanelId = _objIInterviewPanelService.Insert(objI);
if (objI.PanelId != 0)
{
TempData["Message"] = "Interview Panel added successfully";
obj = init(obj);
obj.ListAllIP = _objIInterviewPanelService.GetInterviewPanel(0, 0);
return(1);// RedirectToAction("AddInterviewPanel");
}
else
{
return(0);
}
}
else
{
TempData["Message"] = strErrorMessage;
return(2);// RedirectToAction("AddInterviewPanel");
}
}
return(1);
}
//public List<InterviewPanelModel> GetInterviewPanel(InterviewPanelModel objIP)
public List <InterviewPanelModel> GetInterviewPanel(int PanelId, int Empid)
{
List <InterviewPanelModel> objIPList = new List <InterviewPanelModel>();
InterviewPanelModel objIP;
using (var result = new RMS_Entities())
{
var GetIPList = result.USP_IP_GetInterviewPanel(Convert.ToInt32(PanelId), Convert.ToInt32(Empid)).ToList <USP_IP_GetInterviewPanel_Result>();
foreach (var obj in GetIPList)
{
objIP = new InterviewPanelModel();
objIP.PanelId = obj.panelid;
objIP.PanelIdEncr = CommonRepository.Encode(obj.panelid.ToString());
objIP.EmpId = Convert.ToInt32(obj.empid);
objIP.EmpIdEncr = CommonRepository.Encode(obj.empid.ToString());
objIP.EmpName = obj.EmpName;
objIP.DesignationName = obj.DesignationName;
objIP.LINEMANAGER = obj.LINEMANAGER;
objIP.PrimarySkillName = obj.PrimarySkillName;
objIP.CandidateDeptId = Convert.ToInt32(obj.CandidateDeptId);
//objIP.DEPTName = obj.DEPTName;
objIP.CandidateDesignations = obj.CandidateDesignations;
objIP.CandidateDesignationName = obj.CandidateDesignationName;
objIP.SecondarySkills = obj.SecondarySkills;
objIP.SecondarySkillname = obj.SecondarySkillname;
objIP.LevelIds = obj.levelids;
objIP.levelidName = obj.levelidName;
objIP.Inducted = Convert.ToInt32(obj.Inducted);
objIP.InductedName = obj.InductedName;
objIP.TrainingAttended = Convert.ToInt32(obj.TrainingAttended);
objIP.TrainingAttendedName = obj.TrainingAttendedName;
objIP.EmpSecondarySkill = obj.SecondarySkill;
objIP.BusinessVertical = obj.BusinessVertical;
objIP.PageMode = "V";
objIPList.Add(objIP);
}
}
return(objIPList);
}
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);
}
public int UpdateInterviewPanel(InterviewPanelModel objUpdate)
{
return(_IInterviewPanelRepository.UpdateInterviewPanel(objUpdate));
}
