public MPRReportStatus GetMPRReportStatus(int Id)
        {
            MPRReportStatus ob = new MPRReportStatus();

            using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
            {
                var cmd = new System.Data.SqlClient.SqlCommand("", con);

                con.Open();
                cmd.CommandText = "SELECT * from MPRReportStatus where MPRReportStatusId=@ID";
                cmd.Parameters.AddWithValue("@ID", Id);
                //cmd.Parameters.AddWithValue("@TAKETOP", taketop);
                System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    ob.MPRReportStatusId = reader["MPRReportStatusId"] != DBNull.Value ? Int32.Parse(reader["MPRReportStatusId"].ToString()) : 0;
                    ob.Year   = reader["Year"] != DBNull.Value ? Int32.Parse(reader["Year"].ToString()) : 0;
                    ob.Period = reader["Period"] != DBNull.Value ? Convert.ToString(reader["Period"]) : "";
                    ob.Status = reader["Status"] != DBNull.Value ? Convert.ToString(reader["Status"]) : "";
                }
                con.Close();
            }
            return(ob);
        }
        public List <MPRReportStatus> GetAllMPRReportStatus()
        {
            List <MPRReportStatus> obuList = new List <MPRReportStatus>();

            using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
            {
                var cmd = new System.Data.SqlClient.SqlCommand("", con);

                con.Open();

                cmd.CommandText = "SELECT * from MPRReportStatus";

                System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    var ob = new MPRReportStatus();

                    ob.MPRReportStatusId = reader["MPRReportStatusId"] != DBNull.Value ? Int32.Parse(reader["MPRReportStatusId"].ToString()) : 0;
                    ob.Year   = reader["Year"] != DBNull.Value ? Int32.Parse(reader["Year"].ToString()) : 0;
                    ob.Period = reader["Period"] != DBNull.Value ? Convert.ToString(reader["Period"]) : "";
                    ob.Status = reader["Status"] != DBNull.Value ? Convert.ToString(reader["Status"]) : "";

                    obuList.Add(ob);
                }
                con.Close();
            }
            return(obuList);
        }
        //public void InsertVolumeAnalysisRundates(VolumeAnalysisRundatesModel vrd)
        //{
        //    using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
        //    {
        //        var cmd = new System.Data.SqlClient.SqlCommand("", con);

        //        con.Open();
        //        cmd.CommandText = "Insert into volume_analysis_rundates (date, visible) values(@DATE, @VISIBLE)";
        //        cmd.Parameters.AddWithValue("@DATE", vrd.date);
        //        cmd.Parameters.AddWithValue("@VISIBLE", vrd.visible);

        //        cmd.ExecuteNonQuery();
        //        con.Close();
        //    }
        //}

        public void UpdateMPRReportStatus(MPRReportStatus vrd)
        {
            using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
            {
                var cmd = new System.Data.SqlClient.SqlCommand("", con);

                con.Open();
                cmd.CommandText = "Update MPRReportStatus set Period=@PERIOD, Status = @STATUS  where MPRReportStatusId=@ID";
                cmd.Parameters.AddWithValue("@ID", vrd.MPRReportStatusId);
                cmd.Parameters.AddWithValue("@PERIOD", vrd.Period);
                cmd.Parameters.AddWithValue("@STATUS", vrd.Status);

                cmd.ExecuteNonQuery();
                con.Close();
            }
        }
Beispiel #4
0
        //[Route("teamstructurebyselection/{selectedcode}/{selectedyear}/{selectedlevel}")]
        public HttpResponseMessage MPRReportStatus(HttpRequestMessage request)
        {
            HttpResponseMessage res = null;

            MPRReportStatusModel rStatus  = new MPRReportStatusModel();
            MPRReportStatus      rStatus2 = entityContext.MPRReportStatusSet.FirstOrDefault();

            rStatus.Year            = rStatus2.Year;
            rStatus.Period          = rStatus2.Period;
            rStatus.ReportStatus    = rStatus2.Status.ToUpper().Trim();
            rStatus.loggedinmiscode = Convert.ToString((System.Web.HttpContext.Current.Session["ProfitCenterMisCode"]));
            rStatus.loggedindefcode = Convert.ToString((System.Web.HttpContext.Current.Session["ProfitCenterDefinitionCode"]));

            res = request.CreateResponse(HttpStatusCode.OK, rStatus);

            return(res);
        }
Beispiel #5
0
        public HttpResponseMessage UpdateMPRReportStatus(HttpRequestMessage request, [FromBody] MPRReportStatus mprreportstatusModel)
        {
            return(GetHttpResponse(request, () =>
            {
                MPRReportStatus mprreportstatus = null;

                if (clientcode == "ABP")
                {
                    MPRReportStatusMtd ob = new MPRReportStatusMtd();
                    ob.UpdateMPRReportStatus(mprreportstatusModel);
                }
                else
                {
                    mprreportstatus = _MPRCoreService.UpdateMPRReportStatus(mprreportstatusModel);
                }

                //return request.CreateResponse<MPRReportStatus>(HttpStatusCode.OK, mprreportstatus);
                return request.CreateResponse(HttpStatusCode.OK);
            }));
        }
Beispiel #6
0
        public HttpResponseMessage GetMPRReportStatus(HttpRequestMessage request, int MPRReportStatusId)
        {
            return(GetHttpResponse(request, () =>
            {
                HttpResponseMessage response = null;

                MPRReportStatus mprreportstatus = null;

                if (clientcode == "ABP")
                {
                    MPRReportStatusMtd ob = new MPRReportStatusMtd();
                    mprreportstatus = ob.GetMPRReportStatus(MPRReportStatusId);
                }
                else
                {
                    mprreportstatus = _MPRCoreService.GetMPRReportStatus(MPRReportStatusId);
                }
                // notice no need to create a seperate model object since CaptionMapping entity will do just fine
                response = request.CreateResponse <MPRReportStatus>(HttpStatusCode.OK, mprreportstatus);

                return response;
            }));
        }
        protected void Page_Load(object sender, EventArgs e)
        //public void Pag(string pat, string typ, string cur )
        {
            try
            {
                if (!IsPostBack)
                {
                    MPR.Report.Data.Business.MPRContext2 entityContext = new MPR.Report.Data.Business.MPRContext2();

                    string query = "SELECT * FROM MPRReportStatus";

                    MPRReportStatus MPRReportStatusObj = entityContext.Database.SqlQuery <MPRReportStatus>(query).FirstOrDefault();

                    string Period = Request.QueryString["period"].ToString();

                    //string currentPeriod = Convert.ToString((System.Web.HttpContext.Current.Session["currentperiod"]));
                    //string rStatusPeriod = MPRReportStatusObj.Period.ToString().Trim();
                    //string[] rStatusPeriod = MPRReportStatusObj.Period.ToString().Trim().Split(',');
                    List <string> rStatusPeriod = MPRReportStatusObj.Period.ToString().Trim().Split(',').ToList();

                    string Year = Request.QueryString["year"].ToString();
                    //string currentYear = Convert.ToString((System.Web.HttpContext.Current.Session["latestyear"]));
                    string rStatusYear = MPRReportStatusObj.Year.ToString().Trim();

                    //string currentstatus = Request.QueryString["currentstatus"].ToString();
                    string rStatus = MPRReportStatusObj.Status.ToUpper().Trim();

                    //string loggedinusermiscode = Convert.ToString((System.Web.HttpContext.Current.Session["ProfitCenterMisCode"]));
                    //loggedinusermiscode = loggedinusermiscode.ToUpper();
                    string loggedinuserdefcode = Convert.ToString((System.Web.HttpContext.Current.Session["ProfitCenterDefinitionCode"]));
                    loggedinuserdefcode = loggedinuserdefcode.ToUpper().Trim();

                    string unlockreportfor = ConfigurationManager.AppSettings["UnLockReportFor"];
                    unlockreportfor = unlockreportfor.ToUpper();


                    //if (currentPeriod == Period && currentYear == Year && currentstatus.ToUpper() == "OFF" && !unlockreportfor.Contains(loggedinuserdefcode))
                    //if (rStatusPeriod == Period && rStatusYear == Year && rStatus == "OFF" && !unlockreportfor.Contains(loggedinuserdefcode))
                    if ((rStatusPeriod.IndexOf(Period) != -1) && rStatusYear == Year && rStatus == "OFF" && !unlockreportfor.Contains(loggedinuserdefcode))
                    {
                        reportViewer004.ShowReportBody = false;
                    }


                    else
                    {
                        string reportId = Request.QueryString["id"].ToString();
                        string Currency = Request.QueryString["currency"].ToString();
                        string Path     = Request.QueryString["path"].ToString();
                        string Type     = Request.QueryString["type"].ToString();

                        //string MisCode = "totalbank";

                        string Level = Convert.ToString(System.Web.HttpContext.Current.Session["session_level"]);
                        string currentlyselectedlevel = Convert.ToString(System.Web.HttpContext.Current.Session["session_currentlyselectedlevel"]);

                        string MisCode = Convert.ToString(System.Web.HttpContext.Current.Session["session_miscode"]);
                        string currentlyselectedmiscode = Convert.ToString(System.Web.HttpContext.Current.Session["session_currentlyselectedmiscode"]);

                        //if (!string.IsNullOrEmpty(Convert.ToString(currentlyselectedmiscode)))
                        if (!string.IsNullOrEmpty(Convert.ToString(currentlyselectedmiscode)) || currentlyselectedmiscode.ToLower() != "")
                        {
                            MisCode = "";
                            MisCode = currentlyselectedmiscode;
                            Level   = currentlyselectedlevel;
                        }

                        string reportServerUrl = ConfigurationManager.AppSettings["ReportServerURL"];
                        string domain          = ConfigurationManager.AppSettings["rsDomain"];
                        string userName        = ConfigurationManager.AppSettings["rsUserName"];
                        string password        = ConfigurationManager.AppSettings["rsPassword"];
                        string reportPath      = ConfigurationManager.AppSettings["ReportPath"];


                        reportViewer004.ServerReport.ReportServerUrl         = new Uri(reportServerUrl);
                        reportViewer004.ServerReport.ReportServerCredentials = new ReportCredentials(userName, password, domain);
                        reportViewer004.ServerReport.ReportPath = string.Format(reportPath, reportId);
                        // reportViewer004.ServerReport.ReportPath = string.Format(reportPath, "Balancesheet");
                        reportViewer004.ProcessingMode        = ProcessingMode.Remote;
                        reportViewer004.ShowCredentialPrompts = false;


                        ReportParameter[] reportParameter = new ReportParameter[7];
                        reportParameter[0] = new ReportParameter("MisCode", MisCode);
                        reportParameter[1] = new ReportParameter("Period", Period);
                        reportParameter[2] = new ReportParameter("Year", Year);
                        reportParameter[3] = new ReportParameter("Level", Level);
                        reportParameter[4] = new ReportParameter("Path", Path);
                        reportParameter[5] = new ReportParameter("Type", Type);
                        reportParameter[6] = new ReportParameter("Currency", Currency);

                        //ReportParameter[] reportParameter = new ReportParameter[7];
                        //reportParameter[0] = new ReportParameter("MisCode", "bnk");
                        //reportParameter[1] = new ReportParameter("Period", "8");
                        //reportParameter[2] = new ReportParameter("Year", "2019");
                        //reportParameter[3] = new ReportParameter("Level", "0");
                        //reportParameter[4] = new ReportParameter("Path", "");
                        //reportParameter[5] = new ReportParameter("Type", "BS");
                        //reportParameter[6] = new ReportParameter("Currency", "naira");

                        //reportParameter[8] = new ReportParameter("NRFF", NRFF);

                        //==== NOTE: for report on server, use the below ============
                        reportViewer004.ServerReport.SetParameters(reportParameter);

                        reportViewer004.ServerReport.Refresh();

                        ////==== NOTE: for report on local machine, use the below ============
                        //reportViewer.LocalReport.SetParameters(reportParameter);
                        //reportViewer.LocalReport.Refresh();
                    } //end of else
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }