public JsonResult GetLeaveRequestsByEmployeeLogIn()
 {
     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.SDSLeaveRequestServicesClient sd = new ESSWebService.SDSLeaveRequestServicesClient();
         sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
         sd.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
         var ss = (from a in sd.getAllleaveRequestList(callcont, username, compid).parmGeneralRequestList
                   select new DTOLeaveRequest
         {
             LeaveRequest = a.Leaverequestid,
             LeaveType = a.Leavetypeid,
             RequestDate = a.Transactiondate.ToShortDateString(),
             FromDate = a.Fromdate.ToShortDateString(),
             ToDate = a.ToDate.ToShortDateString(),
             PersonalNumber = a.WorkerRecid.ToString(),
             Worker = a.NameEn,
             State = a.Workflowstatus.ToString(),
             URL = "/LeaveRequest/ViewRequestbyRequestId?LeaveRequestNumber=" + a.Leaverequestid,
             //Attachment = a.
         }).ToList();
         return(Json(ss, JsonRequestBehavior.AllowGet));
     }
     else
     {
         RedirectToAction("Login", "Account");
         // return _perinfo;
         return(Json(""));
     }
 }
Example #2
0
        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.SDSLeaveRequestServicesClient sdsworkcom = new ESSWebService.SDSLeaveRequestServicesClient();
            sdsworkcom.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
            sdsworkcom.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
            ESSWebService.SDSWorkflowApprovalWorkItemHistory workflowHistory = sdsworkcom.getWorkflowHistory(callcont, requesid, compid);
            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 getleavetypes()
        {
            ESSWebService.CallContext callcont = new ESSWebService.CallContext();
            var compid   = Request.Cookies["compid"].Value;
            var username = Convert.ToInt64(Request.Cookies["user"].Value);

            ESSWebService.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
            sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
            sdleavereq.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
            var leavetypes = sdleavereq.getLeaveTypeId_2(callcont, username, compid).parmleaveTypeIdList;

            return(Json(leavetypes, JsonRequestBehavior.AllowGet));
        }
        public ActionResult LeaveRequestAng(int pageNumber, int pageSize)
        {
            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.SDSLeaveRequestServicesClient sd = new ESSWebService.SDSLeaveRequestServicesClient();
                sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
                sd.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
                //sd.getPendingWorkflowList()
                // sd.Approve()
                //  sd.getAllleaveRequestList(callcont, username, compid).
                List <DTOLeaveRequest> leavereqList = null; int recordsTotal = 0;
                var ss = (from a in sd.getAllleaveRequestList(callcont, username, compid).parmGeneralRequestList.Where(x => x.Leaverequestnature == ESSWebService.SDSLeaveReqNature.LeaveRequest).ToList()
                          select new DTOLeaveRequest
                {
                    LeaveRequest = a.Leaverequestid,
                    LeaveType = a.Leavetypeid,
                    RequestDate = a.Transactiondate.ToShortDateString(),
                    FromDate = a.Fromdate.ToShortDateString(),
                    ToDate = a.ToDate.ToShortDateString(),
                    PersonalNumber = a.NameEn.Split('-')[0],
                    Worker = a.NameEn.Split('-')[1],
                    State = a.Workflowstatus.ToString(),
                    LeaveReqNature = ((int)a.Leaverequestnature).ToString(),
                    URL = "/LeaveRequest/ViewRequestbyRequestId?LeaveRequestNumber=" + a.Leaverequestid,
                    //Attachment = a.
                }).ToList();


                recordsTotal = ss.Count();
                //leavereqList = ss
                //                     .Skip(pageNumber)
                //                     .Take(pageSize)
                //                     .ToList();

                leavereqList = ss
                               .ToList();
                return(Json(new
                {
                    recordsTotal,
                    leavereqList
                }, JsonRequestBehavior.AllowGet));
            }
            else
            {
                return(RedirectToAction("Home", "Account"));
                // return _perinfo;
            }
        }
        public JsonResult getticketbalance(string leavetype, string nooftickets)
        {
            ESSWebService.CallContext callcont = new ESSWebService.CallContext();
            var compid   = Request.Cookies["compid"].Value;
            var username = Convert.ToInt64(Request.Cookies["user"].Value);

            ESSWebService.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
            sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
            sdleavereq.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
            var intnumtckt = nooftickets != "" ? Convert.ToInt32(nooftickets) : 0;
            var tckbalance = sdleavereq.getTicketBalance(callcont, username, intnumtckt, DateTime.Now, leavetype, compid);

            return(Json(tckbalance, JsonRequestBehavior.AllowGet));
        }
 public string SubmitLeaveReturn(string leaverequestid, string date, string comments)
 {
     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.SDSLeaveRequestServicesClient sd = new ESSWebService.SDSLeaveRequestServicesClient();
         sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
         sd.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
         return(sd.ReturnLeaveRequest(callcont, leaverequestid, new DateTime(Convert.ToInt32(date.Split('/')[2]), Convert.ToInt32(date.Split('/')[1]), Convert.ToInt32(date.Split('/')[0])), compid));
     }
     else
     {
         RedirectToAction("Login", "Account");
         return("");
     }
 }
        public ActionResult SubmittedRequestsbyType(string reqnature)
        {
            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.SDSLeaveRequestServicesClient sd = new ESSWebService.SDSLeaveRequestServicesClient();
                sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
                sd.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
                //sd.getPendingWorkflowList()
                // sd.Approve()
                //  sd.getAllleaveRequestList(callcont, username, compid).

                var ss = (from a in sd.getPendingWorkflowList(callcont, username).parmGeneralRequestList
                          select new DTOLeaveRequest
                {
                    LeaveRequest = a.Leaverequestid,
                    LeaveType = a.Leavetypeid,
                    RequestDate = a.Transactiondate.ToShortDateString(),
                    FromDate = a.Fromdate.ToShortDateString(),
                    ToDate = a.ToDate.ToShortDateString(),
                    PersonalNumber = a.NameEn.Split('-')[0],
                    Worker = a.NameEn.Split('-')[1],
                    State = a.Workflowstatus.ToString(),
                    LeaveReqNature = ((int)a.Leaverequestnature).ToString(),
                    WorkflowRecId = a.WorkflowItem,
                    URL = "/LeaveRequest/ViewRequestbyRequestId?LeaveRequestNumber=" + a.Leaverequestid,
                    //Attachment = a.
                }).ToList();
                if (reqnature != null && reqnature != "")
                {
                    ss = ss.Where(x => x.LeaveReqNature == reqnature).OrderByDescending(x => x.LeaveRequest).ToList();
                }

                return(View(ss));
            }
            else
            {
                return(RedirectToAction("Login", "Account"));
                // return _perinfo;
            }
        }
 public ActionResult ViewallLeaveTravelled(string LeaveRequestNumber)
 {
     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.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
         sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
         sdleavereq.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
         ESSWebService.LeaveRequest _leavereq = new ESSWebService.LeaveRequest();
         _leavereq        = sdleavereq.getleaveRequest(callcont, LeaveRequestNumber, compid);
         _leavereq.NameAr = Workflowforrequest(LeaveRequestNumber);
         return(View(_leavereq));
     }
     else
     {
         return(RedirectToAction("Login", "Account"));
     }
 }
 public JsonResult getleavebalance(string leavetype, string fromdate, string todate)
 {
     try
     {
         ESSWebService.CallContext callcont = new ESSWebService.CallContext();
         var compid   = Request.Cookies["compid"].Value;
         var username = Convert.ToInt64(Request.Cookies["user"].Value);
         ESSWebService.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
         sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
         sdleavereq.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
         DateTime frmdatedt = fromdate != "" ? Convert.ToDateTime(fromdate) : DateTime.Now;
         DateTime todatedt  = todate != "" ? Convert.ToDateTime(todate) : DateTime.Now;
         var      balance   = sdleavereq.getLeaveBalance(callcont, username, leavetype, frmdatedt, todatedt, compid);
         return(Json(balance, JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         var ms = ex.Message;
         throw;
     }
 }
 public string RejectLeaveLequestbyRequestNumber(string leaverequest, 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.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
         sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
         sdleavereq.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
         ESSWebService.LeaveRequest _crleavereq = new ESSWebService.LeaveRequest();
         _crleavereq          = sdleavereq.getPendingWorkflowList(callcont, username).parmGeneralRequestList.Where(x => x.Leaverequestid == leaverequest).FirstOrDefault();
         _crleavereq.Approved = ESSWebService.NoYes.No;
         //sdleavereq.Approve(callcont, _crleavereq.WorkflowItem, username, Comment);
         return(sdleavereq.Reject(callcont, _crleavereq.WorkflowItem, username, Comment));
     }
     else
     {
         RedirectToAction("Login", "Account");
         return("");
         // return _perinfo;
     }
 }
Example #11
0
        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 string CreateNewRequestbyNature(string fromdate, string todate, string leavetype, string contactinfo, string reason, string altwork
                                               , string destnat, string nooftickets, string reqvisa, string reqexitentry, string salinadvance, string comments, string reqnature)
        {
            if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
            {
                try
                {
                    string lreqid = "";
                    ESSWebService.CallContext callcont = new ESSWebService.CallContext();
                    var compid   = Request.Cookies["compid"].Value;
                    var username = Convert.ToInt64(Request.Cookies["user"].Value);
                    ESSWebService.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
                    sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
                    sdleavereq.ClientCredentials.Windows.ClientCredential        = new NetworkCredential("webapp", "pass" + '"' + "word123");
                    ESSWebService.LeaveRequest _crleavereq = new ESSWebService.LeaveRequest();
                    HttpFileCollectionBase     files       = Request.Files;
                    for (int i = 0; i < files.Count; i++)
                    {
                        //string path = AppDomain.CurrentDomain.BaseDirectory + "Uploads/";
                        //string filename = Path.GetFileName(Request.Files[i].FileName);

                        HttpPostedFileBase file = files[i];
                        string             fname;

                        // Checking for Internet Explorer
                        if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
                        {
                            string[] testfiles = file.FileName.Split(new char[] { '\\' });
                            fname = testfiles[testfiles.Length - 1];
                        }
                        else
                        {
                            fname = file.FileName;
                        }

                        // Get the complete folder path and store the file inside it.
                        fname = Path.Combine(Server.MapPath("~/Uploads/"), fname);
                        file.SaveAs(fname);


                        byte[] thePictureAsBytes = new byte[file.ContentLength];
                        using (BinaryReader theReader = new BinaryReader(file.InputStream))

                        {
                            thePictureAsBytes = theReader.ReadBytes(file.ContentLength);
                            //_crleavereq.AttachmentImage = System.Text.Encoding.Default.GetString(thePictureAsBytes);
                        }
                    }
                    _crleavereq.Comments    = comments == "" ? null : comments;
                    _crleavereq.ContactInfo = contactinfo == "" ? null : contactinfo;

                    _crleavereq.Destination = destnat == "" ? null : destnat;
                    var ss = fromdate.Split('/');
                    _crleavereq.Fromdate = new DateTime(Convert.ToInt32(fromdate.Split('/')[2]), Convert.ToInt32(fromdate.Split('/')[1]), Convert.ToInt32(fromdate.Split('/')[0]));
                    _crleavereq.ToDate   = new DateTime(Convert.ToInt32(todate.Split('/')[2]), Convert.ToInt32(todate.Split('/')[1]), Convert.ToInt32(todate.Split('/')[0]));
                    if (_crleavereq.ToDate >= _crleavereq.Fromdate)
                    {
                        _crleavereq.Transactiondate    = DateTime.Now;
                        _crleavereq.Leaverequestnature = ESSPortal.ESSWebService.SDSLeaveReqNature.LeaveRequest;
                        _crleavereq.Leavetypeid        = leavetype == "-1" ? null : leavetype;
                        _crleavereq.WorkerRecid        = username;
                        _crleavereq.Reasoncode         = reason == "-1" ? null : reason;
                        //_crleavereq.

                        _crleavereq.Alternativeworker = altwork == "-1" ? 0 : Convert.ToInt64(altwork);
                        _crleavereq.Nooftickets       = nooftickets == "" ? 0 : Convert.ToInt32(nooftickets);
                        _crleavereq.Requestexitentry  = reqexitentry == "1" ? ESSPortal.ESSWebService.NoYes.Yes : ESSPortal.ESSWebService.NoYes.No;
                        _crleavereq.Requestvisa       = reqvisa == "1" ? ESSPortal.ESSWebService.NoYes.Yes : ESSPortal.ESSWebService.NoYes.No;
                        _crleavereq.Salaryinadvance   = salinadvance == "1" ? ESSPortal.ESSWebService.NoYes.Yes : ESSPortal.ESSWebService.NoYes.No;
                        lreqid = sdleavereq.createLeaveRequestByNature(callcont, _crleavereq, Convert.ToInt32(reqnature), compid);
                    }
                    else
                    {
                        throw new Exception("Fromdate should greated than Todate");
                    }

                    //string lreqid = "";

                    return(lreqid);
                }
                catch (Exception ex)
                {
                    return(ex.Message);
                }
            }
            else
            {
                RedirectToAction("Login", "Account");
                return("");
            }
        }
Example #13
0
        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"));
            }
        }