コード例 #1
0
        public ActionResult BackLogPendingAction(FormCollection fc)
        {
            List <SelectListItem> lstSL     = new List <SelectListItem>();
            List <SelectListItem> lstI      = new List <SelectListItem>();
            List <SelectListItem> ttlfreeze = new List <SelectListItem>();
            ForwardToIncepector   objFTI    = new ForwardToIncepector();

            if (string.IsNullOrEmpty(fc.Get("ARCSRemarks")))
            {
                ViewBag.show      = "fill your remarks";
                ViewBag.result    = "0";
                ViewBag.tabResult = "5";
                return(View());
            }
            objFTI.Status         = 12;
            objFTI.OfficerCode    = Convert.ToInt32(Session["ARCSCode"]);
            objFTI.SocietyTransId = Convert.ToString(Session["SocietyTransID"]);
            objFTI.Remarks        = fc.Get("ARCSRemarks").ToString();
            int result = objARCSD.BackLogOfficerHearingAndApprovalStatus(objFTI);

            if (result >= 1)
            {
                ViewBag.show      = "Application has been Freezed";
                ViewBag.result    = "1";
                ViewBag.tabResult = "1";
            }
            else
            {
                ViewBag.show      = "Sorry Application isn't Freezed yet.";
                ViewBag.result    = "0";
                ViewBag.tabResult = "0";
            }
            lstSL1                        = GetSocietyListForApproval();
            ViewBag.lstSL1                = lstSL1;
            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;
            return(View());
        }
コード例 #2
0
ファイル: ARCSData.cs プロジェクト: thatvish/RCSHaryana-1
        public int BackLogForwardToIncepector(ForwardToIncepector objFTI)
        {
            int i;

            using (SqlConnection con = new SqlConnection(ConStr))
            {
                con.Open();
                SqlCommand com = new SqlCommand("[dbo].[Blog_ForwardToInspector]", con)
                {
                    CommandType = CommandType.StoredProcedure
                };
                com.Parameters.AddWithValue("@OfficerCode", objFTI.OfficerCode);
                com.Parameters.AddWithValue("@Remarks", objFTI.Remarks);
                com.Parameters.AddWithValue("@SocietyTransId", objFTI.SocietyTransId);
                com.Parameters.AddWithValue("@Role", 3);
                i = com.ExecuteNonQuery();
            }
            return(i);
        }
コード例 #3
0
ファイル: ARCSData.cs プロジェクト: thatvish/RCSHaryana-1
        public int OfficerHearingAndApprovalStatus(ForwardToIncepector objFTI)
        {
            int i;

            using (SqlConnection con = new SqlConnection(ConStr))
            {
                con.Open();
                SqlCommand com = new SqlCommand("[dbo].[OfficerHearingAndApprovalStatus]", con)
                {
                    CommandType = CommandType.StoredProcedure
                };
                com.Parameters.AddWithValue("@OfficerCode", objFTI.OfficerCode);
                com.Parameters.AddWithValue("@Remarks", objFTI.Remarks);
                com.Parameters.AddWithValue("@SocietyTransId", objFTI.SocietyTransId);
                com.Parameters.AddWithValue("@HearingDate", objFTI.HearingDate);
                com.Parameters.AddWithValue("@Status", objFTI.Status);
                com.Parameters.AddWithValue("@Role", 3);
                i = com.ExecuteNonQuery();
            }
            return(i);
        }
コード例 #4
0
        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());
        }