Ejemplo n.º 1
0
        public ActionResult Index(string SSN = "")
        {
            ClaimDetailDashBoardModel claimDetailDashBoardModel = new ClaimDetailDashBoardModel();

            try
            {
                try
                {
                    if ((bool)TempData.Peek("GlobalSearch"))
                    {
                        GetLayoutSessionClass.GetLayoutModel(Common.StaticClass.GetClientFromSSN(SSN));
                    }
                }
                catch (Exception)
                {
                    throw;
                }
               
                

                List<DEDMET_OOP_Model> dEDMET_OOP_CurrentYear_Models = GetDEDMETOOP(SSN,DateTime.Now.Year);
                claimDetailDashBoardModel.dEDMETModelCurentYear = dEDMET_OOP_CurrentYear_Models;

                List<DEDMET_OOP_Model> dEDMET_OOP_Previous_Models = GetDEDMETOOP(SSN,DateTime.Now.Year-1);
                claimDetailDashBoardModel.dEDMETModelPreviousYear = dEDMET_OOP_Previous_Models;

                List<DependentDetailModel> dependentDetailModels = GetDependentListModel(SSN);
                claimDetailDashBoardModel.dependentDetailModels = dependentDetailModels;

                List<ClaimDetailModel> claimDetailModels = new List<ClaimDetailModel>();
                GetClaimDetailsModel(SSN, "0", "", null, null,"", "ClaimDate", "DESC",1,10, claimDetailModels);
                claimDetailDashBoardModel.claimDetailModels = claimDetailModels;

                EMPdetails eMPdetails = GetEMployDetailsModelWIthSSN(SSN);
                claimDetailDashBoardModel.eMPdetails = eMPdetails;

                ViewBag.TotalCount_claimDetails = GetTotalCount_ClaimDetailTable(SSN,"0", "", null, null,"");


            }
            catch (Exception ex)
            {
                throw;
            }
            return View(claimDetailDashBoardModel);
        }
Ejemplo n.º 2
0
        public  JsonResult GetAddreessParialViewHtml(string SSN)
        {
            EMPdetails eMPdetails = new EMPdetails();
            string viewContent = "";
            try
            {
                 eMPdetails = GetEMployDetailsModelWIthSSN(SSN);
                 viewContent = ConvertViewToString("_Address_Add_Edit_PartialView",eMPdetails);
            }
            catch (Exception ex)
            {

                throw;
            }
         
            return Json(new { viewContent = viewContent }, JsonRequestBehavior.AllowGet);
        }
Ejemplo n.º 3
0
        private static EMPdetails GetEMployDetailsModelWIthSSN(string SSN)
        {

           
            DataTable Employdetails = new DataTable();
            Employdetails = Db2Connnect.GetDataTable(GetSqlQuery.GetMemberDetailsWIthSSN(SSN), CommandType.Text);
            EMPdetails eMPdetails = new EMPdetails();
            foreach (DataRow item in Employdetails.Rows)
            {
                eMPdetails.Id = item["Id"].ToString();
                eMPdetails.Name = item["Name"].ToString().Replace("*", ",");
                eMPdetails.Gender = item["Gender"].ToString();
                eMPdetails.DOBDay = item["DOBD"].ToString();
                eMPdetails.DOBMonth = item["DOBM"].ToString();
                eMPdetails.DOBYear = item["DOBY"].ToString();
                eMPdetails.EMSSN = item["EMSSN"].ToString();
                eMPdetails.Addr1= item["Addr1"].ToString().TrimEnd().TrimStart();
                eMPdetails.Addr2 = item["Addr2"].ToString().TrimEnd().TrimStart();
                eMPdetails.Addr3 = item["Addr3"].ToString().TrimEnd().TrimStart();
                eMPdetails.Addr4 = item["Addr4"].ToString().TrimEnd().TrimStart();
                eMPdetails.City = item["City"].ToString().TrimEnd().TrimStart();
                eMPdetails.State = item["State"].ToString().TrimEnd().TrimStart();
                eMPdetails.Zip1 = item["Zip1"].ToString().TrimEnd().TrimStart();
                eMPdetails.Zip2 = item["Zip2"].ToString().TrimEnd().TrimStart();
                eMPdetails.Zip3 = item["Zip3"].ToString().TrimEnd().TrimStart();

            }
            DBManager db = new DBManager("CustomerServicePortal");
            string Commadtext = @"SELECT   CASE 
                                   WHEN COUNT(CASE WHEN complete = 0 then 1 ELSE NULL END)> 0
                                    THEN 0 ELSE  1 end from [IDCardRequestDetails] where EMSSN = @SSN";
            var parameters = new List<IDbDataParameter>();
            parameters.Add(db.CreateParameter("@SSN", SSN, DbType.String));
            eMPdetails.ShowRequestId = ((int)db.GetScalarValue(Commadtext, CommandType.Text, parameters.ToArray())==1)? true:false;
            return eMPdetails;
        }
Ejemplo n.º 4
0
 public JsonResult UpdateAddress(EMPdetails emp)
 {
     return Json(new { viewContent = "" }, JsonRequestBehavior.AllowGet);
 }