private System.Data.DataTable GetList(bool ispageModel, out int rowCount) { rowCount = 0; SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.TicketsForReport, OrderBy, true); request.Keyword = txtKeyword.Text; if (ispageModel) { request.CurrentPage = CurrentPageIndex; request.PageCount = ReportPage.PageSize; } else { request.CurrentPage = 1; request.PageCount = int.MaxValue; } request.ProjectID = int.Parse(ddlProject.SelectedValue); request.TicketIDS = ddlTickets.SelectedValue.ToString(); request.SearchTicketID = true; request.StartDate = StartDate; request.EndDate = EndDate; request.TicketType = ddlType.SelectedItem.Value; request.OrderBy = OrderBy; request.OrderDirection = OrderDirection; System.Data.DataTable response = tApp.ReortTicketRating(request, out rowCount); return(response); }
private void InitControl() { SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.TicketsForReport, OrderBy, true); request.Keyword = txtKeyword.Text; request.CurrentPage = CurrentPageIndex; request.PageCount = ReportPage.PageSize; request.ProjectID = int.Parse(ddlProject.SelectedValue); request.TicketIDS = ddlTickets.SelectedValue.ToString(); request.UserID = int.Parse(ddlUsers.SelectedValue); request.SearchTicketID = true; request.StartDate = StartDate; request.EndDate = EndDate; request.TicketType = ddlType.SelectedItem.Value; if (ddlStars.SelectedValue != "") { request.Star = int.Parse(ddlStars.SelectedValue); } else { request.Star = -1; } request.Source = Convert.ToInt32(ddlSource.SelectedValue); int rowCount = 0; var response = tApp.SearchReortTickets(request, out rowCount); rptReportList.DataSource = response; rptReportList.DataBind(); ReportPage.RecordCount = rowCount; }
private SearchTicketsResponse GetResponse(bool isPageModel, string projectID) { SearchTicketsRequest request = new SearchTicketsRequest( SearchTicketsType.TicketsForReport, string.Format(" {0} {1} ", hidOrderBy.Value, hidOrderDirection.Value), isPageModel); request.CurrentPage = anpTicketReport.CurrentPageIndex; request.PageCount = anpTicketReport.PageSize; request.Keyword = txtKeywords.Text.Trim().NoHTML(); if (UserInfo.Role == RolesEnum.CLIENT) { request.CompanyID = UserInfo.CompanyID; request.UserID = UserInfo.UserID; } else { request.CompanyID = 0; } if (int.Parse(ddlStatus.SelectedValue) == (int)ClientTicketState.Waiting_Feedback) { request.SearchTicketID = true; request.TicketIDS = fbmHandler.FeedBackRequiredTicketIDs; } request.TicketType = ddlTicketType.SelectedItem.Text.Trim(); request.ProjectID = int.Parse(projectID); request.Status = fbmHandler.GetSearchTicketStatuses(int.Parse(ddlStatus.SelectedValue)); SearchTicketsResponse response = tickApp.SearchTickets(request); return(response); }
private void InitControl() { CateGoryEntity model = CurrentModel; if (model == null || model.IsDelete == true) { Response.Redirect(ErrorPageUrl); } SetControlsStatus(model); SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.CateGory, " OrderNum ASC ,Priority DESC,TicketTitle ASC ", false); request.OrderBy = string.Format("{0} {1}", OrderBy, OrderDirection); request.SheetDate = request.SheetDate = ObjectFactory.GetInstance <ISystemDateTime>().Now.Date; request.CateGoryID = model.GID; request.CurrentPage = CurrentPageIndex; SearchTicketsResponse response = tickApp.SearchTickets(request); if (response.ResultList != null && response.ResultList.Count > 0) { rptTicketsList.DataSource = response.ResultList; rptTicketsList.DataBind(); trNoTickets.Visible = false; } else { trNoTickets.Visible = true; rptTicketsList.Visible = false; } }
private int GetTicketReportCount() { SearchTicketsRequest request = new SearchTicketsRequest( SearchTicketsType.TicketsForReport, string.Format(" {0} {1} ", "ModifiedOn", "desc"), true); request.CurrentPage = 1; request.PageCount = 0; if (UserInfo.Role == RolesEnum.CLIENT) { request.CompanyID = UserInfo.CompanyID; request.UserID = UserInfo.UserID; } else { request.CompanyID = 0; } request.TicketType = "ALL"; request.Status = fbmHandler.GetSearchTicketStatuses(-1); request.Keyword = string.Empty; SearchTicketsResponse response = ticketAPP.SearchTickets(request); return(response.ResultCount); }
private SearchTicketsResponse GetResponse(bool isPageModel) { SearchTicketsRequest request = new SearchTicketsRequest( SearchTicketsType.TicketsForReport, string.Format(" {0} {1} ", OrderBy, OrderDirection), isPageModel); request.CurrentPage = CurrentPageIndex; request.PageCount = anpReport.PageSize; request.Keyword = txtKeyWord.Text.Trim().NoHTML(); if (UserInfo.Role == RolesEnum.CLIENT) { request.CompanyID = UserInfo.CompanyID; request.UserID = UserInfo.UserID; } else { request.CompanyID = 0; } request.TicketType = ddlTicketType.SelectedItem.Text.Trim(); request.ProjectID = int.Parse(ddlProject.SelectedValue); request.Status = fbmHandler.GetSearchTicketStatuses(int.Parse(ddlStatus.SelectedValue)); SearchTicketsResponse response = ticketAPP.SearchTickets(request); return(response); }
protected void iBtnDownload_Click(object sender, EventArgs e) { SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.TicketsForReport, OrderBy, true); request.Keyword = txtKeyword.Text; request.CurrentPage = 1; request.PageCount = int.MaxValue; request.ProjectID = int.Parse(ddlProject.SelectedValue); request.TicketIDS = ddlTickets.SelectedValue.ToString(); request.TicketType = ddlType.SelectedValue; request.SearchTicketID = true; request.StartDate = StartDate; request.EndDate = EndDate; request.UserID = int.Parse(ddlUsers.SelectedValue); request.Source = Convert.ToInt32(ddlSource.SelectedValue); int rowCount = 0; System.Data.DataTable table = tApp.SearchReortTickets(request, out rowCount); ExcelReport report = new ExcelReport(); if (QS("star", "") != "") { report.AnalysisExport(table, "Ticket Rating"); } else { report.AnalysisExport(table, "Ticket Analysis"); } }
private void InitControl() { int category = QS("id", 0); if (category == 0) { ShowArgumentErrorMessageToClient(); return; } CateGoryEntity model = cgApp.GetCateGory(category); if (model == null || model.IsDelete == true) { ShowArgumentErrorMessageToClient(); Response.Redirect("/error.html?sourceurl=" + Request.Url.ToString()); } SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.CateGory, " OrderNum ASC ,Priority DESC,TicketTitle ASC ", true); request.SheetDate = request.SheetDate = ObjectFactory.GetInstance <ISystemDateTime>().Now.Date; request.CateGoryID = category; request.CurrentPage = anpTickets.CurrentPageIndex; SearchTicketsResponse response = tickApp.SearchTickets(request); rptTickets.DataSource = response.ResultList; rptTickets.DataBind(); anpTickets.RecordCount = response.ResultCount; }
public SearchTicketsResponse SearchTickets(SearchTicketsRequest request) { this.ClearBrokenRuleMessages(); SearchTicketsResponse response = ticketRepository.SearchTickets(request); if (response.IsError) { this.AddBrokenRuleMessage(); } return(response); }
private void BindTickets() { if (ddlProject.SelectedValue == "0") { ddlTickets.Items.Add(new ListItem("All", "0")); } else { TicketsApplication tickApp = new TicketsApplication(); SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.TicketsListByPID, " TicketTitle Asc", false); request.ProjectID = int.Parse(ddlProject.SelectedValue); SearchTicketsResponse response = tickApp.SearchTickets(request); response.ResultList.BindDropdown <ExpandTicketsEntity>(ddlTickets, "Title", "ID", "All", "0"); } }
protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e) { ddlTickets.Items.Clear(); if (ddlProject.SelectedValue == "0") { ddlTickets.Items.Add(new ListItem("All", "0")); } else { TicketsApplication tickApp = new TicketsApplication(); SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.TicketsListByPID, " TicketTitle Asc", false); request.ProjectID = int.Parse(ddlProject.SelectedValue); SearchTicketsResponse response = tickApp.SearchTickets(request); response.ResultList.BindDropdown <ExpandTicketsEntity>(ddlTickets, "Title", "ID", "All", "0"); } }
private SearchTicketsResponse GetTicketsByProject(int projID, DateTime sheetDate) { SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.TicketsForTimesheets, "TicketTitle ASC ", false); request.SheetDate = sheetDate; request.UserID = IdentityContext.UserID; request.ProjectID = projID; request.OrderBy = "TicketID"; List <TicketsState> listStatus = TicketsStateHelper.TimeSheetStates; request.Status = listStatus; TicketsApplication tickApp = new TicketsApplication(); SearchTicketsResponse response = tickApp.SearchTickets(request); return(response); }
protected void iBtnDownload_Click(object sender, EventArgs e) { SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.TicketsForReport, OrderBy, true); request.Keyword = txtKeyword.Text; request.CurrentPage = 1; request.PageCount = int.MaxValue; request.ProjectID = int.Parse(ddlProject.SelectedValue); request.TicketType = "-1"; request.SearchTicketID = false; request.StartDate = StartDate; request.EndDate = EndDate; request.Source = Convert.ToInt32(ddlSource.SelectedValue); int rowCount = 0; DataTable table = tApp.SearchReortTickets(request, out rowCount); ExcelReport report = new ExcelReport(); report.AnalysisExport(table, "Ticket Analysis"); }
private void InitControls() { if (ddlProjects.SelectedValue == "0") { trNoTickets.Visible = true; } else { int projectID = 0; if (int.TryParse(ddlProjects.SelectedValue, out projectID) && projectID > 0) { SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.Priority, " OrderNum ASC ,Priority DESC,TicketTitle ASC ", false); request.SheetDate = ObjectFactory.GetInstance <ISystemDateTime>().Now.Date; request.ProjectID = projectID; SearchTicketsResponse response = ticketApp.SearchTickets(request); if (response.ResultList == null || response.ResultList.Count <= 0) { rptTickets.Visible = false; trNoTickets.Visible = true; } else { rptTickets.Visible = true; rptTickets.DataSource = response.ResultList; rptTickets.DataBind(); trNoTickets.Visible = false; } } else { rptTickets.Visible = false; trNoTickets.Visible = true; } } }
private string GetTicketsByProject(int projID, DateTime sheetDate) { SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.TicketsForTimesheets, "TicketTitle ASC ", false); request.SheetDate = sheetDate; request.UserID = IdentityContext.UserID; request.ProjectID = projID; List <TicketsState> listStatus = TicketsStateHelper.TimeSheetStates; request.Status = listStatus; TicketsApplication tickApp = new TicketsApplication(); SearchTicketsResponse response = tickApp.SearchTickets(request); if (!response.IsError) { string json = UtilFactory.Helpers.JSONHelper.GetJson <List <ExpandTicketsEntity> >(response.ResultList); return(json); } else { return("[]"); } }
System.Data.IDataReader ITicketsRepository.SearchScheduleTickets(SearchTicketsRequest request) { throw new NotImplementedException(); }
public int SearchScheduleTicketsCount(SearchTicketsRequest request) { throw new NotImplementedException(); }
public System.Data.DataTable SearchScheduleTickets(SearchTicketsRequest request) { throw new NotImplementedException(); }
SearchTicketsResponse ITicketsRepository.SearchTickets(SearchTicketsRequest request) { throw new NotImplementedException(); }
public SearchTicketsResponse SearchTickets(SearchTicketsRequest request) { throw new NotImplementedException(); }
public DataTable ReortTicketRating(SearchTicketsRequest request, out int totalRows) { return(ticketRepository.ReortTicketRating(request, out totalRows)); }