public JsonResult SaveDeclaration(int IsCheck, string Remark, string SocietyTransID) { int i = 0; bool IsChecked = false; string IPAddress = GetIPAddress(); string BrowserName = GetWebBrowserName(); if (IsCheck == 1) { IsChecked = true; } if (IsCheck == 0) { IsChecked = false; } SaveDeclaration savedeclaration = new SaveDeclaration { UserId = Convert.ToInt32(Session["UserId"]), IPAddress = IPAddress, BrowserName = BrowserName, Ischeck = IsChecked, Remark = Remark, SocietyTransID = SocietyTransID, }; i = objARCSD.SaveDeclaration(savedeclaration); if (i >= 1) { return(Json(i.ToString(), JsonRequestBehavior.AllowGet)); } return(Json("Something went wrong", JsonRequestBehavior.AllowGet)); }
public int SaveDeclaration(SaveDeclaration _savedeclaration) { int i; connection.Open(); using (SqlConnection con = new SqlConnection(ConStr)) { con.Open(); SqlCommand cmd = new SqlCommand("[dbo].[Blog_SaveDeclaration]", connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@SocietyTransID", _savedeclaration.SocietyTransID); cmd.Parameters.AddWithValue("@UserId", _savedeclaration.UserId); cmd.Parameters.AddWithValue("@Ischeck", _savedeclaration.Ischeck); cmd.Parameters.AddWithValue("@Remark", _savedeclaration.Remark); cmd.Parameters.AddWithValue("@IPAddress", _savedeclaration.IPAddress); cmd.Parameters.AddWithValue("@BrowserName", _savedeclaration.BrowserName); i = cmd.ExecuteNonQuery(); } connection.Close(); return(i); }
public ActionResult BackLogMemberDetail(FormCollection fc) { try { int result = 0; List <SelectListItem> lstSL = new List <SelectListItem>(); List <SelectListItem> lstI = new List <SelectListItem>(); ARCSData objARCSD = new ARCSData(); InspectorData objID = new InspectorData(); ForwardToIncepector objFTI = new ForwardToIncepector(); if (Convert.ToInt32(Session["RoleId"]) == 3) { string IPAddress = GetIPAddress(); string Browser = GetWebBrowserName(); ForwardToARCSOfficers objFTAO = new ForwardToARCSOfficers { IncepectorCode = Convert.ToInt32(Session["InsceptorCode"]), SocietyTransId = Convert.ToString(Session["SocietyTransID"]), Remarks = fc.Get("ARCSRemarks").ToString() }; if (Convert.ToInt16(Session["InspectorCount"]) >= 1) { Boolean IsCheck = Convert.ToBoolean(fc.Get("Insprctorchk1")); SaveDeclaration savedeclaration = new SaveDeclaration { UserId = Convert.ToInt32(Session["UserId"]), IPAddress = IPAddress, BrowserName = Browser, Ischeck = IsCheck, Remark = objFTAO.Remarks, SocietyTransID = objFTAO.SocietyTransId, }; objARCSD.SaveDeclaration(savedeclaration); } result = objID.BackLogForwardToARCS(objFTAO); if (result >= 1) { if (Convert.ToInt32(Session["InspectorCount"]) > 1) { ViewBag.InspectorChange = "Yes"; } ViewBag.show = "BackLog Application successfully forwarded to ARCS Officer"; ViewBag.result = "1"; ViewBag.tabResult = "1"; } else { ViewBag.show = "BackLog Application not successfully forwarded to ARCS Officer"; ViewBag.result = "0"; ViewBag.tabResult = "0"; } lstSL = GetSocietyList(); ViewBag.lstSL = lstSL; } if (Convert.ToInt32(Session["RoleId"]) == 2) { if (string.IsNullOrEmpty(fc.Get("IncepectorList"))) { ViewBag.show = "Kindly Select Inspector"; ViewBag.result = "0"; ViewBag.tabResult = "5"; return(View()); } if (string.IsNullOrEmpty(fc.Get("ARCSRemarks"))) { ViewBag.show = "fill your remarks"; ViewBag.result = "0"; ViewBag.tabResult = "5"; return(View()); } objFTI.OfficerCode = Convert.ToInt32(fc.Get("IncepectorList")); var SocietyTransID = Convert.ToString(Session["SocietyTransID"]); Session["SocietyTransID"] = SocietyTransID; objFTI.SocietyTransId = Convert.ToString(Session["SocietyTransID"]); objFTI.Remarks = fc.Get("ARCSRemarks").ToString(); result = objARCSD.BackLogForwardToIncepector(objFTI); if (result >= 1) { ViewBag.show = "Application successfully forwarded to incepector"; ViewBag.result = "1"; ViewBag.tabResult = "1"; } else { ViewBag.show = "Application not successfully forwarded to incepector"; ViewBag.result = "0"; ViewBag.tabResult = "0"; } lstSL = GetSocietyList(); ViewBag.lstSL = lstSL; lstI = GetInspectorSocietyList(); ViewBag.BcklstI = lstI; } lstGD = GetDistrict(); ViewBag.District = lstGD; lstR = GetRelationship(); ViewBag.Relationship = lstR; lstMember = GetAllShareTransferMember(); ViewBag.MemberDetail = lstMember; lstMCDCM = GetMemberCommDesignation(); ViewBag.MemberCommDesignation = lstMCDCM; lstARCSCode = GetsubClassSocieties(); ViewBag.lstARCSCode = lstARCSCode; CommunityofSociety = GetCommunityofSociety(); ViewBag.CommunityofSociety = CommunityofSociety; lstSL = GetSocietyList(); ViewBag.lstSL = lstSL; Inspkl = GetInspectorSocietyList(); ViewBag.Inspkl = Inspkl; lstI = GetInspectorList(); ViewBag.lstI = lstI; } catch (Exception ex) { return(RedirectToAction("Error", "Unauthorised")); throw ex; } return(View()); }