Ejemplo n.º 1
0
        public ActionResult Details()
        {
            string userkey     = ConfigurationManager.AppSettings["userkey"];
            string uid         = ConfigurationManager.AppSettings["uid"];
            string LoginUser   = (string)Session["LoginSAPID"];
            string _access_key = ConfigurationManager.AppSettings["Salt"];
            string Pin         = this.Request.QueryString[0];

            try
            {
                Util.Util       utility = new Util.Util();
                Crypto.Service1 _crypt  = new Crypto.Service1();
                string          dPin    = _crypt.Decryptfx(Pin, _access_key);

                DataTable dt = utility.Fetchdata(dPin, "", userkey, uid);
                dt.TableName = "CompanyEmployees";

                var EmployeeDetails = (from DataRow dr in dt.Rows
                                       select new CompanyEmployee()
                {
                    Title = dr["Title"].ToString(),
                    FirstName = dr["First Name"].ToString(),
                    LastName = dr["Last Name"].ToString(),
                    MiddleName = dr["Middle Names"].ToString(),
                    PhoneNo = dr["Mobile 1"].ToString(),
                    DateOfBirth = dr["Date Of Birth"].ToString(),
                    DateOfEmployment = dr["Date Of Employment"].ToString(),
                    Email = dr["E-mail"].ToString(),
                    StateOfOrigin = dr["State of Origin"].ToString(),
                    LGA = dr["Local Government Authority"].ToString(),
                    Address = dr["Address"].ToString(),
                    Address2 = dr["Address 2"].ToString(),
                    City = dr["City"].ToString(),
                    Religion = dr["Religion"].ToString(),
                    Nationality = dr["Nationality"].ToString(),
                    Qualification = dr["Qualification"].ToString(),
                    State = dr["State of Posting"].ToString(),
                }).ToList();

                ViewBag.Details = EmployeeDetails;
                return(View());
            }
            catch (Exception ex)
            {
                LogError logerror = new LogError();
                logerror.ErrorLog("", LoginUser, "", "Employee/Details", "Employee", "Details", "Fetchdata Error", ex.Message.ToString(), 0);
                return(RedirectToAction("Index"));
            }
        }