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); }
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); }
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; }
public JsonResult UpdateAddress(EMPdetails emp) { return Json(new { viewContent = "" }, JsonRequestBehavior.AllowGet); }