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