private static DependentDetailModel GetDependentWithSEQtModel(string SSN,int DEPSEQ)
{
DataTable dependenttable = new DataTable();
dependenttable = Db2Connnect.GetDataTable(GetSqlQuery.GetDependentDetailsWithSeq(SSN,DEPSEQ), CommandType.Text);
DependentDetailModel dependentDetailModel = new DependentDetailModel();
foreach (DataRow item in dependenttable.Rows)
{
dependentDetailModel.SSN =item["DPSSN"].ToString();
dependentDetailModel.DependentSeq = item["SEQ"].ToString();
dependentDetailModel.DependenetName = item["NAME"].ToString().Replace("*", ",");
//(item["NAME"].ToString().Split('*')[1] + "*" + item["NAME"].ToString().Split('*')[0]).Replace("*", ",").Replace(" ", "()").Replace(")(", "").Replace("()", " ");
dependentDetailModel.Relation = item["RELATION"].ToString();
dependentDetailModel.Status = item["STATUS"].ToString();
dependentDetailModel.BirthYear = item["DOBY"].ToString();
dependentDetailModel.BirthMonth = item["DOBM"].ToString();
dependentDetailModel.BirthDay = item["DOBD"].ToString();
dependentDetailModel.Class = item["CLASS"].ToString();
dependentDetailModel.Plan = item["PLAN"].ToString();
dependentDetailModel.BoolStatus = item["STATUS"].ToString() == "A" ? true : false;
dependentDetailModel.EffectiveYear = item["EFDY"].ToString();
dependentDetailModel.EffectiveMonth = item["EFDM"].ToString();
dependentDetailModel.EffectiveDay = item["EFDD"].ToString();
dependentDetailModel.ADDRESS1 = item["ADDRESS1"].ToString();
dependentDetailModel.ADDRESS2 = item["ADDRESS2"].ToString();
dependentDetailModel.ADDRESS3 = item["ADDRESS3"].ToString();
dependentDetailModel.STATE = item["STATE"].ToString();
dependentDetailModel.CITY = item["CITY"].ToString();
dependentDetailModel.ZIP4 = item["ZIP4"].ToString();
dependentDetailModel.ZIP5 = item["ZIP5"].ToString();
if (item["TDTY"].ToString()!="0" && item["TDTM"].ToString() != "0" && item["TDTD"].ToString() != "0")
{
dependentDetailModel.TerminationDate = new DateTime(Convert.ToInt32(item["TDTY"].ToString()), Convert.ToInt32(item["TDTM"].ToString()), Convert.ToInt32(item["TDTD"].ToString()));
}
if (item["EFDY"].ToString() != "0" && item["EFDM"].ToString() != "0" && item["EFDD"].ToString() != "0")
{
dependentDetailModel.EffectiveDate = new DateTime(Convert.ToInt32(item["EFDY"].ToString()), Convert.ToInt32(item["EFDM"].ToString()), Convert.ToInt32(item["EFDD"].ToString()));
}
}
return dependentDetailModel;
}
public ActionResult EditDependentHtml(string SSN,int DependentSeq)
{
DependentDetailModel dependentDetailModel = new DependentDetailModel();
string viewContent = "";
try
{
if (DependentSeq !=0)
{
dependentDetailModel = GetDependentWithSEQtModel(SSN,DependentSeq);
}
viewContent = ConvertViewToString("_Dependent_Add_Edit_PartialView", dependentDetailModel);
}
catch (Exception ex)
{
throw;
}
return Json(new { viewContent = viewContent }, JsonRequestBehavior.AllowGet);
}
private static List<DependentDetailModel> GetDependentListModel(string SSN)
{
DataTable dependenttable = new DataTable();
dependenttable = Db2Connnect.GetDataTable(GetSqlQuery.GetDependentDetails(SSN), CommandType.Text);
List<DependentDetailModel> dependentDetailModels = new List<DependentDetailModel>();
foreach (DataRow item in dependenttable.Rows)
{
DependentDetailModel dependentDetailModel = new DependentDetailModel();
dependentDetailModel.SSN = item["DPSSN"].ToString();
dependentDetailModel.DependentSeq = item["SEQ"].ToString();
dependentDetailModel.DependenetName = item["Name"].ToString().Replace("*", ",");
dependentDetailModel.Relation = item["RELATION"].ToString();
dependentDetailModel.Status = item["STATUS"].ToString();
dependentDetailModel.BirthYear = item["DOBY"].ToString();
dependentDetailModel.BirthMonth = item["DOBM"].ToString();
dependentDetailModel.BirthDay = item["DOBD"].ToString();
dependentDetailModel.Class = item["CLASS"].ToString();
dependentDetailModel.Plan = item["PLAN"].ToString();
dependentDetailModels.Add(dependentDetailModel);
}
return dependentDetailModels;
}
