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);
}