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