// GET: AddTestatorFamily
public ActionResult AddTestatorFamilyIndex()
{
ViewBag.view = "Will";
ViewBag.collapse = "true";
// check type
string typ = "";
con.Open();
string qq1 = "select Type from users where uId = " + Convert.ToInt32(Session["uuid"]) + " ";
SqlDataAdapter daa = new SqlDataAdapter(qq1, con);
DataTable dtt = new DataTable();
daa.Fill(dtt);
con.Close();
if (dtt.Rows.Count > 0)
{
typ = dtt.Rows[0]["Type"].ToString();
}
//end
if (typ == "Testator")
{
con.Open();
string qq12 = "select Type from users where uId = " + Convert.ToInt32(Session["uuid"]) + " and designation = 1 ";
SqlDataAdapter da42 = new SqlDataAdapter(qq12, con);
DataTable d4t2 = new DataTable();
da42.Fill(d4t2);
con.Close();
if (d4t2.Rows.Count > 0)
{
ViewBag.documentlink = "true";
}
// check will status
con.Open();
string qry1 = "select Will from users where Will = 1 ";
SqlDataAdapter daa1 = new SqlDataAdapter(qry1, con);
DataTable dtt1 = new DataTable();
daa1.Fill(dtt1);
if (dtt1.Rows.Count > 0)
{
ViewBag.documentbtn1 = "true";
}
con.Close();
//end
// check codocil status
con.Open();
string qry2 = "select Codocil from users where Codocil = 1 ";
SqlDataAdapter daa2 = new SqlDataAdapter(qry2, con);
DataTable dtt2 = new DataTable();
daa2.Fill(dtt2);
if (dtt2.Rows.Count > 0)
{
ViewBag.documentbtn2 = "true";
}
con.Close();
//end
// check Poa status
con.Open();
string qry4 = "select POA from users where POA = 1 ";
SqlDataAdapter daa4 = new SqlDataAdapter(qry4, con);
DataTable dtt4 = new DataTable();
daa4.Fill(dtt4);
if (dtt4.Rows.Count > 0)
{
ViewBag.documentbtn3 = "true";
}
con.Close();
//end
// check gift deeds status
con.Open();
string qry3 = "select Giftdeeds from users where Giftdeeds = 1 ";
SqlDataAdapter daa3 = new SqlDataAdapter(qry3, con);
DataTable dtt3 = new DataTable();
daa3.Fill(dtt3);
if (dtt3.Rows.Count > 0)
{
ViewBag.documentbtn4 = "true";
}
con.Close();
//end
}
else
{
ViewBag.showtitle = "true";
ViewBag.documentlink = "true";
}
if (Session["rId"] == null || Session["uuid"] == null)
{
RedirectToAction("LoginPageIndex", "LoginPage");
}
//if (Session["tid"]== null)
//{
// ViewBag.message = "link";
//}
List <LoginModel> Lmlist = new List <LoginModel>();
con.Open();
string q = "select * from Assignment_Roles where RoleId = " + Convert.ToInt32(Session["rId"]) + "";
SqlDataAdapter da3 = new SqlDataAdapter(q, con);
DataTable dt3 = new DataTable();
da3.Fill(dt3);
if (dt3.Rows.Count > 0)
{
for (int i = 0; i < dt3.Rows.Count; i++)
{
LoginModel lm = new LoginModel();
lm.PageName = dt3.Rows[i]["PageName"].ToString();
lm.PageStatus = dt3.Rows[i]["PageStatus"].ToString();
lm.Action = dt3.Rows[i]["Action"].ToString();
lm.Nav1 = dt3.Rows[i]["Nav1"].ToString();
lm.Nav2 = dt3.Rows[i]["Nav2"].ToString();
Lmlist.Add(lm);
}
ViewBag.PageName = Lmlist;
}
con.Close();
TestatorFamilyModel TFM = new TestatorFamilyModel();
con.Open();
string query = "select * from testatorFamily where tId = " + Convert.ToInt32(Session["distid"]) + "";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
string data = "";
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TFM.First_Name = dt.Rows[i]["First_Name"].ToString();
TFM.Last_Name = dt.Rows[i]["Last_Name"].ToString();
TFM.Middle_Name = dt.Rows[i]["Middle_Name"].ToString();
TFM.Dob = Convert.ToDateTime(dt.Rows[0]["DOB"]).ToString("dd-MM-yyyy");
TFM.Marital_Status = dt.Rows[i]["Marital_Status"].ToString();
TFM.Religion = dt.Rows[i]["Religion"].ToString();
TFM.RelationshipTxt = dt.Rows[i]["Relationship"].ToString();
TFM.Address1 = dt.Rows[i]["Address1"].ToString();
TFM.Address2 = dt.Rows[i]["Address2"].ToString();
TFM.Address3 = dt.Rows[i]["Address3"].ToString();
TFM.City_txt = dt.Rows[i]["City"].ToString();
TFM.State_txt = dt.Rows[i]["State"].ToString();
TFM.Pin = dt.Rows[i]["Pin"].ToString();
TFM.active = dt.Rows[i]["active"].ToString();
TFM.Identity_Proof = dt.Rows[i]["Identity_Proof"].ToString();
TFM.Identity_Proof_Value = dt.Rows[i]["Identity_Proof_Value"].ToString();
TFM.Alt_Identity_Proof = dt.Rows[i]["Alt_Identity_Proof"].ToString();
TFM.Alt_Identity_Proof_Value = dt.Rows[i]["Alt_Identity_Proof_Value"].ToString();
TFM.Is_Informed_Person = dt.Rows[i]["Is_Informed_Person"].ToString();
}
}
return(View("~/Views/AddTestatorFamily/AddTestatorFamilyPageContent.cshtml", TFM));
}
public ActionResult InsertTestatorFamilyFormData(TestatorFamilyModel TFM)
{
ViewBag.collapse = "true";
// check type
string typ = "";
con.Open();
string qq1 = "select Type from users where uId = " + Convert.ToInt32(Session["uuid"]) + " ";
SqlDataAdapter daa = new SqlDataAdapter(qq1, con);
DataTable dtt = new DataTable();
daa.Fill(dtt);
con.Close();
if (dtt.Rows.Count > 0)
{
typ = dtt.Rows[0]["Type"].ToString();
}
//end
if (typ == "Testator")
{
// check will status
con.Open();
string qry1 = "select Will from users where Will = 1 ";
SqlDataAdapter daa1 = new SqlDataAdapter(qry1, con);
DataTable dtt1 = new DataTable();
daa1.Fill(dtt1);
if (dtt1.Rows.Count > 0)
{
ViewBag.documentbtn1 = "true";
}
con.Close();
//end
// check codocil status
con.Open();
string qry2 = "select Codocil from users where Codocil = 1 ";
SqlDataAdapter daa2 = new SqlDataAdapter(qry2, con);
DataTable dtt2 = new DataTable();
daa2.Fill(dtt2);
if (dtt2.Rows.Count > 0)
{
ViewBag.documentbtn2 = "true";
}
con.Close();
//end
// check Poa status
con.Open();
string qry4 = "select POA from users where POA = 1 ";
SqlDataAdapter daa4 = new SqlDataAdapter(qry4, con);
DataTable dtt4 = new DataTable();
daa4.Fill(dtt4);
if (dtt4.Rows.Count > 0)
{
ViewBag.documentbtn3 = "true";
}
con.Close();
//end
// check gift deeds status
con.Open();
string qry3 = "select Giftdeeds from users where Giftdeeds = 1 ";
SqlDataAdapter daa3 = new SqlDataAdapter(qry3, con);
DataTable dtt3 = new DataTable();
daa3.Fill(dtt3);
if (dtt3.Rows.Count > 0)
{
ViewBag.documentbtn4 = "true";
}
con.Close();
//end
}
else
{
ViewBag.showtitle = "true";
ViewBag.documentlink = "true";
}
// roleassignment
List <LoginModel> Lmlist = new List <LoginModel>();
con.Open();
string q = "select * from Assignment_Roles where RoleId = " + Convert.ToInt32(Session["rId"]) + "";
SqlDataAdapter da3 = new SqlDataAdapter(q, con);
DataTable dt3 = new DataTable();
da3.Fill(dt3);
if (dt3.Rows.Count > 0)
{
for (int i = 0; i < dt3.Rows.Count; i++)
{
LoginModel lm = new LoginModel();
lm.PageName = dt3.Rows[i]["PageName"].ToString();
lm.PageStatus = dt3.Rows[i]["PageStatus"].ToString();
lm.Action = dt3.Rows[i]["Action"].ToString();
lm.Nav1 = dt3.Rows[i]["Nav1"].ToString();
lm.Nav2 = dt3.Rows[i]["Nav2"].ToString();
Lmlist.Add(lm);
}
ViewBag.PageName = Lmlist;
}
con.Close();
//end
//if (Session["tid"] != null)
//{
con.Open();
SqlCommand cmd = new SqlCommand("SP_CRUDtestatorfamily", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@condition", "insert");
cmd.Parameters.AddWithValue("@First_Name", TFM.First_Name);
cmd.Parameters.AddWithValue("@Last_Name", TFM.Last_Name);
cmd.Parameters.AddWithValue("@Middle_Name", TFM.Middle_Name);
DateTime dat = DateTime.ParseExact(TFM.Dob, "dd-MM-yyyy", CultureInfo.InvariantCulture);
cmd.Parameters.AddWithValue("@DOB", dat);
cmd.Parameters.AddWithValue("@Marital_Status", "none");
cmd.Parameters.AddWithValue("@Religion", "none");
cmd.Parameters.AddWithValue("@Relationship", TFM.RelationshipTxt);
cmd.Parameters.AddWithValue("@Address1", TFM.Address1);
cmd.Parameters.AddWithValue("@Address2", TFM.Address2);
cmd.Parameters.AddWithValue("@Address3", TFM.Address3);
cmd.Parameters.AddWithValue("@City", TFM.City_txt);
cmd.Parameters.AddWithValue("@State", TFM.State_txt);
cmd.Parameters.AddWithValue("@Pin", TFM.Pin);
cmd.Parameters.AddWithValue("@tId", TFM.ddltid);
if (TFM.active != null && TFM.active != "")
{
cmd.Parameters.AddWithValue("@active", TFM.active);
}
else
{
TFM.active = "Active";
cmd.Parameters.AddWithValue("@active", TFM.active);
}
cmd.Parameters.AddWithValue("@Identity_Proof", TFM.Identity_Proof);
cmd.Parameters.AddWithValue("@Identity_Proof_Value", TFM.Identity_Proof_Value);
cmd.Parameters.AddWithValue("@Alt_Identity_Proof", TFM.Alt_Identity_Proof);
cmd.Parameters.AddWithValue("@Alt_Identity_Proof_Value", TFM.Alt_Identity_Proof_Value);
cmd.Parameters.AddWithValue("@Is_Informed_Person", "none");
cmd.ExecuteNonQuery();
con.Close();
ViewBag.message = "Verified";
con.Open();
SqlCommand cmd2 = new SqlCommand("SP_CRUDBeneficiaryDetails", con);
cmd2.CommandType = System.Data.CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@condition", "insert");
cmd2.Parameters.AddWithValue("@First_Name ", TFM.First_Name);
cmd2.Parameters.AddWithValue("@Last_Name", TFM.Last_Name);
cmd2.Parameters.AddWithValue("@Middle_Name", TFM.Middle_Name);
cmd2.Parameters.AddWithValue("@DOB", dat);
cmd2.Parameters.AddWithValue("@Mobile", "None");
cmd2.Parameters.AddWithValue("@Relationship", "none");
cmd2.Parameters.AddWithValue("@Marital_Status", "none");
cmd2.Parameters.AddWithValue("@Religion", "none");
cmd2.Parameters.AddWithValue("@Identity_proof", TFM.Identity_Proof);
cmd2.Parameters.AddWithValue("@Identity_proof_value", TFM.Identity_Proof_Value);
cmd2.Parameters.AddWithValue("@Alt_Identity_proof", TFM.Alt_Identity_Proof);
cmd2.Parameters.AddWithValue("@Alt_Identity_proof_value", TFM.Alt_Identity_Proof_Value);
cmd2.Parameters.AddWithValue("@Address1", TFM.Address1);
if (TFM.Address2 != null || TFM.Address2 == "")
{
cmd2.Parameters.AddWithValue("@Address2", TFM.Address2);
}
else
{
TFM.Address2 = "None";
cmd2.Parameters.AddWithValue("@Address2", TFM.Address2);
}
if (TFM.Address3 != null || TFM.Address3 == "")
{
cmd2.Parameters.AddWithValue("@Address3", TFM.Address3);
}
else
{
TFM.Address3 = "None";
cmd2.Parameters.AddWithValue("@Address3", TFM.Address3);
}
cmd2.Parameters.AddWithValue("@City", TFM.City_txt);
cmd2.Parameters.AddWithValue("@State", TFM.State_txt);
cmd2.Parameters.AddWithValue("@Pin", TFM.Pin);
cmd2.Parameters.AddWithValue("@aid", 0);
cmd2.Parameters.AddWithValue("@tid", TFM.ddltid);
cmd2.Parameters.AddWithValue("@beneficiary_type", "none");
cmd2.ExecuteNonQuery();
con.Close();
int bpid = 0;
con.Open();
string qcheck = "select max(bpId) as bpId from BeneficiaryDetails ";
SqlDataAdapter dachk = new SqlDataAdapter(qcheck, con);
DataTable dtchk = new DataTable();
dachk.Fill(dtchk);
if (dtchk.Rows.Count > 0)
{
bpid = Convert.ToInt32(dtchk.Rows[0]["bpId"]);
}
con.Close();
con.Open();
string qu = "update BeneficiaryDetails set fetchid = 'TF' where bpId = " + bpid + "";
SqlCommand cmdu = new SqlCommand(qu, con);
cmdu.ExecuteNonQuery();
con.Close();
//}
//else
//{
// ViewBag.message = "link";
//}
//con.Open();
//string lastvisit = "insert into PageActive () values ";
//SqlCommand cmdv = new SqlCommand(lastvisit,con);
//cmdv.ExecuteNonQuery();
//con.Close();
ModelState.Clear();
return(View("~/Views/AddTestatorFamily/AddTestatorFamilyPageContent.cshtml"));
}
public ActionResult UpdateTestatorFamilyFormData(TestatorFamilyModel TFM)
{
// check type
string typ5 = "";
con.Open();
string qq15 = "select Type from users where uId = " + Convert.ToInt32(Session["uuid"]) + " ";
SqlDataAdapter daa5 = new SqlDataAdapter(qq15, con);
DataTable dtt5 = new DataTable();
daa5.Fill(dtt5);
con.Close();
if (dtt5.Rows.Count > 0)
{
typ5 = dtt5.Rows[0]["Type"].ToString();
}
//end
if (typ5 == "Testator")
{
// check will status
con.Open();
string qry1 = "select Will from users where Will = 1 ";
SqlDataAdapter daa1 = new SqlDataAdapter(qry1, con);
DataTable dtt1 = new DataTable();
daa1.Fill(dtt1);
if (dtt1.Rows.Count > 0)
{
ViewBag.documentbtn1 = "true";
}
con.Close();
//end
// check codocil status
con.Open();
string qry2 = "select Codocil from users where Codocil = 1 ";
SqlDataAdapter daa2 = new SqlDataAdapter(qry2, con);
DataTable dtt2 = new DataTable();
daa2.Fill(dtt2);
if (dtt2.Rows.Count > 0)
{
ViewBag.documentbtn2 = "true";
}
con.Close();
//end
// check Poa status
con.Open();
string qry4 = "select POA from users where POA = 1 ";
SqlDataAdapter daa4 = new SqlDataAdapter(qry4, con);
DataTable dtt4 = new DataTable();
daa4.Fill(dtt4);
if (dtt4.Rows.Count > 0)
{
ViewBag.documentbtn3 = "true";
}
con.Close();
//end
// check gift deeds status
con.Open();
string qry3 = "select Giftdeeds from users where Giftdeeds = 1 ";
SqlDataAdapter daa3 = new SqlDataAdapter(qry3, con);
DataTable dtt3 = new DataTable();
daa3.Fill(dtt3);
if (dtt3.Rows.Count > 0)
{
ViewBag.documentbtn4 = "true";
}
con.Close();
//end
}
else
{
ViewBag.showtitle = "true";
ViewBag.documentlink = "true";
}
// roleassignment
List <LoginModel> Lmlist = new List <LoginModel>();
con.Open();
string q = "select * from Assignment_Roles where RoleId = " + Convert.ToInt32(Session["rId"]) + "";
SqlDataAdapter da3 = new SqlDataAdapter(q, con);
DataTable dt3 = new DataTable();
da3.Fill(dt3);
if (dt3.Rows.Count > 0)
{
for (int i = 0; i < dt3.Rows.Count; i++)
{
LoginModel lm = new LoginModel();
lm.PageName = dt3.Rows[i]["PageName"].ToString();
lm.PageStatus = dt3.Rows[i]["PageStatus"].ToString();
lm.Action = dt3.Rows[i]["Action"].ToString();
lm.Nav1 = dt3.Rows[i]["Nav1"].ToString();
lm.Nav2 = dt3.Rows[i]["Nav2"].ToString();
Lmlist.Add(lm);
}
ViewBag.PageName = Lmlist;
}
con.Close();
//end
con.Open();
SqlCommand cmd = new SqlCommand("SP_CRUDtestatorfamily", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@condition", "update");
cmd.Parameters.AddWithValue("@fId", TFM.fId);
cmd.Parameters.AddWithValue("@First_Name", TFM.First_Name);
cmd.Parameters.AddWithValue("@Last_Name", TFM.Last_Name);
cmd.Parameters.AddWithValue("@Middle_Name", TFM.Middle_Name);
DateTime dat = DateTime.ParseExact(TFM.Dob, "dd-MM-yyyy", CultureInfo.InvariantCulture);
cmd.Parameters.AddWithValue("@DOB", dat);
cmd.Parameters.AddWithValue("@Marital_Status", "none");
cmd.Parameters.AddWithValue("@Religion", "none");
cmd.Parameters.AddWithValue("@Relationship", TFM.RelationshipTxt);
cmd.Parameters.AddWithValue("@Address1", TFM.Address1);
cmd.Parameters.AddWithValue("@Address2", TFM.Address2);
cmd.Parameters.AddWithValue("@Address3", TFM.Address3);
cmd.Parameters.AddWithValue("@City", TFM.City_txt);
cmd.Parameters.AddWithValue("@State", TFM.State_txt);
cmd.Parameters.AddWithValue("@tId", TFM.ddltid);
cmd.Parameters.AddWithValue("@Pin", TFM.Pin);
cmd.Parameters.AddWithValue("@active", TFM.active);
cmd.Parameters.AddWithValue("@Identity_Proof", TFM.Identity_Proof);
cmd.Parameters.AddWithValue("@Identity_Proof_Value", TFM.Identity_Proof_Value);
cmd.Parameters.AddWithValue("@Alt_Identity_Proof", TFM.Alt_Identity_Proof);
cmd.Parameters.AddWithValue("@Alt_Identity_Proof_Value", TFM.Alt_Identity_Proof_Value);
cmd.Parameters.AddWithValue("@Is_Informed_Person", "none");
cmd.ExecuteNonQuery();
con.Close();
ViewBag.message = "Verified";
return(View("~/Views/AddTestatorFamily/AddTestatorFamilyPageContent.cshtml"));
}
