public string DeleteTestatorFormRecords(TestatorFormModel 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.documentlink = "true"; } int index = Convert.ToInt32(Request["send"]); con.Open(); SqlCommand cmd = new SqlCommand("SP_CRUDTestatorDetails", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@condition", "delete"); cmd.Parameters.AddWithValue("@tId", index); cmd.Parameters.AddWithValue("@First_Name", ""); cmd.Parameters.AddWithValue("@Last_Name", ""); cmd.Parameters.AddWithValue("@Middle_Name", ""); cmd.Parameters.AddWithValue("@DOB", ""); cmd.Parameters.AddWithValue("@Occupation", ""); cmd.Parameters.AddWithValue("@Mobile", ""); cmd.Parameters.AddWithValue("@Email", ""); cmd.Parameters.AddWithValue("@maritalStatus", ""); cmd.Parameters.AddWithValue("@Relationship", ""); cmd.Parameters.AddWithValue("@Religion", ""); cmd.Parameters.AddWithValue("@Identity_Proof", ""); cmd.Parameters.AddWithValue("@Identity_proof_Value", ""); cmd.Parameters.AddWithValue("@Alt_Identity_Proof", ""); cmd.Parameters.AddWithValue("@Alt_Identity_proof_Value", ""); cmd.Parameters.AddWithValue("@Gender", ""); cmd.Parameters.AddWithValue("@Address1", ""); cmd.Parameters.AddWithValue("@Address2", ""); cmd.Parameters.AddWithValue("@Address3", ""); cmd.Parameters.AddWithValue("@City", ""); cmd.Parameters.AddWithValue("@State", ""); cmd.Parameters.AddWithValue("@Country", ""); cmd.Parameters.AddWithValue("@Pin", ""); cmd.Parameters.AddWithValue("@active", ""); cmd.Parameters.AddWithValue("@Contact_Verification", ""); cmd.Parameters.AddWithValue("@Email_Verification", ""); cmd.Parameters.AddWithValue("@Mobile_Verification_Status", ""); cmd.Parameters.AddWithValue("@Email_OTP", ""); cmd.Parameters.AddWithValue("@Mobile_OTP", ""); cmd.Parameters.AddWithValue("@uid", ""); cmd.ExecuteNonQuery(); con.Close(); // check roles 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); } } con.Close(); //end string testString = ""; for (int i = 0; i < Lmlist.Count(); i++) { testString = Lmlist[19].Action; } con.Open(); string query = "select * from TestatorDetails"; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); string data = ""; if (dt.Rows.Count > 0) { if (testString == "1,2,0" || testString == "0,2,0" || testString == "0,2,3" || testString == "0,2,3" || testString == "0,2,0") { for (int i = 0; i < dt.Rows.Count; i++) { data = data + "<tr class='nr'><td>" + dt.Rows[i]["tId"].ToString() + "</td>" + "<td>" + dt.Rows[i]["First_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Last_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Middle_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["DOB"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Occupation"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Mobile"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Email"].ToString() + "</td>" + "<td>" + dt.Rows[i]["maritalStatus"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Relationship"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Religion"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Identity_Proof"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Identity_proof_Value"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Alt_Identity_Proof"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Alt_Identity_proof_Value"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Gender"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address1"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address2"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address3"].ToString() + "</td>" + "<td>" + dt.Rows[i]["City"].ToString() + "</td>" + "<td>" + dt.Rows[i]["State"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Country"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Pin"].ToString() + "</td>" + "<td>" + dt.Rows[i]["active"].ToString() + "</td>" + "<td><button type='button' id='" + dt.Rows[i]["tId"].ToString() + "' onClick='Edit(this.id)' class='btn btn-primary'>Edit</button></td></tr>"; } } if (testString == "1,0,3" || testString == "0,0,3" || testString == "0,2,3" || testString == "1,0,3" || testString == "0,0,3") { for (int i = 0; i < dt.Rows.Count; i++) { data = data + "<tr class='nr'><td>" + dt.Rows[i]["tId"].ToString() + "</td>" + "<td>" + dt.Rows[i]["First_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Last_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Middle_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["DOB"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Occupation"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Mobile"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Email"].ToString() + "</td>" + "<td>" + dt.Rows[i]["maritalStatus"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Relationship"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Religion"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Identity_Proof"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Identity_proof_Value"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Alt_Identity_Proof"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Alt_Identity_proof_Value"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Gender"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address1"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address2"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address3"].ToString() + "</td>" + "<td>" + dt.Rows[i]["City"].ToString() + "</td>" + "<td>" + dt.Rows[i]["State"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Country"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Pin"].ToString() + "</td>" + "<td>" + dt.Rows[i]["active"].ToString() + "</td>" + "<td><button type='button' id='" + dt.Rows[i]["tId"].ToString() + "' class='btn btn-danger deletenotification'>Delete</button></td></tr>"; } } if (testString == "1,2,3" || testString == "0,2,3") { for (int i = 0; i < dt.Rows.Count; i++) { data = data + "<tr class='nr'><td>" + dt.Rows[i]["tId"].ToString() + "</td>" + "<td>" + dt.Rows[i]["First_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Last_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Middle_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["DOB"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Occupation"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Mobile"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Email"].ToString() + "</td>" + "<td>" + dt.Rows[i]["maritalStatus"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Relationship"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Religion"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Identity_Proof"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Identity_proof_Value"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Alt_Identity_Proof"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Alt_Identity_proof_Value"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Gender"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address1"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address2"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address3"].ToString() + "</td>" + "<td>" + dt.Rows[i]["City"].ToString() + "</td>" + "<td>" + dt.Rows[i]["State"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Country"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Pin"].ToString() + "</td>" + "<td>" + dt.Rows[i]["active"].ToString() + "</td>" + "<td><button type='button' id='" + dt.Rows[i]["tId"].ToString() + "' onClick='Edit(this.id)' class='btn btn-primary'>Edit</button><button type='button' id='" + dt.Rows[i]["tId"].ToString() + "' class='btn btn-danger deletenotification'>Delete</button></tr>"; } } if (testString == "0,0,0") { for (int i = 0; i < dt.Rows.Count; i++) { data = data + "<tr class='nr'><td>" + dt.Rows[i]["tId"].ToString() + "</td>" + "<td>" + dt.Rows[i]["First_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Last_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Middle_Name"].ToString() + "</td>" + "<td>" + dt.Rows[i]["DOB"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Occupation"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Mobile"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Email"].ToString() + "</td>" + "<td>" + dt.Rows[i]["maritalStatus"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Relationship"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Religion"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Identity_Proof"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Identity_proof_Value"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Alt_Identity_Proof"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Alt_Identity_proof_Value"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Gender"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address1"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address2"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Address3"].ToString() + "</td>" + "<td>" + dt.Rows[i]["City"].ToString() + "</td>" + "<td>" + dt.Rows[i]["State"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Country"].ToString() + "</td>" + "<td>" + dt.Rows[i]["Pin"].ToString() + "</td>" + "<td>" + dt.Rows[i]["active"].ToString() + "</td>"; } } } return(data); }
public ActionResult UpdatingTestatorFormData(TestatorFormModel TFM) { ViewBag.collapse = "true"; // 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 // update email and password con.Open(); string chkmail = "select Email from testatordetails where uId = " + TFM.uId + " "; SqlDataAdapter chkmailadp = new SqlDataAdapter(chkmail, con); DataTable chkmaildt = new DataTable(); chkmailadp.Fill(chkmaildt); if (chkmaildt.Rows.Count > 0) { if (chkmaildt.Rows[0]["Email"].ToString() != TFM.Email) { //generate MOBILE OTP TFM.MobileOTP = String.Empty; string[] saAllowedCharacters = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" }; int iOTPLength = 5; string sTempChars = String.Empty; Random rand = new Random(); for (int i = 0; i < iOTPLength; i++) { int p = rand.Next(0, saAllowedCharacters.Length); sTempChars = saAllowedCharacters[rand.Next(0, saAllowedCharacters.Length)]; TFM.MobileOTP += sTempChars; } //END //generate EMAIL OTP TFM.EmailOTP = String.Empty; string[] saAllowedCharacters2 = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" }; int iOTPLength2 = 5; string sTempChars2 = String.Empty; Random rand2 = new Random(); for (int i = 0; i < iOTPLength2; i++) { int p = rand.Next(0, saAllowedCharacters2.Length); sTempChars2 = saAllowedCharacters2[rand.Next(0, saAllowedCharacters2.Length)]; TFM.EmailOTP += sTempChars2; } //END //generate Password OTP TFM.userPassword = String.Empty; string[] saAllowedCharacters3 = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" }; int iOTPLength3 = 5; string sTempChars3 = String.Empty; Random rand3 = new Random(); for (int i = 0; i < iOTPLength3; i++) { int p = rand3.Next(0, saAllowedCharacters3.Length); sTempChars3 = saAllowedCharacters3[rand3.Next(0, saAllowedCharacters3.Length)]; TFM.userPassword += sTempChars3; } //END con.Close(); con.Open(); string query33 = "update users set userID= '" + TFM.Email + "' , userPwd='" + TFM.userPassword + "' where uId = " + TFM.uId + ""; SqlCommand cmd33 = new SqlCommand(query33, con); cmd33.ExecuteNonQuery(); con.Close(); // update otp for email and mobile con.Open(); string qq = "update TestatorDetails set Contact_Verification = 0 ,Email_Verification = 0 , Mobile_Verification_Status = 0 , Email_OTP = '" + TFM.EmailOTP + "' , Mobile_OTP = '" + TFM.MobileOTP + "' where uId = " + TFM.uId + " "; SqlCommand cmddd = new SqlCommand(qq, con); cmddd.ExecuteNonQuery(); con.Close(); //end if (TFM.Email != "") { //generate Mail string mailto2 = TFM.Email; string userlogin = TFM.Email; string subject2 = "Will Assure Login Credentials"; string text2 = "<font color='Green' style='font-size=3em;'>Your UserId And Password For Logging In Is <br> UserID : " + TFM.Email + " <br> Password : "******"</font>"; string body2 = "<font color='red'>" + text2 + "</font>"; MailMessage msg3 = new MailMessage(); msg3.From = new MailAddress("*****@*****.**"); msg3.To.Add(mailto2); msg3.Subject = subject2; msg3.Body = body2; msg3.IsBodyHtml = true; SmtpClient smtp2 = new SmtpClient("216.10.240.149", 25); smtp2.Credentials = new NetworkCredential("*****@*****.**", "95Bzf%s7"); smtp2.EnableSsl = false; smtp2.Send(msg3); smtp2.Dispose(); //end } // email otp string mailto = TFM.Email; string Userid = TFM.Identity_proof_Value; Session["userid"] = Userid; string subject = "Testing Mail Sending"; string OTP = "<font color='Green' style='font-size=3em;'>" + TFM.EmailOTP + "</font>"; string text = "Your OTP for Verification Is " + OTP + ""; string body = "<font color='red'>" + text + "</font>"; MailMessage msg = new MailMessage(); msg.From = new MailAddress("*****@*****.**"); msg.To.Add(mailto); msg.Subject = subject; msg.Body = body; msg.IsBodyHtml = true; SmtpClient smtp = new SmtpClient("216.10.240.149", 25); smtp.Credentials = new NetworkCredential("*****@*****.**", "95Bzf%s7"); smtp.EnableSsl = false; smtp.Send(msg); smtp.Dispose(); //end con.Close(); } } con.Close(); //end con.Open(); DateTime dat; if (TFM.Dobb != null || TFM.Dobb == "") { dat = DateTime.ParseExact(TFM.Dobb, "dd-MM-yyyy", CultureInfo.InvariantCulture); } else { dat = DateTime.ParseExact(TFM.Dob, "dd-MM-yyyy", CultureInfo.InvariantCulture); } SqlCommand cmd = new SqlCommand("SP_CRUDTestatorDetails", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@condition", "update"); cmd.Parameters.AddWithValue("@tId", TFM.tId); cmd.Parameters.AddWithValue("@First_Name", TFM.First_Name); cmd.Parameters.AddWithValue("@Last_Name", TFM.Last_Name); cmd.Parameters.AddWithValue("@Middle_Name", TFM.Middle_Name); cmd.Parameters.AddWithValue("@DOB", dat); cmd.Parameters.AddWithValue("@Occupation", TFM.Occupation); cmd.Parameters.AddWithValue("@Mobile", TFM.Mobile); cmd.Parameters.AddWithValue("@Email", TFM.Email); cmd.Parameters.AddWithValue("@maritalStatus", TFM.material_status_txt); cmd.Parameters.AddWithValue("@Religion", TFM.Religiontext); cmd.Parameters.AddWithValue("@Relationship", "none"); 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("@Gender", TFM.Gendertext); cmd.Parameters.AddWithValue("@Address1", TFM.Address1); if (TFM.Address2 != null) { cmd.Parameters.AddWithValue("@Address2", TFM.Address2); } else { TFM.Address2 = "None"; cmd.Parameters.AddWithValue("@Address2", TFM.Address2); } if (TFM.Address3 != null) { cmd.Parameters.AddWithValue("@Address3", TFM.Address3); } else { TFM.Address3 = "None"; cmd.Parameters.AddWithValue("@Address3", TFM.Address3); } cmd.Parameters.AddWithValue("@City", TFM.citytext); cmd.Parameters.AddWithValue("@State", TFM.statetext); cmd.Parameters.AddWithValue("@Country", TFM.countrytext); cmd.Parameters.AddWithValue("@Pin", TFM.Pin); if (TFM.active != null) { cmd.Parameters.AddWithValue("@active", TFM.active); } else { cmd.Parameters.AddWithValue("@active", "Active"); } cmd.Parameters.AddWithValue("@Contact_Verification", ""); cmd.Parameters.AddWithValue("@Email_Verification", ""); cmd.Parameters.AddWithValue("@Mobile_Verification_Status", ""); if (TFM.EmailOTP != null) { cmd.Parameters.AddWithValue("@Email_OTP", TFM.EmailOTP); } else { cmd.Parameters.AddWithValue("@Email_OTP", TFM.tempemailotp); } if (TFM.MobileOTP != null) { cmd.Parameters.AddWithValue("@Mobile_OTP", TFM.MobileOTP); } else { cmd.Parameters.AddWithValue("@Mobile_OTP", TFM.tempmobileotp); } cmd.Parameters.AddWithValue("@uid", ""); cmd.ExecuteNonQuery(); //string query = "update TestatorDetails set First_Name = '"+TFM.First_Name+"' , Last_Name='"+TFM.Last_Name+"' ,Middle_Name= '"+TFM.Middle_Name+"' , DOB = '"+ sqlFormattedDate + "' ,Occupation='"+TFM.Occupation+"' ,Mobile='"+TFM.Mobile+"' ,Email = '"+TFM.Email+"' ,maritalStatus='"+TFM.material_status +"' , Religion='"+TFM.Religiontext+ "' , Relationship = '"+TFM.RelationshipTxt + "' ,Identity_Proof='" + TFM.Identity_Proof+"' ,Identity_proof_Value='"+TFM.Identity_proof_Value+"',Alt_Identity_Proof='"+TFM.Alt_Identity_Proof+"',Alt_Identity_proof_Value='"+TFM.Alt_Identity_proof_Value+"',Gender='"+TFM.Gendertext+"',Address1='"+TFM.Address1+"',Address2='"+TFM.Address2+"',Address3='"+TFM.Address3+"',Country='"+TFM.countrytext+"',State='"+TFM.statetext+"',City='"+TFM.citytext+"',Pin='"+TFM.Pin+"',active='"+TFM.active+ "' where tId = " + TFM.tId+""; //SqlCommand cmd = new SqlCommand(query,con); //cmd.ExecuteNonQuery(); if (TFM.EmailOTP != null) { string query2 = "update users set First_Name= '" + TFM.First_Name + "' , Last_Name='" + TFM.Last_Name + "' , Middle_Name='" + TFM.Middle_Name + "' , DOB = '" + Convert.ToDateTime(dat).ToString("dd-MM-yyyy") + "' , Mobile = '" + TFM.Mobile + "' , eMail = '" + TFM.Email + "' , Address1='" + TFM.Address1 + "' , Address2='" + TFM.Address2 + "' , Address3 = '" + TFM.Address3 + "' , City='" + TFM.citytext + "' ,State= '" + TFM.statetext + "' , Pin='" + TFM.Pin + "' , Designation = '2' where uId = " + TFM.uId + " "; SqlCommand cdd = new SqlCommand(query2, con); cdd.ExecuteNonQuery(); con.Close(); } else { string query2 = "update users set First_Name= '" + TFM.First_Name + "' , Last_Name='" + TFM.Last_Name + "' , Middle_Name='" + TFM.Middle_Name + "' , DOB = '" + Convert.ToDateTime(dat).ToString("dd-MM-yyyy") + "' , Mobile = '" + TFM.Mobile + "' , eMail = '" + TFM.Email + "' , Address1='" + TFM.Address1 + "' , Address2='" + TFM.Address2 + "' , Address3 = '" + TFM.Address3 + "' , City='" + TFM.citytext + "' ,State= '" + TFM.statetext + "' , Pin='" + TFM.Pin + "' , Designation = '1' where uId = " + TFM.uId + " "; SqlCommand cdd = new SqlCommand(query2, con); cdd.ExecuteNonQuery(); con.Close(); } ViewBag.Message = "Verified"; return(View("~/Views/UpdateTestators/UpdateTestatorPageContent.cshtml")); }
public ActionResult index() { ViewBag.collapse = "true"; ViewBag.cod = "true"; int NestId = 0; //if (NestId == 0) //{ int getid = Convert.ToInt32(Session["uuid"]); con.Open(); string qq26 = "select tId from TestatorDetails where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlDataAdapter daa26 = new SqlDataAdapter(qq26, con); DataTable dtt26 = new DataTable(); daa26.Fill(dtt26); if (dtt26.Rows.Count > 0) { NestId = Convert.ToInt32(dtt26.Rows[0]["tId"]); } con.Close(); //} // 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(); TestatorFormModel TFM = new TestatorFormModel(); con.Open(); string query = "select * from TestatorDetails where tId = '" + NestId + "' "; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); if (dt.Rows.Count > 0) { TFM.tId = NestId; TFM.First_Name = dt.Rows[0]["First_Name"].ToString(); if (Session["Type"] != null) { if (Session["Type"].ToString() == "DistributorAdmin" || Session["Type"].ToString() == "SuperAdmin" || Session["Type"].ToString() == "Testator") { Session["distid"] = NestId; Session["disttestator"] = TFM.First_Name; } } else { RedirectToAction("LoginPageIndex", "LoginPage"); } TFM.Last_Name = dt.Rows[0]["Last_Name"].ToString(); TFM.Dob = Convert.ToDateTime(dt.Rows[0]["DOB"]).ToString("dd-MM-yyyy"); TFM.Middle_Name = dt.Rows[0]["Middle_Name"].ToString(); if (dt.Rows[0]["Occupation"].ToString() != "none") { TFM.Occupation = dt.Rows[0]["Occupation"].ToString(); } TFM.Mobile = dt.Rows[0]["Mobile"].ToString(); TFM.Email = dt.Rows[0]["Email"].ToString(); if (dt.Rows[0]["maritalStatus"].ToString() != "none") { TFM.material_status_txt = dt.Rows[0]["maritalStatus"].ToString(); } if (dt.Rows[0]["Religion"].ToString() != "none") { TFM.Religiontext = dt.Rows[0]["Religion"].ToString(); } if (dt.Rows[0]["RelationShip"].ToString() != "none") { TFM.RelationshipTxt = dt.Rows[0]["RelationShip"].ToString(); } if (dt.Rows[0]["Identity_Proof"].ToString() != "none") { TFM.Identity_Proof = dt.Rows[0]["Identity_Proof"].ToString(); } if (dt.Rows[0]["Identity_proof_Value"].ToString() != "none") { TFM.Identity_proof_Value = dt.Rows[0]["Identity_proof_Value"].ToString(); } if (dt.Rows[0]["Alt_Identity_Proof"].ToString() != "none") { TFM.Alt_Identity_Proof = dt.Rows[0]["Alt_Identity_Proof"].ToString(); } if (dt.Rows[0]["Alt_Identity_proof_Value"].ToString() != "none") { TFM.Alt_Identity_proof_Value = dt.Rows[0]["Alt_Identity_proof_Value"].ToString(); } if (dt.Rows[0]["Gender"].ToString() != "none") { TFM.Gendertext = dt.Rows[0]["Gender"].ToString(); } if (dt.Rows[0]["Address1"].ToString() != "none") { TFM.Address1 = dt.Rows[0]["Address1"].ToString(); } if (dt.Rows[0]["Address2"].ToString() != "none") { TFM.Address2 = dt.Rows[0]["Address2"].ToString(); } if (dt.Rows[0]["Address3"].ToString() != "none") { TFM.Address3 = dt.Rows[0]["Address3"].ToString(); } if (dt.Rows[0]["City"].ToString() != "none") { TFM.citytext = dt.Rows[0]["City"].ToString(); } if (dt.Rows[0]["State"].ToString() != "none") { TFM.statetext = dt.Rows[0]["State"].ToString(); } if (dt.Rows[0]["Country"].ToString() != "none") { TFM.countrytext = dt.Rows[0]["Country"].ToString(); } if (dt.Rows[0]["Pin"].ToString() != "none") { TFM.Pin = dt.Rows[0]["Pin"].ToString(); } if (dt.Rows[0]["active"].ToString() != "none") { TFM.active = dt.Rows[0]["active"].ToString(); } TFM.uId = Convert.ToInt32(dt.Rows[0]["uId"]); TFM.tempemailotp = dt.Rows[0]["Email_OTP"].ToString(); TFM.tempmobileotp = dt.Rows[0]["Mobile_OTP"].ToString(); } return(View("~/Views/UpdateTestators/UpdateTestatorPageContent.cshtml", TFM)); }
// GET: UpdateTestators public ActionResult UpdateTestatorsIndex(int NestId) { ViewBag.collapse = "true"; ViewBag.cod = "true"; //if (NestId == 0) //{ int getid = Convert.ToInt32(Session["uuid"]); con.Open(); string qq26 = "select tId from TestatorDetails where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlDataAdapter daa26 = new SqlDataAdapter(qq26, con); DataTable dtt26 = new DataTable(); daa26.Fill(dtt26); if (dtt26.Rows.Count > 0) { NestId = Convert.ToInt32(dtt26.Rows[0]["tId"]); } con.Close(); //} // 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(); TestatorFormModel TFM = new TestatorFormModel(); con.Open(); string query = "select * from TestatorDetails where tId = '" + NestId + "' "; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); if (dt.Rows.Count > 0) { TFM.tId = NestId; TFM.First_Name = dt.Rows[0]["First_Name"].ToString(); if (Session["Type"] != null) { if (Session["Type"].ToString() == "DistributorAdmin" || Session["Type"].ToString() == "SuperAdmin" || Session["Type"].ToString() == "Testator") { Session["distid"] = NestId; Session["disttestator"] = TFM.First_Name; } } else { RedirectToAction("LoginPageIndex", "LoginPage"); } TFM.Last_Name = dt.Rows[0]["Last_Name"].ToString(); TFM.Dob = Convert.ToDateTime(dt.Rows[0]["DOB"]).ToString("dd-MM-yyyy"); TFM.Middle_Name = dt.Rows[0]["Middle_Name"].ToString(); if (dt.Rows[0]["Occupation"].ToString() != "none") { TFM.Occupation = dt.Rows[0]["Occupation"].ToString(); } TFM.Mobile = dt.Rows[0]["Mobile"].ToString(); TFM.Email = dt.Rows[0]["Email"].ToString(); if (dt.Rows[0]["maritalStatus"].ToString() != "none") { TFM.material_status_txt = dt.Rows[0]["maritalStatus"].ToString(); } if (dt.Rows[0]["Religion"].ToString() != "none") { TFM.Religiontext = dt.Rows[0]["Religion"].ToString(); } if (dt.Rows[0]["RelationShip"].ToString() != "none") { TFM.RelationshipTxt = dt.Rows[0]["RelationShip"].ToString(); } if (dt.Rows[0]["Identity_Proof"].ToString() != "none") { TFM.Identity_Proof = dt.Rows[0]["Identity_Proof"].ToString(); } if (dt.Rows[0]["Identity_proof_Value"].ToString() != "none") { TFM.Identity_proof_Value = dt.Rows[0]["Identity_proof_Value"].ToString(); } if (dt.Rows[0]["Alt_Identity_Proof"].ToString() != "none") { TFM.Alt_Identity_Proof = dt.Rows[0]["Alt_Identity_Proof"].ToString(); } if (dt.Rows[0]["Alt_Identity_proof_Value"].ToString() != "none") { TFM.Alt_Identity_proof_Value = dt.Rows[0]["Alt_Identity_proof_Value"].ToString(); } if (dt.Rows[0]["Gender"].ToString() != "none") { TFM.Gendertext = dt.Rows[0]["Gender"].ToString(); } if (dt.Rows[0]["Address1"].ToString() != "none") { TFM.Address1 = dt.Rows[0]["Address1"].ToString(); } if (dt.Rows[0]["Address2"].ToString() != "none") { TFM.Address2 = dt.Rows[0]["Address2"].ToString(); } if (dt.Rows[0]["Address3"].ToString() != "none") { TFM.Address3 = dt.Rows[0]["Address3"].ToString(); } if (dt.Rows[0]["City"].ToString() != "none") { TFM.citytext = dt.Rows[0]["City"].ToString(); } if (dt.Rows[0]["State"].ToString() != "none") { TFM.statetext = dt.Rows[0]["State"].ToString(); } if (dt.Rows[0]["Country"].ToString() != "none") { TFM.countrytext = dt.Rows[0]["Country"].ToString(); } if (dt.Rows[0]["Pin"].ToString() != "none") { TFM.Pin = dt.Rows[0]["Pin"].ToString(); } if (dt.Rows[0]["active"].ToString() != "none") { TFM.active = dt.Rows[0]["active"].ToString(); } TFM.uId = Convert.ToInt32(dt.Rows[0]["uId"]); TFM.tempemailotp = dt.Rows[0]["Email_OTP"].ToString(); TFM.tempmobileotp = dt.Rows[0]["Mobile_OTP"].ToString(); } //////////// check document completion ///////////// // for testator family con.Open(); string qchk001 = "select a.fId , a.First_Name , a.Last_Name , a.Middle_Name , a.DOB , a.Marital_Status , a.Religion , a.Relationship , a.Address1 , a.Address2 , a.Address3 , a.City , a.State , a.Pin , a.tId , a.active , a.Identity_Proof , a.Identity_Proof_Value , a.Alt_Identity_Proof , a.Alt_Identity_Proof_Value , a.Is_Informed_Person from testatorFamily a inner join TestatorDetails b on a.tId=b.tId where b.tId = " + NestId + " "; SqlDataAdapter chk001da = new SqlDataAdapter(qchk001, con); DataTable chk001dt = new DataTable(); chk001da.Fill(chk001dt); con.Close(); if (chk001dt.Rows.Count > 0) { } else { return(RedirectToAction("AddTestatorFamilyIndex", "AddTestatorFamily")); } //end // for beneficiary con.Open(); string qchk002 = "select a.bpId , a.First_Name , a.Last_Name , a.Middle_Name , a.DOB , a.Mobile , a.Relationship , a.Marital_Status , a.Religion , a.Identity_proof , a.Identity_proof_value , a.Alt_Identity_proof , a.Alt_Identity_proof_value , a.Address1 , a.Address2 , a.Address3 , a.City , a.State , a.Pin , a.aiid , a.tId , a.dateCreated , a.createdBy , a.documentId , a.beneficiary_type from BeneficiaryDetails a inner join TestatorDetails b on a.tId=b.tId where b.tId = " + NestId + ""; SqlDataAdapter chk002da = new SqlDataAdapter(qchk002, con); DataTable chk002dt = new DataTable(); chk002da.Fill(chk002dt); con.Close(); if (chk002dt.Rows.Count > 0) { } else { return(RedirectToAction("AddBeneficiaryIndex", "AddBeneficiary")); } //end // for assetinformation con.Open(); string qchk003 = "select a.aiid , a.atId , a.amId , a.tid , a.docid , a.Json from AssetInformation a inner join TestatorDetails b on a.tid=b.tId where b.tId = " + NestId + " "; SqlDataAdapter chk003da = new SqlDataAdapter(qchk003, con); DataTable chk003dt = new DataTable(); chk003da.Fill(chk003dt); con.Close(); if (chk003dt.Rows.Count > 0) { } else { return(RedirectToAction("AddMainAssetsIndex", "AddMainAssets")); } //end // for asset mapping con.Open(); string qchk006 = "select a.Beneficiary_Asset_ID , a.AssetType_ID , a.AssetCategory_ID , a.SchemeName , a.InstrumentName , a.Beneficiary_ID , a.Proportion , a.tid from BeneficiaryAssets a inner join TestatorDetails b on a.tid=b.tId where b.tId = " + NestId + ""; SqlDataAdapter chk006da = new SqlDataAdapter(qchk006, con); DataTable chk006dt = new DataTable(); chk006da.Fill(chk006dt); con.Close(); if (chk006dt.Rows.Count > 0) { } else { return(RedirectToAction("AddAssetMappingIndex", "AddAssetMapping")); } //end // for nominee con.Open(); string qchk007 = " select a.nId , a.First_Name , a.Last_Name , a.Middle_Name , a.DOB , a.Mobile , a.Relationship , a.Marital_Status , a.Religion , a.Identity_Proof , a.Identity_Proof_Value , a.Alt_Identity_Proof , a.Alt_Identity_Proof_Value , a.Address1 , a.Address2 , a.Address3 , a.City , a.State , a.Pin , a.aiid , a.tId , a.dateCreated , a.createdBy , a.documentId , a.Description_of_Assets from Nominee a inner join TestatorDetails b on a.tId=b.tId where b.tId = " + NestId + " "; SqlDataAdapter chk007da = new SqlDataAdapter(qchk007, con); DataTable chk007dt = new DataTable(); chk007da.Fill(chk007dt); con.Close(); if (chk007dt.Rows.Count > 0) { } else { return(RedirectToAction("AddNomineeIndex", "AddNominee")); } //end // for appointees con.Open(); string qchk008 = "select * from Appointees where tid = " + NestId + " "; SqlDataAdapter chk008da = new SqlDataAdapter(qchk008, con); DataTable chk008dt = new DataTable(); chk008da.Fill(chk008dt); con.Close(); if (chk008dt.Rows.Count > 0) { } else { return(RedirectToAction("AddAppointeesIndex", "AddAppointees")); } //end //end // end return(View("~/Views/UpdateTestators/UpdateTestatorPageContent.cshtml", TFM)); }
public ActionResult insertDocumentDetails(TestatorFormModel TFM) { // DOCUMENT RULES string typeid = ""; int typecat = 0; if (TFM.documenttype == "WillCodocilPOA") { typeid = "1,2,3"; con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "Codocil") { typeid = "2"; con.Open(); string qq1 = "update users set Codocil = '1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "POA") { typeid = "3"; con.Open(); string qq1 = "update users set POA = '1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "Will") { typeid = "1"; con.Open(); string qq1 = "update users set Will = '1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillCodocil") { typeid = "1,2"; con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillPOA") { typeid = "1,3"; con.Open(); string qq1 = "update users set Will = '1' , POA = '1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "CodocilPOA") { typeid = "2,3"; con.Open(); string qq1 = "update users set Codocil = '1' , POA = '1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "CodocilWill") { typeid = "2,1"; con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "POAWill") { typeid = "3,1"; con.Open(); string qq1 = "update users set Will = '1' , POA = '1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "Giftdeeds") { typeid = "3,1"; con.Open(); string qq1 = "update users set Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "GiftdeedsCodocil") { typeid = "3,1"; con.Open(); string qq1 = "update users set Codocil = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "GiftdeedsWill") { typeid = "3,1"; con.Open(); string qq1 = "update users set Will = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "GiftdeedsPOA") { typeid = "3,1"; con.Open(); string qq1 = "update users set POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillGiftdeeds") { typeid = "3,1"; con.Open(); string qq1 = "update users set Will = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "POAGiftdeeds") { typeid = "3,1"; con.Open(); string qq1 = "update users set POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "CodocilGiftdeeds") { typeid = "3,1"; con.Open(); string qq1 = "update users set Codocil = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "CodocilGiftdeedsWill") { typeid = "3,1"; con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "CodocilGiftdeedsWillPOA") { typeid = "3,1"; con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "CodocilWillGiftdeedsPOA") { typeid = "3,1"; con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillCodocilPOAGiftdeeds") { typeid = "3,1"; con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillCodocilPOAGiftdeedsLivingWill") { con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "LivingWill") { con.Open(); string qq1 = "update users set LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "LivingWillWillCodocilPOAGiftdeeds") { con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "CodocilGiftdeedsLivingWillWillPOA") { con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "LivingWillWillPOA") { con.Open(); string qq1 = "update users set Will = '1' , POA = '1' , LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "POALivingWillWill") { con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "LivingWillPOAGiftdeeds") { con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "POAGiftdeeds") { con.Open(); string qq1 = "update users set POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "POAGiftdeedsWill") { con.Open(); string qq1 = "update users set Will = '1' , POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "POAWillCodocil") { con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "CodocilLivingWill") { con.Open(); string qq1 = "update users set Codocil = '1' , LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "CodocilGiftdeedsLivingWill") { con.Open(); string qq1 = "update users set Codocil = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "POALivingWill") { con.Open(); string qq1 = "update users set Will = '1' , POA = '1' , . LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "GiftdeedsLivingWill") { con.Open(); string qq1 = "update users set Will = '1' Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillCodocilPOAGiftdeedsLivingWill") { con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , POA = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "POAGiftDeedsLivingWill") { con.Open(); string qq1 = "update users set POA = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "LivingWillGiftDeedsPOA") { con.Open(); string qq1 = "update users set POA = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "GiftDeedsLivingWillPOA") { con.Open(); string qq1 = "update users set POA = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "LivingWillCodocil") { con.Open(); string qq1 = "update users set Codocil = '1' , LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "LivingWillGiftdeeds") { con.Open(); string qq1 = "update users set Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillGiftdeeds") { con.Open(); string qq1 = "update users set Will = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "GiftdeedsPOA") { con.Open(); string qq1 = "update users set POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "LivingWillPOA") { con.Open(); string qq1 = "update users set POA = '1' , LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillGiftdeedsCodocil") { con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillGiftdeedsLivingWill") { con.Open(); string qq1 = "update users set Will = '1' , Giftdeeds='1', LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "CodocilPOAGiftdeeds") { con.Open(); string qq1 = "update users set Codocil = '1' , POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillCodocilGiftdeeds") { con.Open(); string qq1 = "update users set Will = '1' , Codocil = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillLivingWill") { con.Open(); string qq1 = "update users set Will = '1' , LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "LivingWillWill") { con.Open(); string qq1 = "update users set Will = '1' , LivingWill='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "WillPOAGiftdeeds") { con.Open(); string qq1 = "update users set Will = '1' , POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "POAWillGiftdeeds") { con.Open(); string qq1 = "update users set Will = '1' , POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } if (TFM.documenttype == "GiftdeedsPOAWill") { con.Open(); string qq1 = "update users set Will = '1' , POA = '1' , Giftdeeds='1' where uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlCommand cc1 = new SqlCommand(qq1, con); cc1.ExecuteNonQuery(); con.Close(); } ViewBag.PaymentLink = "true"; return(View("~/Views/Frontend/Document.cshtml")); }
public ActionResult insertDocumentDetails(TestatorFormModel TFM) { // 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 , Designation from users where Will = 1 and Designation = 1 and uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlDataAdapter daa1 = new SqlDataAdapter(qry1, con); DataTable dtt1 = new DataTable(); daa1.Fill(dtt1); if (dtt1.Rows.Count > 0) { if (Convert.ToInt32(dtt1.Rows[0]["Will"]) == 1 && Convert.ToInt32(dtt1.Rows[0]["Designation"]) == 1) { ViewBag.documentbtn1 = "true"; } } con.Close(); //end // check codocil status con.Open(); string qry2 = "select Codocil , Designation from users where Codocil = 1 and Designation = 1 and uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlDataAdapter daa2 = new SqlDataAdapter(qry2, con); DataTable dtt2 = new DataTable(); daa2.Fill(dtt2); if (dtt2.Rows.Count > 0) { if (Convert.ToInt32(dtt2.Rows[0]["Codocil"]) == 1 && Convert.ToInt32(dtt2.Rows[0]["Designation"]) == 1) { ViewBag.documentbtn2 = "true"; } } con.Close(); //end // check Poa status con.Open(); string qry4 = "select POA , Designation from users where POA = 1 and Designation = 1 and uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlDataAdapter daa4 = new SqlDataAdapter(qry4, con); DataTable dtt4 = new DataTable(); daa4.Fill(dtt4); if (dtt4.Rows.Count > 0) { if (Convert.ToInt32(dtt4.Rows[0]["POA"]) == 1 && Convert.ToInt32(dtt4.Rows[0]["Designation"]) == 1) { ViewBag.documentbtn3 = "true"; } } con.Close(); //end // check gift deeds status con.Open(); string qry3 = "select Giftdeeds , Designation from users where Will = 1 and Designation = 1 and uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlDataAdapter daa3 = new SqlDataAdapter(qry3, con); DataTable dtt3 = new DataTable(); daa3.Fill(dtt3); if (dtt3.Rows.Count > 0) { if (dtt3.Rows[0]["Giftdeeds"] != null) { if (Convert.ToInt32(dtt3.Rows[0]["Giftdeeds"]) == 1 && Convert.ToInt32(dtt3.Rows[0]["Designation"]) == 1) { ViewBag.documentbtn4 = "true"; } } } con.Close(); //end // check Living Will status con.Open(); string qry312 = "select LivingWill , Designation from users where Will = 1 and Designation = 1 and uId = " + Convert.ToInt32(Session["uuid"]) + " "; SqlDataAdapter daa23 = new SqlDataAdapter(qry312, con); DataTable dtt43 = new DataTable(); daa23.Fill(dtt43); if (dtt43.Rows.Count > 0) { if (Convert.ToInt32(dtt43.Rows[0]["LivingWill"]) == 1 && Convert.ToInt32(dtt43.Rows[0]["Designation"]) == 1) { ViewBag.documentbtn5 = "true"; } } con.Close(); //end } else { ViewBag.showtitle = "true"; ViewBag.documentlink = "true"; } 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(); int testatorid = 0; int templateid = 0; string testatortype = ""; if (Session["TestatorEmail"] == null) { RedirectToAction("LoginPageIndex", "LoginPage"); } // coupon status if (TFM.txtCoupon != null) { con.Open(); string checkcoupon = "select * from couponAllotment where Coupon_Number = " + TFM.txtCoupon + " and Status = 'Active' "; SqlDataAdapter da = new SqlDataAdapter(checkcoupon, con); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { string upcoupon = "update couponAllotment set Status = 'Inactive' , Tid=" + testatorid + " "; SqlCommand cmd2 = new SqlCommand(upcoupon, con); cmd2.ExecuteNonQuery(); string upcoupon2 = "update discountCoupons set status = 'Inactive' , Coupon_Number=" + TFM.txtCoupon + " "; SqlCommand cmd22 = new SqlCommand(upcoupon2, con); cmd22.ExecuteNonQuery(); } else { ViewBag.Message = "checkCoupon"; } con.Close(); } //end // get coupon id con.Open(); string query5 = "select a.couponId from couponAllotment a inner join users b on a.uId=b.uId where b.uId = " + TFM.distributor_id + ""; SqlDataAdapter da4 = new SqlDataAdapter(query5, con); DataTable dt4 = new DataTable(); da4.Fill(dt4); int couponsid = 0; if (dt4.Rows.Count > 0) { couponsid = Convert.ToInt32(dt4.Rows[0]["couponId"]); } con.Close(); //end con.Open(); string gettid = "select top 1 tId from TestatorDetails order by tId desc"; SqlDataAdapter datid = new SqlDataAdapter(gettid, con); DataTable dttid = new DataTable(); datid.Fill(dttid); if (dttid.Rows.Count > 0) { testatorid = Convert.ToInt32(dttid.Rows[0]["tId"]); } con.Close(); // get distributor id con.Open(); string gedistid = "select uId from TestatorDetails where tId=" + testatorid + " "; SqlDataAdapter distid = new SqlDataAdapter(gedistid, con); DataTable distdt = new DataTable(); distid.Fill(distdt); int distidd = 0; if (distdt.Rows.Count > 0) { distidd = Convert.ToInt32(distdt.Rows[0]["uId"]); } con.Close(); //end con.Open(); string q1 = "insert into documentMaster (tId,templateId,IsUpdatetable,uId,pId,created_by,testator_type,couponId,adminVerification) values (" + testatorid + " , " + templateid + " , 'Yes' , " + TFM.distributor_id + " , 1 , '" + TFM.Document_Created_By_txt + "' , '" + testatortype + "' , " + couponsid + " , 2)"; SqlCommand c = new SqlCommand(q1, con); c.ExecuteNonQuery(); con.Close(); //end // DOCUMENT RULES int typeid = 0; int typecat = 0; if (TFM.documenttype == "Will") { typeid = 1; } if (TFM.documentcategory == "Quick") { typecat = 1; } if (TFM.documentcategory == "Detailed") { typecat = 2; } con.Open(); string q2 = "insert into documentRules (documentType,category,tid) values (" + typeid + " , " + typecat + " , " + testatorid + " )"; SqlCommand c1 = new SqlCommand(q2, con); c1.ExecuteNonQuery(); con.Close(); // //1st condition if (TFM.Amt_Paid_By_txt == "Distributor" && TFM.Document_Created_By_txt == "Distributor") { TFM.Authentication_Required = 0; TFM.Link_Required = 0; TFM.Login_Required = 0; con.Open(); string query1 = "insert into Authorization_Rules (Document_Created_By,Distributor_Id,Amt_Paid_By,Testator_Id,Authentication_Required,Link_Required,Login_Required) values ('" + TFM.Document_Created_By_txt + "' , " + distidd + " , '" + TFM.Amt_Paid_By_txt + "' , " + testatorid + " , '" + TFM.Authentication_Required + "' , '" + TFM.Link_Required + "' , '" + TFM.Login_Required + "') "; SqlCommand cmd2 = new SqlCommand(query1, con); cmd2.ExecuteNonQuery(); con.Close(); ModelState.Clear(); return(View("~/Views/AddTestatorsForm/AddTestatorPageContent.cshtml")); } //end //2nd condition if (TFM.Amt_Paid_By_txt == "Distributor" && TFM.Document_Created_By_txt == "Testator") { TFM.Authentication_Required = 1; TFM.Link_Required = 1; TFM.Login_Required = 1; con.Open(); string query2 = "insert into Authorization_Rules (Document_Created_By,Distributor_Id,Amt_Paid_By,Testator_Id,Authentication_Required,Link_Required,Login_Required) values ('" + TFM.Document_Created_By_txt + "' , " + distidd + " , '" + TFM.Amt_Paid_By_txt + "' , " + testatorid + " , '" + TFM.Authentication_Required + "' , '" + TFM.Link_Required + "' , '" + TFM.Login_Required + "') "; SqlCommand cmd2 = new SqlCommand(query2, con); cmd2.ExecuteNonQuery(); con.Close(); if (Session["mailto"] == null) { RedirectToAction("LoginPageIndex", "LoginPage"); } if (Session["userid"] == null) { RedirectToAction("LoginPageIndex", "LoginPage"); } //// new mail code //string mailto = TFM.Email; //string Userid = TFM.Identity_proof_Value; //mailto = Session["TestatorEmail"].ToString(); //Session["userid"] = Userid; //string subject = "Testing Mail Sending"; //string OTP = "<font color='Green' style='font-size=3em;'>" + TFM.EmailOTP + "</font>"; //string text = "Your OTP for Verification Is " + OTP + ""; //string body = "<font color='red'>" + text + "</font>"; //MailMessage msg = new MailMessage(); //msg.From = new MailAddress("*****@*****.**"); //msg.To.Add(mailto); //msg.Subject = subject; //msg.Body = body; //msg.IsBodyHtml = true; //SmtpClient smtp = new SmtpClient("216.10.240.149", 25); //smtp.Credentials = new NetworkCredential("*****@*****.**", "95Bzf%s7"); //smtp.EnableSsl = false; //smtp.Send(msg); //smtp.Dispose(); ////end } //end // 3rd condtion if (TFM.Amt_Paid_By_txt == "Testator" && TFM.Document_Created_By_txt == "Distributor") { TFM.Authentication_Required = 1; TFM.Link_Required = 1; TFM.Login_Required = 1; con.Open(); string query3 = "insert into Authorization_Rules (Document_Created_By,Distributor_Id,Amt_Paid_By,Testator_Id,Authentication_Required,Link_Required,Login_Required) values ('" + TFM.Document_Created_By_txt + "' , " + distidd + " , '" + TFM.Amt_Paid_By_txt + "' , " + testatorid + " , '" + TFM.Authentication_Required + "' , '" + TFM.Link_Required + "' , '" + TFM.Login_Required + "') "; SqlCommand cmd2 = new SqlCommand(query3, con); cmd2.ExecuteNonQuery(); con.Close(); // new mail code string mailto = TFM.Email; string Userid = TFM.Identity_proof_Value; mailto = Session["TestatorEmail"].ToString(); Session["userid"] = Userid; string subject = "Testing Mail Sending"; string OTP = "<font color='Green' style='font-size=3em;'>" + TFM.EmailOTP + "</font>"; string text = "Your OTP for Verification Is " + OTP + ""; string body = "<font color='red'>" + text + "</font>"; MailMessage msg = new MailMessage(); msg.From = new MailAddress("*****@*****.**"); msg.To.Add(mailto); msg.Subject = subject; msg.Body = body; msg.IsBodyHtml = true; SmtpClient smtp = new SmtpClient("216.10.240.149", 25); smtp.Credentials = new NetworkCredential("*****@*****.**", "95Bzf%s7"); smtp.EnableSsl = false; smtp.Send(msg); smtp.Dispose(); //end } //end //4th condition if (TFM.Amt_Paid_By_txt == "Testator" && TFM.Document_Created_By_txt == "Testator") { TFM.Authentication_Required = 1; TFM.Link_Required = 1; TFM.Login_Required = 1; con.Open(); string query4 = "insert into Authorization_Rules (Document_Created_By,Distributor_Id,Amt_Paid_By,Testator_Id,Authentication_Required,Link_Required,Login_Required) values ('" + TFM.Document_Created_By_txt + "' , " + distidd + " , '" + TFM.Amt_Paid_By_txt + "' , " + testatorid + " , '" + TFM.Authentication_Required + "' , '" + TFM.Link_Required + "' , '" + TFM.Login_Required + "') "; SqlCommand cmd2 = new SqlCommand(query4, con); cmd2.ExecuteNonQuery(); con.Close(); // new mail code string mailto = TFM.Email; string Userid = TFM.Identity_proof_Value; mailto = Session["TestatorEmail"].ToString(); Session["userid"] = Userid; string subject = "Testing Mail Sending"; string OTP = "<font color='Green' style='font-size=3em;'>" + TFM.EmailOTP + "</font>"; string text = "Your OTP for Verification Is " + OTP + ""; string body = "<font color='red'>" + text + "</font>"; MailMessage msg = new MailMessage(); msg.From = new MailAddress("*****@*****.**"); msg.To.Add(mailto); msg.Subject = subject; msg.Body = body; msg.IsBodyHtml = true; SmtpClient smtp = new SmtpClient("216.10.240.149", 25); smtp.Credentials = new NetworkCredential("*****@*****.**", "95Bzf%s7"); smtp.EnableSsl = false; smtp.Send(msg); smtp.Dispose(); //end } //end string v1 = Eramake.eCryptography.Encrypt(TFM.EmailOTP); return(View("~/Views/Documentpg/DocumentPgPageContent.cshtml")); }