// GET: UpdateAlternateBeneficiary public ActionResult UpdateAlternateBeneficiaryIndex(int NestId) { // 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(); AlternateBeneficiaryModel ABM = new AlternateBeneficiaryModel(); ABM.lnk_bd_id = NestId; con.Open(); string query = "select * from alternate_Beneficiary"; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); ABM.First_Name = dt.Rows[0]["First_Name"].ToString(); ABM.Last_Name = dt.Rows[0]["Last_Name"].ToString(); ABM.Middle_Name = dt.Rows[0]["Middle_Name"].ToString(); ABM.Dob = dt.Rows[0]["DOB"].ToString(); ABM.Mobile = dt.Rows[0]["Mobile"].ToString(); ABM.Relationship = dt.Rows[0]["Relationship"].ToString(); ABM.Marital_Status = dt.Rows[0]["Marital_Status"].ToString(); ABM.Religion = dt.Rows[0]["Religion"].ToString(); ABM.Identity_Proof = dt.Rows[0]["Identity_Proof"].ToString(); ABM.Identity_Proof_Value = dt.Rows[0]["Identity_Proof_Value"].ToString(); ABM.Alt_Identity_Proof = dt.Rows[0]["Alt_Identity_Proof"].ToString(); ABM.Alt_Identity_Proof_Value = dt.Rows[0]["Alt_Identity_Proof_Value"].ToString(); ABM.Address1 = dt.Rows[0]["Address1"].ToString(); ABM.Address2 = dt.Rows[0]["Address2"].ToString(); ABM.Address3 = dt.Rows[0]["Address3"].ToString(); ABM.citytext = dt.Rows[0]["City"].ToString(); ABM.State = dt.Rows[0]["State"].ToString(); ABM.Pin = dt.Rows[0]["Pin"].ToString(); return(View("~/Views/UpdateAlternateBeneficiary/UpdateAlternateBeneficiaryPageContent.cshtml", ABM)); }
public ActionResult UpdatingAlternateBeneficiary(AlternateBeneficiaryModel ABM) { // 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_CRUD_alternate_Beneficiary", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@condition", "update"); cmd.Parameters.AddWithValue("@lnk_bd_id", ABM.lnk_bd_id); cmd.Parameters.AddWithValue("@bpId", ABM.bpId); cmd.Parameters.AddWithValue("@First_Name", ABM.First_Name); cmd.Parameters.AddWithValue("@Last_Name", ABM.Last_Name); cmd.Parameters.AddWithValue("@Middle_Name", ABM.Middle_Name); DateTime dat = DateTime.ParseExact(ABM.Dob, "dd-MM-yyyy", CultureInfo.InvariantCulture); cmd.Parameters.AddWithValue("@DOB", dat); cmd.Parameters.AddWithValue("@Mobile", ABM.Mobile); cmd.Parameters.AddWithValue("@Relationship", ABM.Religion_ID); cmd.Parameters.AddWithValue("@Marital_Status", ABM.Marital_Status); cmd.Parameters.AddWithValue("@Religion", ABM.Religion); cmd.Parameters.AddWithValue("@Identity_Proof", ABM.Identity_Proof); cmd.Parameters.AddWithValue("@Identity_Proof_Value", ABM.Identity_Proof_Value); cmd.Parameters.AddWithValue("@Alt_Identity_Proof", ABM.Alt_Identity_Proof); cmd.Parameters.AddWithValue("@Alt_Identity_Proof_Value", ABM.Alt_Identity_Proof_Value); cmd.Parameters.AddWithValue("@Address1", ABM.Address1); cmd.Parameters.AddWithValue("@Address2", ABM.Address2); cmd.Parameters.AddWithValue("@Address3", ABM.Address3); cmd.Parameters.AddWithValue("@City", ABM.citytext); cmd.Parameters.AddWithValue("@State", ABM.statetext); cmd.Parameters.AddWithValue("@Pin", ABM.Pin); cmd.ExecuteNonQuery(); con.Close(); return(View("~/Views/UpdateAlternateBeneficiary/UpdateAlternateBeneficiaryPageContent.cshtml")); }
public ActionResult InsertAlternateBeneficiaryFormData(AlternateBeneficiaryModel ABM) { // 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 int getbeneficiary = 0; if (Session["bpId"] != null) { getbeneficiary = 1; con.Open(); SqlCommand cmd = new SqlCommand("SP_CRUD_alternate_Beneficiary", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@condition", "insert"); cmd.Parameters.AddWithValue("@bpId", ""); cmd.Parameters.AddWithValue("@First_Name", ABM.First_Name); cmd.Parameters.AddWithValue("@Last_Name", ABM.Last_Name); cmd.Parameters.AddWithValue("@Middle_Name", ABM.Middle_Name); DateTime dat = DateTime.ParseExact(ABM.Dob, "dd-MM-yyyy", CultureInfo.InvariantCulture); cmd.Parameters.AddWithValue("@DOB", dat); cmd.Parameters.AddWithValue("@Mobile", ABM.Mobile); cmd.Parameters.AddWithValue("@Relationship", ABM.Religion_ID); cmd.Parameters.AddWithValue("@Marital_Status", ABM.Marital_Status); cmd.Parameters.AddWithValue("@Religion", ABM.Religion); cmd.Parameters.AddWithValue("@Identity_Proof", ABM.Identity_Proof); cmd.Parameters.AddWithValue("@Identity_Proof_Value", ABM.Identity_Proof_Value); cmd.Parameters.AddWithValue("@Alt_Identity_Proof", ABM.Alt_Identity_Proof); cmd.Parameters.AddWithValue("@Alt_Identity_Proof_Value", ABM.Alt_Identity_Proof_Value); cmd.Parameters.AddWithValue("@Address1", ABM.Address1); cmd.Parameters.AddWithValue("@Address2", ABM.Address2); cmd.Parameters.AddWithValue("@Address3", ABM.Address3); cmd.Parameters.AddWithValue("@City", ABM.citytext); cmd.Parameters.AddWithValue("@State", ABM.statetext); cmd.Parameters.AddWithValue("@Pin", ABM.Pin); cmd.ExecuteNonQuery(); con.Close(); ViewBag.Message = "Verified"; } else { getbeneficiary = 2; ViewBag.Message = "link"; } // Document Rules //get latest id first con.Open(); string getquery = "select top 1 * from documentRules order by wdId desc"; SqlDataAdapter da = new SqlDataAdapter(getquery, con); DataTable dt = new DataTable(); da.Fill(dt); int getruleid = 0; if (dt.Rows.Count > 0) { getruleid = Convert.ToInt32(dt.Rows[0]["wdId"]); } con.Close(); //end con.Open(); string rulequery = "update documentRules set AlternateBenficiaries = " + getbeneficiary + " where wdId = " + getruleid + " "; SqlCommand cmd2 = new SqlCommand(rulequery, con); cmd2.ExecuteNonQuery(); con.Close(); //end ModelState.Clear(); return(View("~/Views/AlternateBeneficiary/AlternateBeneficiaryPageContent.cshtml")); }