// GET: UpdateMainAssets
public ActionResult UpdateMainAssetsIndex(int NestId)
{
// check type
string typ = "";
con.Open();
string qq1 = "select Type from users where uId = " + Convert.ToInt32(Session["uuid"]) + " ";
SqlDataAdapter daa = new SqlDataAdapter(qq1, con);
DataTable dtt = new DataTable();
daa.Fill(dtt);
con.Close();
if (dtt.Rows.Count > 0)
{
typ = dtt.Rows[0]["Type"].ToString();
}
//end
if (typ == "Testator")
{
con.Open();
string qq12 = "select Type from users where uId = " + Convert.ToInt32(Session["uuid"]) + " and designation = 1 ";
SqlDataAdapter da42 = new SqlDataAdapter(qq12, con);
DataTable d4t2 = new DataTable();
da42.Fill(d4t2);
con.Close();
if (d4t2.Rows.Count > 0)
{
ViewBag.documentlink = "true";
}
// check will status
con.Open();
string qry1 = "select Will from users where Will = 1 ";
SqlDataAdapter daa1 = new SqlDataAdapter(qry1, con);
DataTable dtt1 = new DataTable();
daa1.Fill(dtt1);
if (dtt1.Rows.Count > 0)
{
ViewBag.documentbtn1 = "true";
}
con.Close();
//end
// check codocil status
con.Open();
string qry2 = "select Codocil from users where Codocil = 1 ";
SqlDataAdapter daa2 = new SqlDataAdapter(qry2, con);
DataTable dtt2 = new DataTable();
daa2.Fill(dtt2);
if (dtt2.Rows.Count > 0)
{
ViewBag.documentbtn2 = "true";
}
con.Close();
//end
// check Poa status
con.Open();
string qry4 = "select POA from users where POA = 1 ";
SqlDataAdapter daa4 = new SqlDataAdapter(qry4, con);
DataTable dtt4 = new DataTable();
daa4.Fill(dtt4);
if (dtt4.Rows.Count > 0)
{
ViewBag.documentbtn3 = "true";
}
con.Close();
//end
// check gift deeds status
con.Open();
string qry3 = "select Giftdeeds from users where Giftdeeds = 1 ";
SqlDataAdapter daa3 = new SqlDataAdapter(qry3, con);
DataTable dtt3 = new DataTable();
daa3.Fill(dtt3);
if (dtt3.Rows.Count > 0)
{
ViewBag.documentbtn4 = "true";
}
con.Close();
//end
}
else
{
ViewBag.showtitle = "true";
ViewBag.documentlink = "true";
}
if (Session["rId"] == null || Session["uuid"] == null)
{
RedirectToAction("LoginPageIndex", "LoginPage");
}
//if (Session["tid"]== null)
//{
// ViewBag.message = "link";
//}
List <LoginModel> Lmlist = new List <LoginModel>();
con.Open();
string q = "select * from Assignment_Roles where RoleId = " + Convert.ToInt32(Session["rId"]) + "";
SqlDataAdapter da3 = new SqlDataAdapter(q, con);
DataTable dt3 = new DataTable();
da3.Fill(dt3);
if (dt3.Rows.Count > 0)
{
for (int i = 0; i < dt3.Rows.Count; i++)
{
LoginModel lm = new LoginModel();
lm.PageName = dt3.Rows[i]["PageName"].ToString();
lm.PageStatus = dt3.Rows[i]["PageStatus"].ToString();
lm.Action = dt3.Rows[i]["Action"].ToString();
lm.Nav1 = dt3.Rows[i]["Nav1"].ToString();
lm.Nav2 = dt3.Rows[i]["Nav2"].ToString();
Lmlist.Add(lm);
}
ViewBag.PageName = Lmlist;
}
con.Close();
MainAssetsModel mam = new MainAssetsModel();
mam.aiid = NestId;
return(View("~/Views/UpdateMainAssets/UpdateMainAssetsPageContent.cshtml", mam));
}
public ActionResult InsertBeneficiaryAsset(FormCollection collection)
{
ViewBag.collapse = "true";
// check type
string typ = "";
con.Open();
string qq1 = "select Type from users where uId = " + Convert.ToInt32(Session["uuid"]) + " ";
SqlDataAdapter daa = new SqlDataAdapter(qq1, con);
DataTable dtt = new DataTable();
daa.Fill(dtt);
con.Close();
if (dtt.Rows.Count > 0)
{
typ = dtt.Rows[0]["Type"].ToString();
}
//end
if (typ == "Testator")
{
// check will status
con.Open();
string qry1 = "select Will from users where Will = 1 ";
SqlDataAdapter daa1 = new SqlDataAdapter(qry1, con);
DataTable dtt1 = new DataTable();
daa1.Fill(dtt1);
if (dtt1.Rows.Count > 0)
{
ViewBag.documentbtn1 = "true";
}
con.Close();
//end
// check codocil status
con.Open();
string qry2 = "select Codocil from users where Codocil = 1 ";
SqlDataAdapter daa2 = new SqlDataAdapter(qry2, con);
DataTable dtt2 = new DataTable();
daa2.Fill(dtt2);
if (dtt2.Rows.Count > 0)
{
ViewBag.documentbtn2 = "true";
}
con.Close();
//end
// check Poa status
con.Open();
string qry4 = "select POA from users where POA = 1 ";
SqlDataAdapter daa4 = new SqlDataAdapter(qry4, con);
DataTable dtt4 = new DataTable();
daa4.Fill(dtt4);
if (dtt4.Rows.Count > 0)
{
ViewBag.documentbtn3 = "true";
}
con.Close();
//end
// check gift deeds status
con.Open();
string qry3 = "select Giftdeeds from users where Giftdeeds = 1 ";
SqlDataAdapter daa3 = new SqlDataAdapter(qry3, con);
DataTable dtt3 = new DataTable();
daa3.Fill(dtt3);
if (dtt3.Rows.Count > 0)
{
ViewBag.documentbtn4 = "true";
}
con.Close();
//end
}
else
{
ViewBag.showtitle = "true";
ViewBag.documentlink = "true";
}
// roleassignment
List <LoginModel> Lmlist = new List <LoginModel>();
con.Open();
string q = "select * from Assignment_Roles where RoleId = " + Convert.ToInt32(Session["rId"]) + "";
SqlDataAdapter da3 = new SqlDataAdapter(q, con);
DataTable dt3 = new DataTable();
da3.Fill(dt3);
if (dt3.Rows.Count > 0)
{
for (int i = 0; i < dt3.Rows.Count; i++)
{
LoginModel lm = new LoginModel();
lm.PageName = dt3.Rows[i]["PageName"].ToString();
lm.PageStatus = dt3.Rows[i]["PageStatus"].ToString();
lm.Action = dt3.Rows[i]["Action"].ToString();
lm.Nav1 = dt3.Rows[i]["Nav1"].ToString();
lm.Nav2 = dt3.Rows[i]["Nav2"].ToString();
Lmlist.Add(lm);
}
ViewBag.PageName = Lmlist;
}
con.Close();
//end
int Beneficiaryid = 0;
int AssetId = 0;
int assetcatid = 0;
int checknumberofitems = 0;
int checkweight = 0;
string getcheckdata = TempData["checkdata"].ToString();
AssetMappingModel saveasset = new AssetMappingModel();
ArrayList cheknum = new ArrayList(TempData["calculate"].ToString().Split('~'));
for (int i = 0; i < cheknum.Count; i++)
{
checknumberofitems = Convert.ToInt32(cheknum[0]);
checkweight = Convert.ToInt32(cheknum[1]);
}
string value = Convert.ToString(collection["inputName"]);
string ddllist = collection["contentList"];
ArrayList result = new ArrayList(value.Split(','));
ArrayList dd = new ArrayList(ddllist.Split(','));
for (int i = 0; i < result.Count; i++)
{
saveasset.NumberofItems = Convert.ToInt32(result[0]);
saveasset.weight = Convert.ToInt32(result[1]);
}
for (int i = 0; i < dd.Count; i++)
{
Beneficiaryid = Convert.ToInt32(dd[0]);
AssetId = Convert.ToInt32(dd[1]);
assetcatid = Convert.ToInt32(dd[2]);
}
var radio1 = Convert.ToString(Request.Form["Currentradio"]);
var radio2 = Convert.ToString(Request.Form["ownershipRadio"]);
var radio3 = Convert.ToString(Request.Form["nominationradio"]);
if (saveasset.NumberofItems >= checknumberofitems && saveasset.weight >= checkweight)
{
Response.Write("<script>alert('Number of Item Left is " + checknumberofitems + " and Number of Weight Left is " + checkweight + " ')</script>");
}
else
{
// insert beneficiary asset
string insertbenefijson = JsonConvert.SerializeObject(saveasset, Newtonsoft.Json.Formatting.None,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore
});
con.Open();
string inserbeneficiaryasset = "insert into Beneficiary_AssetInfo (bpId,atId,amId,Json) values (" + Beneficiaryid + "," + AssetId + "," + assetcatid + ",'" + insertbenefijson + "')";
SqlCommand cmd = new SqlCommand(inserbeneficiaryasset, con);
cmd.ExecuteNonQuery();
con.Close();
//end
con.Open();
string query = "select * from AssetInformation where amId = " + TempData["amid"] + "";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
da.Fill(dt);
string data = "";
if (dt.Rows.Count > 0)
{
string getjson = dt.Rows[0]["Json"].ToString();
MainAssetsModel upobj = JsonConvert.DeserializeObject <MainAssetsModel>(getjson);
TempData["checkdata"] = getjson;
string getcolumn = "";
if (upobj.dueDate != null)
{
getcolumn = getcolumn + upobj.dueDate + "~";
}
if (upobj.IssuedBy != null)
{
upobj.IssuedBy = upobj.IssuedBy;
}
if (upobj.Location != null)
{
upobj.Location = upobj.Location;
}
if (upobj.Identifier != null)
{
upobj.Identifier = upobj.Identifier;
}
if (upobj.assetsValue != null)
{
upobj.assetsValue = upobj.assetsValue;
}
if (upobj.CertificateNumber != null)
{
upobj.CertificateNumber = upobj.CertificateNumber;
}
if (upobj.DescriptionTypeofItem != null)
{
upobj.DescriptionTypeofItem = upobj.DescriptionTypeofItem;
}
if (upobj.NumberofItems != null)
{
int cal = Convert.ToInt32(upobj.NumberofItems) - Convert.ToInt32(saveasset.NumberofItems);
upobj.NumberofItems = cal.ToString();
}
if (upobj.Weight != null)
{
int cal = Convert.ToInt32(upobj.Weight) - Convert.ToInt32(saveasset.weight);
upobj.Weight = cal.ToString();
}
if (upobj.Remark != null)
{
upobj.Remark = upobj.Remark;
}
if (upobj.RemarkControls != null)
{
upobj.RemarkControls = "";
}
if (upobj.NomineeDetails != null)
{
upobj.NomineeDetails = upobj.NomineeDetails;
}
if (upobj.NominationControls != null)
{
upobj.NominationControls = "";
}
if (upobj.Name != null)
{
upobj.Name = upobj.Name;
}
if (upobj.NameControls != null)
{
upobj.NameControls = "";
}
if (upobj.RegisteredAddress != null)
{
upobj.RegisteredAddress = upobj.RegisteredAddress;
}
if (upobj.RegisteredAddressControls != null)
{
upobj.RegisteredAddressControls = "";
}
if (upobj.PermanentAddress != null)
{
upobj.PermanentAddress = upobj.PermanentAddress;
}
if (upobj.PermanentAddressControls != null)
{
upobj.PermanentAddressControls = "";
}
if (upobj.Identity_proof != null)
{
upobj.Identity_proof = upobj.Identity_proof;
}
if (upobj.Identity_proofControls != null)
{
upobj.Identity_proofControls = "";
}
if (upobj.Identity_proof_value != null)
{
upobj.Identity_proof_value = upobj.Identity_proof_value;
}
if (upobj.Identity_proof_valueControls != null)
{
upobj.Identity_proof_valueControls = "";
}
if (upobj.Alt_Identity_proof != null)
{
upobj.Alt_Identity_proof = upobj.Alt_Identity_proof;
}
if (upobj.Alt_Identity_proofControls != null)
{
upobj.Alt_Identity_proofControls = "";
}
if (upobj.Alt_Identity_proof_value != null)
{
upobj.Alt_Identity_proof_value = upobj.Alt_Identity_proof_value;
}
if (upobj.Alt_Identity_proofControls != null)
{
upobj.Alt_Identity_proofControls = "";
}
if (upobj.Phone != null)
{
upobj.Phone = upobj.Phone;
}
if (upobj.PhoneControls != null)
{
upobj.PhoneControls = "";
}
if (upobj.Mobile != null)
{
upobj.Mobile = upobj.Mobile;
}
if (upobj.MobileControls != null)
{
upobj.MobileControls = "";
}
if (upobj.Amount != null)
{
upobj.Amount = upobj.Amount;
}
if (upobj.AmountControls != null)
{
upobj.AmountControls = "";
}
if (upobj.Address != null)
{
upobj.Address = "";
}
if (upobj.CTSNo != null)
{
upobj.CTSNo = "";
}
con.Close();
string upjson = JsonConvert.SerializeObject(upobj, Newtonsoft.Json.Formatting.None,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore
});
con.Open();
string updateassetinfo = "update AssetInformation set Json='" + upjson + "' where amId = " + TempData["amid"] + " ";
SqlCommand cm2 = new SqlCommand(updateassetinfo, con);
cm2.ExecuteNonQuery();
con.Close();
}
}
ModelState.Clear();
ViewBag.Message = "Verified";
return(View("~/Views/AddAssetMapping/AddAssetMappingPageContent.cshtml"));
}
