public ActionResult ExcuseRequests()
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSExcuseRequestServicesClient sdexcusereq = new ESSWebService.SDSExcuseRequestServicesClient();
sdexcusereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdexcusereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var ss = (from a in sdexcusereq.getAllExcuseReqeustByNature(callcont, username, ESSWebService.SDSExcuseNature.Excuse, compid).parmExcuseRequestList
select new DTOExcuseRequest
{
RequestId = a.RequestId,
ExcuseType = ESSWebService.SDSExcuseNature.Excuse.ToString(),
Date = a.RequestDate.ToShortDateString(),
ExcuseId = a.ExcuseType,
PersonalNumber = a.NameEn.Split('-')[0],
Name = a.NameEn.Split('-')[1],
State = a.WorkflowStatus.ToString(),
URL = "/ExcuseRequest/ViewExcuseRequestbyId?requestid=" + a.RequestId,
}).ToList();
return(View(ss));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public string Workflowforrequest(string requesid)
{
string workcom = "";
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSExcuseRequestServicesClient sdsworkcom = new ESSWebService.SDSExcuseRequestServicesClient();
sdsworkcom.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdsworkcom.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
ESSWebService.SDSWorkflowApprovalWorkItemHistory workflowHistory = sdsworkcom.getWorkflowHistory(callcont, requesid);
if (workflowHistory != null)
{
foreach (ESSWebService.SDSWorkflowApprovalWorkItemComment wfHistory in workflowHistory.Comments)
{
if (wfHistory.IsStep == 0)
{
workcom = workcom + (wfHistory.Time + " - " + wfHistory.ActionLabel + " - " + "Comments : " + wfHistory.Comment) + " \n";
}
else
{
workcom = workcom + (wfHistory.StepName) + " \n";
}
}
}
return(workcom);
}
public JsonResult getexecustypesforTraining()
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSExcuseRequestServicesClient sdexcusereq = new ESSWebService.SDSExcuseRequestServicesClient();
sdexcusereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdexcusereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var retreasons = sdexcusereq.getExcuseTypeIdByNature(callcont, ESSWebService.SDSExcuseNature.Training, compid).parmExcuseTypeIdList;
return(Json(retreasons, JsonRequestBehavior.AllowGet));
}
public ActionResult ViewExcuseRequestbyId(string requestid)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSExcuseRequestServicesClient sdseosreq = new ESSWebService.SDSExcuseRequestServicesClient();
sdseosreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdseosreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var ss = sdseosreq.getExcuseReqeust(callcont, requestid, compid);
ss.NameAr = Workflowforrequest(requestid);
return(View(ss));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public string RejecteExcuseRequestbyRequestNumber(string requestid, string Comment)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSExcuseRequestServicesClient sdleavereq = new ESSWebService.SDSExcuseRequestServicesClient();
sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdleavereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
ESSWebService.ExcuseRequest _crleavereq = new ESSWebService.ExcuseRequest();
_crleavereq = sdleavereq.getPendingWorkflowList(callcont, username).parmExcuseRequestList.Where(x => x.RequestId == requestid).FirstOrDefault();
return(sdleavereq.Reject(callcont, _crleavereq.WorkflowItem, username, Comment));
}
else
{
RedirectToAction("Login", "Account");
return("");
// return _perinfo;
}
}
public string CreateExcuseRequestbyNature(string reason, string execuseid, string comment,
string excusenature, string frmtime, string totime, string requestdate)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
string g = "";
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSExcuseRequestServicesClient sdsexcreq = new ESSWebService.SDSExcuseRequestServicesClient();
sdsexcreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
ESSWebService.ExcuseRequest _creeosreq = new ESSWebService.ExcuseRequest();
sdsexcreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
_creeosreq.Comments = comment;
//_creeosreq.RequestDate = DateTime.Now;
_creeosreq.RequestDate = new DateTime(Convert.ToInt32(requestdate.Split('/')[2]), Convert.ToInt32(requestdate.Split('/')[1]), Convert.ToInt32(requestdate.Split('/')[0]));
_creeosreq.WorkerRecId = username;
_creeosreq.ExcuseType = execuseid == "-1" ? null : execuseid;
_creeosreq.ReasonCode = reason == "-1" ? null : reason;
_creeosreq.FromTime = Helper.Helper.Timetoint(frmtime);
_creeosreq.ToTime = Helper.Helper.Timetoint(totime);
//_creeosreq.FromTime = 2;
//_creeosreq.ToTime = 2;
if (_creeosreq.ToTime >= _creeosreq.FromTime)
{
g = sdsexcreq.createExcuseRequestByNature(callcont, _creeosreq, (ESSWebService.SDSExcuseNature)Convert.ToInt32(excusenature), compid);
}
else
{
g = "Totime should be greater than from date";
}
return(g);
}
else
{
RedirectToAction("Login", "Account");
return("");
}
}
public ActionResult Details(string Detail, string Group)
{
List <DTOCommonDetailsList> _commondetails = new List <DTOCommonDetailsList>();
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
DateTime _nulldate = new DateTime(1990, 1, 1);
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.SDSPersonalInfoServicesClient sd = new ESSWebService.SDSPersonalInfoServicesClient();
ESSWebService.SDSBankInfoServicesClient sdbank = new ESSWebService.SDSBankInfoServicesClient();
ESSWebService.SDSBenefitsInfoServiceClient sdbenfits = new ESSWebService.SDSBenefitsInfoServiceClient();
ESSWebService.SDSDependentInfoServicesClient sddepend = new ESSWebService.SDSDependentInfoServicesClient();
ESSWebService.SDSExcuseRequestServicesClient sdexcreq = new ESSWebService.SDSExcuseRequestServicesClient();
ESSWebService.SDSIdentificationInfoServicesClient sdidenreq = new ESSWebService.SDSIdentificationInfoServicesClient();
ESSWebService.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
// ESSWebService.sds sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sd.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
sdbank.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdbank.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
sddepend.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sddepend.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
sdexcreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdexcreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
sdidenreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdidenreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdleavereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
sdbenfits.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdbenfits.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
ESSPortal.ESSWebService.PersonalInfo perinfoser = sd.getOnePersonalInfo(callcont, username);
var competencies = sd.getCompetencies(callcont, username, compid);
var jobs = sd.getJobdetails(callcont, username);
var medinsurance = sd.getMedicalInsuranceList(callcont, username, compid);
DTOCommonDetailsList itemaddr = new DTOCommonDetailsList();
DTOCommonDetailsList itemContact = new DTOCommonDetailsList();
DTOCommonDetailsList itemBanks = new DTOCommonDetailsList();
DTOCommonDetailsList itemDepend = new DTOCommonDetailsList();
DTOCommonDetailsList itemexecreq = new DTOCommonDetailsList();
DTOCommonDetailsList itemidenti = new DTOCommonDetailsList();
DTOCommonDetailsList itemleavereq = new DTOCommonDetailsList();
DTOCommonDetailsList itempersonalcontact = new DTOCommonDetailsList();
DTOCommonDetailsList itembenifits = new DTOCommonDetailsList();
DTOCommonDetailsList itembenifitLines = new DTOCommonDetailsList();
DTOCommonDetailsList itemCompetencies = new DTOCommonDetailsList();
DTOCommonDetailsList itemJobs = new DTOCommonDetailsList();
DTOCommonDetailsList itemMedicalInsurance = new DTOCommonDetailsList();
DTOCommonDetailsList itempersonalinfo = new DTOCommonDetailsList();
DTOCommonDetailsList itempersocontact = new DTOCommonDetailsList();
List <DTOPersonalContact> lstpersocontact = new List <DTOPersonalContact>();
DTOCommonDetailsList itemCertificationList = new DTOCommonDetailsList();
DTOCommonDetailsList itemCourseList = new DTOCommonDetailsList();
DTOCommonDetailsList itemEducaitonList = new DTOCommonDetailsList();
DTOCommonDetailsList itemPositionofTrustList = new DTOCommonDetailsList();
DTOCommonDetailsList itemProjectexperiencelist = new DTOCommonDetailsList();
DTOCommonDetailsList itemProjectrolelist = new DTOCommonDetailsList();
DTOCommonDetailsList itemSkilllistComp = new DTOCommonDetailsList();
DTOCommonDetailsList itemAreaofRespobsibiltyList = new DTOCommonDetailsList();
DTOCommonDetailsList itemSkilllistJob = new DTOCommonDetailsList();
DTOCommonDetailsList itemWorkTaskList = new DTOCommonDetailsList();
DTOCommonDetailsList itemmedicalinshdr = new DTOCommonDetailsList();
DTOPersonalContact additem = new DTOPersonalContact();
additem.EmergencyContact = perinfoser.Perosnalcontactemergency;
additem.Name = perinfoser.Perosnalcontactname;
additem.RelationShip = perinfoser.Perosnalcontactrelationship;
lstpersocontact.Add(additem);
//perinfoser.Perosnalconta
// perinfoser.ContactList.
itempersonalinfo.Key = "PersonalInfo";
itempersonalinfo.GroupKey = "PersonalInfo";
itempersonalinfo.DisplayName = Helper.Resources.getDescriptionBykey("Personal Informations");
itempersonalinfo.tabledata = new List <DataTable>();
itempersonalinfo.PersonalNumber = perinfoser.Personnelnumber;
itempersonalinfo.EnglishName = perinfoser.EnglishName;
itempersonalinfo.JoiningDate = perinfoser.Joiningdate == _nulldate ? "-" : perinfoser.Joiningdate.ToShortDateString();
itempersonalinfo.Gender = perinfoser.Gender == 1 ? "Male" : "Female";
itempersonalinfo.OldID = perinfoser.OldId;
itempersonalinfo.ArabicName = perinfoser.ArabicName;
itempersonalinfo.MaritalStatus = perinfoser.Maritalstatus == 1 ? "Single" : "Married";
itempersonalinfo.ProbhotionEndDate = perinfoser.ProbationEndDate == _nulldate ? "-" : perinfoser.ProbationEndDate.ToShortDateString();
_commondetails.Add(itempersonalinfo);
itemaddr.Key = "Address";
itemaddr.GroupKey = "PersonalInfo";
itemaddr.DisplayName = Helper.Resources.getDescriptionBykey("Address");
itemaddr.tabledata = new List <DataTable>();
itemaddr.tabledata.Add(FormDynamicDetailsView(perinfoser.AddressList.parmAddressList, "Address"));
_commondetails.Add(itemaddr);
itemContact.tabledata = new List <DataTable>();
itemContact.Key = "Contacts";
itemContact.GroupKey = "PersonalInfo";
itemContact.DisplayName = Helper.Resources.getDescriptionBykey("Contacts");
var contdisp = perinfoser.ContactList.parmContactList;
var displist = (from a in contdisp
select new DTOContacts
{
ContactNumber = a.ContactNumber,
Description = a.Description,
Extension = a.Extension,
IsPrimary = a.IsPrimary.ToString(),
Type = a.Type.ToString()
}).ToList();
itemContact.tabledata.Add(FormDynamicDetailsView(displist, "Contacts"));
_commondetails.Add(itemContact);
itempersocontact.Key = "PersonalContact";
itempersocontact.DisplayName = Helper.Resources.getDescriptionBykey("Personal Contact");
itempersocontact.GroupKey = "PersonalInfo";
itempersocontact.tabledata = new List <DataTable>();
itempersocontact.tabledata.Add(FormDynamicDetailsView(lstpersocontact, "PersonalContact"));
_commondetails.Add(itempersocontact);
itembenifits.tabledata = new List <DataTable>();
var beninfo = sdbenfits.getBenefitsInfo(callcont, username);
itembenifits.AirportFrom = beninfo.Airportfrom;
itembenifits.AirportTo = beninfo.Airportto;
itembenifits.ContractEndDate = beninfo.ContractEndDate == _nulldate ? "-" : beninfo.ContractEndDate.ToShortDateString();
itembenifits.ContractStartDate = beninfo.ContractStartDate == _nulldate ? "-" : beninfo.ContractStartDate.ToShortDateString();
itembenifits.Garde = beninfo.Grade;
itembenifits.SalaryScale = beninfo.SalaryScale;
itembenifits.Paygroup = beninfo.PayGroup;
itembenifits.BasicSalary = beninfo.BasicSalary.ToString();
itembenifits.AnualLeave = beninfo.Annualleave.ToString();
itembenifits.NoofTickets = beninfo.Nooftickets.ToString();
itembenifits.TicketClass = beninfo.Ticketclass.ToString();
itembenifits.TicketRate = beninfo.Ticketrates.ToString();
itembenifits.Key = "ContractInfo";
itembenifits.DisplayName = Helper.Resources.getDescriptionBykey("Contract Details");
itembenifits.GroupKey = "Benifits";
_commondetails.Add(itembenifits);
itembenifitLines.tabledata = new List <DataTable>();
itembenifitLines.Key = "Benifits";
itembenifitLines.GroupKey = "Benifits";
itembenifitLines.DisplayName = Helper.Resources.getDescriptionBykey("Benefit Details");
var benfillist = sdbenfits.getBenefitsAndAllowDeduList(callcont, username).Benefitsallowancesdeductionslist.parmbenefitsAllowDedList;
var todisp = (from a in benfillist
select new DTOBenifits
{
BenifitID = a.BenefitsId,
BenifitType = a.BenefitsType.ToString(),
Percent = a.Percent.ToString(),
xAmount = a.Amount.ToString()
}).ToList();
itembenifitLines.tabledata.Add(FormDynamicDetailsView(todisp, "Benifits"));
_commondetails.Add(itembenifitLines);
itemBanks.tabledata = new List <DataTable>();
itemBanks.tabledata.Add(FormDynamicDetailsView(sdbank.getAllBankInfoList(callcont, username).parmBankInfoList, "Banks"));
itemBanks.Key = "Banks";
itemBanks.GroupKey = "Banks";
itemBanks.DisplayName = Helper.Resources.getDescriptionBykey("Banks");
_commondetails.Add(itemBanks);
itemSkilllistComp.tabledata = new List <DataTable>();
itemSkilllistComp.tabledata.Add(FormDynamicDetailsView(competencies.Skilllist.parmList, "SkilllistComp"));
itemSkilllistComp.Key = "SkilllistComp";
itemSkilllistComp.GroupKey = "Skills";
itemSkilllistComp.DisplayName = Helper.Resources.getDescriptionBykey("Skills");
_commondetails.Add(itemSkilllistComp);
itemCertificationList.tabledata = new List <DataTable>();
itemCertificationList.tabledata.Add(FormDynamicDetailsView(competencies.CertificationList.parmList, "CertificationList"));
itemCertificationList.Key = "CertificationList";
itemCertificationList.GroupKey = "Skills";
itemCertificationList.DisplayName = Helper.Resources.getDescriptionBykey("Certificates");
_commondetails.Add(itemCertificationList);
itemCourseList.tabledata = new List <DataTable>();
itemCourseList.tabledata.Add(FormDynamicDetailsView(competencies.CourseList.parmList, "CourseList"));
itemCourseList.Key = "CourseList";
itemCourseList.GroupKey = "Skills";
itemCourseList.DisplayName = Helper.Resources.getDescriptionBykey("Courses");
_commondetails.Add(itemCourseList);
itemEducaitonList.tabledata = new List <DataTable>();
itemEducaitonList.tabledata.Add(FormDynamicDetailsView(competencies.EducaitonList.parmList, "EducaitonList"));
itemEducaitonList.Key = "EducaitonList";
itemEducaitonList.GroupKey = "Skills";
itemEducaitonList.DisplayName = Helper.Resources.getDescriptionBykey("Educaiton");
_commondetails.Add(itemEducaitonList);
itemPositionofTrustList.tabledata = new List <DataTable>();
itemPositionofTrustList.tabledata.Add(FormDynamicDetailsView(competencies.PositionofTrustList.parmList, "PositionofTrustList"));
itemPositionofTrustList.Key = "PositionofTrustList";
itemPositionofTrustList.GroupKey = "Skills";
itemPositionofTrustList.DisplayName = Helper.Resources.getDescriptionBykey("Position Trust");
_commondetails.Add(itemPositionofTrustList);
itemProjectexperiencelist.tabledata = new List <DataTable>();
itemProjectexperiencelist.tabledata.Add(FormDynamicDetailsView(competencies.Projectexperiencelist.parmList, "Projectexperiencelist"));
itemProjectexperiencelist.Key = "Projectexperiencelist";
itemProjectexperiencelist.GroupKey = "Skills";
itemProjectexperiencelist.DisplayName = Helper.Resources.getDescriptionBykey("Project Experience");
_commondetails.Add(itemProjectexperiencelist);
itemProjectrolelist.tabledata = new List <DataTable>();
itemProjectrolelist.tabledata.Add(FormDynamicDetailsView(competencies.Projectrolelist.parmList, "Projectrolelist"));
itemProjectrolelist.Key = "Projectrolelist";
itemProjectrolelist.GroupKey = "Skills";
itemProjectrolelist.DisplayName = Helper.Resources.getDescriptionBykey("Project Role");
_commondetails.Add(itemProjectrolelist);
itemJobs.tabledata = new List <DataTable>();
itemJobs.PositionId = jobs.PositionId;
itemJobs.PositionDescription = jobs.Positiondescription;
itemJobs.Department = perinfoser.DepartmentName;
itemJobs.ReportToLineManagerName = perinfoser.LineManagerName;
itemJobs.PositionType = perinfoser.PositionType;
itemJobs.PositionCompensation = perinfoser.Positiondescription;
itemJobs.JobType = perinfoser.JobTypeId;
itemJobs.JobFunction = perinfoser.JobFunctionId;
itemJobs.JobId = perinfoser.JobId;
itemJobs.ReporttoPositionManagerId = perinfoser.PositionLineManagerposition;
itemJobs.PositioinCompensationName = perinfoser.Compenstationregion;
itemJobs.Key = "Jobs";
itemJobs.GroupKey = "Jobs";
itemJobs.DisplayName = Helper.Resources.getDescriptionBykey("Jobs");
_commondetails.Add(itemJobs);
itemAreaofRespobsibiltyList.tabledata = new List <DataTable>();
itemAreaofRespobsibiltyList.Key = "AreaofRespobsibiltyList";
itemAreaofRespobsibiltyList.GroupKey = "Jobs";
itemAreaofRespobsibiltyList.DisplayName = Helper.Resources.getDescriptionBykey("Area of Responsibility");
itemAreaofRespobsibiltyList.tabledata.Add(FormDynamicDetailsView(jobs.AreaofRespobsibiltyList.parmList, "AreaofRespobsibiltyList"));
_commondetails.Add(itemAreaofRespobsibiltyList);
itemSkilllistJob.tabledata = new List <DataTable>();
itemSkilllistJob.tabledata.Add(FormDynamicDetailsView(jobs.SkillList.parmList, "SkilllistJob"));
itemSkilllistJob.Key = "SkilllistJob";
itemSkilllistJob.GroupKey = "Jobs";
itemSkilllistJob.DisplayName = Helper.Resources.getDescriptionBykey("Skills");
_commondetails.Add(itemSkilllistJob);
itemWorkTaskList.tabledata = new List <DataTable>();
itemWorkTaskList.tabledata.Add(FormDynamicDetailsView(jobs.WorkTaskList.parmList, "WorkTaskList"));
itemWorkTaskList.Key = "WorkTaskList";
itemWorkTaskList.GroupKey = "Jobs";
itemWorkTaskList.DisplayName = Helper.Resources.getDescriptionBykey("Job Task");
_commondetails.Add(itemWorkTaskList);
itemDepend.tabledata = new List <DataTable>();
var dependencies = sddepend.getAllDependentInfoList(callcont, username, compid).parmIdentificationInfoList;
var disp = (from a in dependencies
select new
{
ArabicName = a.ArabicName,
BirthDate = a.BirthDate == _nulldate ? "-" : a.BirthDate.ToShortDateString(),
DependentId = a.DependentId,
EnglishName = a.EnglishName,
MedicalInsuranceCover = a.Medicalinsurancecover.ToString(),
Relationship = a.Relationship,
TicketCover = a.TicketCover.ToString()
}).ToList();
itemDepend.tabledata.Add(FormDynamicDetailsView(disp, "Dependencies"));
itemDepend.Key = "Dependencies";
itemDepend.GroupKey = "Dependencies";
itemDepend.DisplayName = Helper.Resources.getDescriptionBykey("Dependents");
_commondetails.Add(itemDepend);
itemexecreq.tabledata = new List <DataTable>();
itemexecreq.tabledata.Add(FormDynamicDetailsView(sdexcreq.getAllExcuseReqeust(callcont, username, compid).parmExcuseRequestList, "ExecuseRequests"));
itemexecreq.Key = "ExecuseRequests";
itemexecreq.GroupKey = "ExecuseRequests";
itemexecreq.DisplayName = Helper.Resources.getDescriptionBykey("Excuse Requests");
_commondetails.Add(itemexecreq);
itemmedicalinshdr.tabledata = new List <DataTable>();
itemmedicalinshdr.Key = "itemmedicalinshdr";
itemmedicalinshdr.GroupKey = "MedicalInsurance";
itemmedicalinshdr.DisplayName = Helper.Resources.getDescriptionBykey("Medical Insurance");
itemMedicalInsurance.tabledata = new List <DataTable>();
var insurance = medinsurance.parmMedicalInsuranceList;
var inslist = (from a in insurance
where a.PolicyFor != "Worker"
select new DTOMedicalInsurancelst
{
DependentName = a.DependentNameAr,
// Endurance = a.Endurance.ToString(),
MembershipId = a.MembershipId,
PolicyLevel = a.Policylevel,
// PolicyFor = a.PolicyFor,'
DependentNameEnglish = a.DependentNameEn,
PolicyNumber = a.PolicyNumber,
PregnencyCover = a.PregnancyCovered.ToString(),
Room = a.Room
}).ToList();
var inshdr = (from a in insurance
where a.PolicyFor == "Worker"
select new DTOMedicalInsurance
{
WorkerName = a.WorkerName,
WorkerRecId = a.WorkerRecid.ToString(),
DentalLimit = a.DentalLimit.ToString(),
DependentNameArabic = a.DependentNameAr,
DependentNameEnglish = a.DependentNameEn,
Endurance = a.Endurance.ToString(),
OccuralLimit = a.OcularLimir.ToString(),
PolicyFor = a.PolicyFor,
PolicyLevel = a.Policylevel,
PolicyNumber = a.PolicyNumber,
Room = a.Room,
FromDate = a.FromDateTime == _nulldate ? "-" : a.FromDateTime.ToShortDateString(),
ToDate = a.ToDateTime == _nulldate ? "-" : a.ToDateTime.ToShortDateString(),
TotalLimit = a.TotalLimit.ToString(),
}).FirstOrDefault();
if (inshdr != null)
{
itemmedicalinshdr.DentalLimit = inshdr.DentalLimit;
itemmedicalinshdr.Endurance = inshdr.Endurance;
itemmedicalinshdr.OccuralLimit = inshdr.OccuralLimit;
itemmedicalinshdr.PolicyLevel = inshdr.PolicyLevel;
itemmedicalinshdr.FromDate = inshdr.FromDate;
itemmedicalinshdr.ToDate = inshdr.ToDate;
itemmedicalinshdr.WorkerName = inshdr.WorkerName;
itemmedicalinshdr.TotalLimit = inshdr.TotalLimit;
itemMedicalInsurance.tabledata.Add(FormDynamicDetailsView(inslist, "MedicalInsurancelst"));
itemMedicalInsurance.Key = "MedicalInsurancelst";
itemMedicalInsurance.GroupKey = "MedicalInsurance";
itemMedicalInsurance.DisplayName = Helper.Resources.getDescriptionBykey("Medical Insurance Dependents");
_commondetails.Add(itemmedicalinshdr);
_commondetails.Add(itemMedicalInsurance);
}
itemidenti.tabledata = new List <DataTable>();
var identilist = sdidenreq.getAllIdentificationList(callcont, username, compid).parmIdentificationInfoList;
var dispiden = (from a in identilist
select new
{
IdentificationNumber = a.IdentificationNumber,
IdentificationType = a.IdentificationType,
IssueAgency = a.IssueAgency,
IssueDate = a.IssueDate == _nulldate ? "-" : a.IssueDate.ToShortDateString(),
EndDate = a.EndDate == _nulldate ? "-" : a.EndDate.ToShortDateString(),
IssuePlace = a.Issueplace,
}).ToList();
itemidenti.tabledata.Add(FormDynamicDetailsView(dispiden, "Identifications"));
itemidenti.Key = "Identifications";
itemidenti.GroupKey = "Identifications";
itemidenti.DisplayName = Helper.Resources.getDescriptionBykey("Identifications");
_commondetails.Add(itemidenti);
itemleavereq.tabledata = new List <DataTable>();
itemleavereq.tabledata.Add(FormDynamicDetailsView(sdleavereq.getAllleaveRequestList(callcont, username, compid).parmGeneralRequestList, "LeaveRequests"));
itemleavereq.Key = "LeaveRequests";
_commondetails.Add(itemleavereq);
//itempayslip.ListbyKey = FormDynamicDetailsView(sdspayslip.getPaySlipInfo(callcont, username, 2017, 10, compid), "Payslip");
//itempayslip.Key = "Payslip";
//itempayslip.Headers = itempayslip.ListbyKey.FirstOrDefault().Headers;
//_commondetails.Add(itempayslip);
//itempayslipdetail.tabledata = FormDynamicDetailsView(sdspayslip.getPaySlipLineInfoList(callcont, username, 2017, 10, compid).parmpaySlipLineInfoList, "PayslipDetails");
// itempayslipdetail.Key = "PayslipDetails";
// _commondetails.Add(itempayslipdetail);
if (Group != null && Group != "")
{
_commondetails = _commondetails.Where(x => x.GroupKey == Group).ToList();
}
if (Detail != null && Detail != "")
{
_commondetails = _commondetails.Where(x => x.Key == Detail).ToList();
}
// C:\Sabri\SoltechESSPortal\ESSPortal\ESSPortal\Views\.cshtml
return(View(_commondetails));
}
else
{
return(RedirectToAction("Login", "Account"));
// return _perinfo;
}
}
public ActionResult Home()
{
DTOModels.DTOPersonalInfo _perinfo = new DTOModels.DTOPersonalInfo();
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.SDSPersonalInfoServicesClient sd = new ESSWebService.SDSPersonalInfoServicesClient();
ESSWebService.SDSBankInfoServicesClient sdbank = new ESSWebService.SDSBankInfoServicesClient();
ESSWebService.SDSDashboardServicesClient dashclient = new ESSWebService.SDSDashboardServicesClient();
ESSWebService.SDSBenefitsInfoServiceClient sdbenfits = new ESSWebService.SDSBenefitsInfoServiceClient();
sdbenfits.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdbenfits.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var beninfocount = sdbenfits.getAllowanceDeductionCostList(callcont, username).parmbenefitsAllowDedList.Count();
ESSWebService.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdleavereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var ticketcount = sdleavereq.getAllleaveRequestByNatureList(callcont, username, (int)SDSLeaveReqNature.TicketRequest, compid).parmGeneralRequestList.Count();
var leavecount = sdleavereq.getAllleaveRequestByNatureList(callcont, username, (int)SDSLeaveReqNature.LeaveRequest, compid).parmGeneralRequestList.Count();
var tcktencahscount = sdleavereq.getAllleaveRequestByNatureList(callcont, username, (int)SDSLeaveReqNature.TicketEncashment, compid).parmGeneralRequestList.Count();
ESSWebService.SDSExcuseRequestServicesClient sdexcusereq = new ESSWebService.SDSExcuseRequestServicesClient();
sdexcusereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdexcusereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var absencecount = sdexcusereq.getAllExcuseReqeustByNature(callcont, username, ESSWebService.SDSExcuseNature.Absence, compid).parmExcuseRequestList.Count();
var overtimecount = sdexcusereq.getAllExcuseReqeustByNature(callcont, username, ESSWebService.SDSExcuseNature.Overtime, compid).parmExcuseRequestList.Count();
ESSWebService.SDSGeneralRequestServiceClient sdgenreq = new ESSWebService.SDSGeneralRequestServiceClient();
sdgenreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdgenreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var lettercount = sdgenreq.getAllGeneralRequestListByNature(callcont, username, ESSWebService.SDSGeneralNature.Letter, compid).parmGeneralRequestList.Count();
var generalcount = sdgenreq.getAllGeneralRequestListByNature(callcont, username, ESSWebService.SDSGeneralNature.General, compid).parmGeneralRequestList.Count();
dashclient.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
ESSPortal.ESSWebService.Dashboard retdash = dashclient.getDashboard(callcont, username, compid);
ESSWebService.SDSIdentificationInfoServicesClient sdidentify = new ESSWebService.SDSIdentificationInfoServicesClient();
sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sd.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
ESSPortal.ESSWebService.PersonalInfo perinfoser = sd.getOnePersonalInfo(callcont, username);
_perinfo.ArabicName = perinfoser.ArabicName;
_perinfo.EnglishName = perinfoser.EnglishName;
_perinfo.FirstName = perinfoser.EnglishName.Split(' ')[0];
_perinfo.NewID = perinfoser.OldId;
_perinfo.OldID = perinfoser.OldId;
_perinfo.JoiningDate = perinfoser.Joiningdate.ToShortDateString();
_perinfo.BirthDate = perinfoser.Birthdate.ToShortDateString();
_perinfo.JobDesc = perinfoser.JobId;
_perinfo.PositionDesc = perinfoser.Positiondescription;
_perinfo.PersonalNumber = perinfoser.Personnelnumber;
_perinfo.Companyname = perinfoser.Companyname;
_perinfo.Gender = perinfoser.Gender;
_perinfo.MaritalStatus = perinfoser.Maritalstatus;
_perinfo.dashboardlist = FormDynamicDashBoard(retdash);
_perinfo.Departmentname = perinfoser.DepartmentName;
_perinfo.ProbationEndDate = perinfoser.ProbationEndDate.ToShortDateString();
_perinfo.CountAddress = retdash.EmployeeDashboard.CountAddress;
_perinfo.PositionId = perinfoser.PositionId;
_perinfo.JobType = perinfoser.JobTypeId;
_perinfo.CountBank = retdash.EmployeeDashboard.CountBank;
_perinfo.CountContact = retdash.EmployeeDashboard.CountContact;
_perinfo.CountDependents = retdash.EmployeeDashboard.CountDependents;
_perinfo.CountExcuseRequest = retdash.EmployeeDashboard.CountExcuseRequest;
_perinfo.CountIdentification = retdash.EmployeeDashboard.CountIdentification;
_perinfo.CountLeaveRequest = retdash.EmployeeDashboard.CountLeaveRequest;
_perinfo.CountSkills = retdash.EmployeeDashboard.CountSkills;
_perinfo.DatePayslip = retdash.EmployeeDashboard.DatePayslip.ToShortDateString();
_perinfo.DatePayslipPrevious = retdash.EmployeeDashboard.DatePayslip.ToShortDateString();
_perinfo.LoanedItemCount = retdash.EmployeeDashboard.CountLoanedItems;
_perinfo.AttendanceCount = retdash.EmployeeDashboard.CountAttendance;
_perinfo.MyBusinessTripCount = retdash.EmployeeDashboard.CountBusinessTripRequest;
_perinfo.CountMedicalInsuarance = retdash.EmployeeDashboard.CountMedicalInsurance;
_perinfo.MyGeneralCount = retdash.EmployeeDashboard.CountGeneralRequest;
_perinfo.MyLoanCount = retdash.EmployeeDashboard.CountLoanRequest;
_perinfo.MyGeneralCount = retdash.EmployeeDashboard.CountGeneralRequest;
//_perinfo.CountLeaveRequest = retdash.EmployeeDashboard.CountLeaveRequest;
_perinfo.MyEOSCount = retdash.EmployeeDashboard.CountEOSRequest;
_perinfo.MyExcuseCount = retdash.EmployeeDashboard.CountExcuseRequest;
var medinsurance = sd.getMedicalInsuranceList(callcont, username, compid);
// _perinfo.CountMedicalInsuarance = medinsurance.parmMedicalInsuranceList.Count();
_perinfo.ImageArray = (sd.getPersonPhoto(callcont, Convert.ToInt64(username))).parmPersonPhoto;
_perinfo.Datepay = retdash.EmployeeDashboard.DatePayslip == new DateTime(1900, 1, 1, 12, 0, 0) ? "-" : retdash.EmployeeDashboard.DatePayslip.Day.ToString();
_perinfo.DayPaid = retdash.EmployeeDashboard.DatePayslip == new DateTime(1900, 1, 1, 12, 0, 0) ? "-" : retdash.EmployeeDashboard.DatePayslip.ToString("dddd");
_perinfo.YearMonth = retdash.EmployeeDashboard.DatePayslip == new DateTime(1900, 1, 1, 12, 0, 0) ? "-" : retdash.EmployeeDashboard.DatePayslip.ToString("MMMM") + " " + retdash.EmployeeDashboard.DatePayslip.Year.ToString();
_perinfo.DatepayPrev = retdash.EmployeeDashboard.DatePayslipPrevious == new DateTime(1900, 1, 1, 12, 0, 0) ? "-" : retdash.EmployeeDashboard.DatePayslipPrevious.Day.ToString();
_perinfo.DayPaidPrev = retdash.EmployeeDashboard.DatePayslipPrevious == new DateTime(1900, 1, 1, 12, 0, 0) ? "-" : retdash.EmployeeDashboard.DatePayslipPrevious.ToString("dddd");
_perinfo.YearMonthPrev = retdash.EmployeeDashboard.DatePayslipPrevious == new DateTime(1900, 1, 1, 12, 0, 0) ? "-" : retdash.EmployeeDashboard.DatePayslipPrevious.ToString("MMMM") + " " + retdash.EmployeeDashboard.DatePayslipPrevious.Year.ToString();
_perinfo.MyOverTimeCount = overtimecount;
_perinfo.CountBenifits = beninfocount;
_perinfo.MyGeneralCount = generalcount;
_perinfo.CountLeaveRequest = leavecount;
_perinfo.CountTicketRequest = ticketcount;
_perinfo.CountLetter = lettercount;
_perinfo.tcktencahscount = tcktencahscount;
_perinfo.absencecount = absencecount;
List <DTOPersonalContact> lstpersocontact = new List <DTOPersonalContact>();
DTOPersonalContact additem = new DTOPersonalContact();
additem.EmergencyContact = perinfoser.Perosnalcontactemergency;
additem.Name = perinfoser.Perosnalcontactname;
additem.RelationShip = perinfoser.Perosnalcontactrelationship;
lstpersocontact.Add(additem);
//if ((sd.getPersonPhoto(callcont, Convert.ToInt64(username))).parmPersonPhoto != null)
//{
// //Save the Byte Array as File.
// string filePath = "~/Prflpics/" + Path.GetFileName(username.ToString()) + ".jpg";
// string x = (sd.getPersonPhoto(callcont, Convert.ToInt64(username))).parmPersonPhoto;
// byte[] imageBytes = Convert.FromBase64String(x);
// MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length);
// // Convert byte[] to Image
// ms.Write(imageBytes, 0, imageBytes.Length);
// System.Drawing.Image image = System.Drawing.Image.FromStream(ms, true);
// Bitmap bmp = new Bitmap(image);
// // bm.Save(filePath, ImageFormat.Bmp);
// try
// {
// // bmp.Save(filePath);
// }
// catch
// {
// Bitmap bitmap = new Bitmap(bmp.Width, bmp.Height, bmp.PixelFormat);
// Graphics g = Graphics.FromImage(bitmap);
// g.DrawImage(bmp, new Point(0, 0));
// g.Dispose();
// bmp.Dispose();
// bmp = null;
// // bitmap.Save(filePath);
// // bmp = bitmap; // preserve clone
// }
// // image.Save(filePath, System.Drawing.Imaging.ImageFormat.Jpeg);
// // System.IO.File.WriteAllBytes(Server.MapPath(filePath), Encoding.UTF8.GetBytes((sd.getPersonPhoto(callcont, Convert.ToInt64(username))).parmPersonPhoto));
//}
// _perinfo.ImageArray = Encoding.ASCII.GetBytes((sd.getPersonPhoto(callcont, Convert.ToInt64(username))).parmPersonPhoto);
// sd.get
return(View(_perinfo));
}
else
{
return(RedirectToAction("Login"));
}
}