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