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));
}
