TicketList.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPages/Managers.Master" AutoEventWireup="true" CodeBehind="TicketList.aspx.cs" Inherits="UI.User.Manager.TicketList"EnableEventValidation="false" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div class="row">
<div class="col-xs-12">
<div class="panel panel-primary">
<div class="panel-heading">
<div class="panel-title">لیست تیکت های گذشته</div>
<div class="panel-options">
<a href="#" data-rel="collapse"><i class="entypo-down-open"></i></a>
<a href="#" data-rel="reload"><i class="entypo-arrows-ccw"></i></a>
</div>
<br style="clear: both;" />
<hr />
<div id="top-table" class="top-table">
<div class="table-search float-left">
<div>
<div style="width: 40px; float: right;">
<label for="field-1" class="col-sm-3 control-label">جستجو</label>
</div>
<div style="width: 300px; float: left;">
<input type="text" class="form-control" id="field-1" placeholder="متن مورد نظر خود را تایپ کنید">
</div>
</div>
</div>
<div class="table-print">
<div id="export-table" class="float-left padding-left">
<button type="button" class="btn btn-white">پرینت</button>
<button type="button" class="btn btn-white">اکسل</button>
</div>
</div>
</div>
<br style="clear: both;" class="margin-bottom" />
<hr />
</div>
<table class="table table-bordered datatable" id="table-2">
<thead>
<tr>
<th>شماره تیکت</th>
<th>وضعیت تیکت</th>
<th>الویت</th>
<th>موضوع</th>
</tr>
</thead>
<tbody>
<asp:Repeater ID="rptTicketList" runat="server">
<ItemTemplate>
<tr>
<td><%# Eval("Id") %></td>
<td>
<asp:Button ID="btnStatus" CommandArgument='<%# Eval("Id") %>' runat="server" Text='<%# (Convert.ToBoolean(Eval("IsClosed"))==true)?"بسته":"باز" %>' OnCommand="btnStatus_Command" CssClass="btn btn-sm" />
</td>
<th><%# (Convert.ToInt32(Eval("Levell"))==1)?"کم":(Convert.ToInt32(Eval("Levell"))==2)?"متوسط":"زیاد" %></td></th>
<td><a href="TicketDetail.aspx?tid=<%# Eval("Id") %>"><%# Eval("Subjects") %></a></td>
</tr>
</ItemTemplate>
</asp:Repeater>
</tbody>
</table>
</div>
</div>
</div>
<br />
<ul class="pagination">
<li><a href="#"><i class="entypo-left-open-mini"></i></a></li>
<li class="active"><a href="#">1</a></li>
<li><a href="#">2</a></li>
<li><a href="#">3</a></li>
<li><a href="#">4</a></li>
<li><a href="#">5</a></li>
<li><a href="#">6</a></li>
<li class="disabled"><a href="#"><i class="entypo-right-open-mini"></i></a></li>
</ul>
<br />
</asp:Content>
TicketList.aspx.cs
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace UI.User.Manager
{
public partial class TicketList : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = null;
SqlDataAdapter da = null;
DataTable dt = null;
// Authenticate
if (Session["UserId"] == null || Session["UserId"].ToString() == "")
{
Response.Redirect("/User/Guest/Login.aspx");
}
else
{
con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["con"].ConnectionString);
da = new SqlDataAdapter("select Id from users where BuildingId is null and Id = @Id", con);
da.SelectCommand.Parameters.AddWithValue("@Id", Convert.ToInt32(Session["UserId"]));
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
{
Response.Redirect("/User/Guest/Login.aspx");
}
}
//
//
con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["con"].ConnectionString);
da = new SqlDataAdapter("select Id from buildings where UserId = @UserId", con);
da.SelectCommand.Parameters.AddWithValue("@UserId", Convert.ToInt32(Session["UserId"]));
dt = new DataTable();
da.Fill(dt);
con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["con"].ConnectionString);
da = new SqlDataAdapter("select Subjects,Levell,IsClosed,Tickets.Id,Buildings.Titl e from tickets inner join Buildings on Tickets.BuildingId = Buildings.Id where BuildingId = @BuildingId", con);
da.SelectCommand.Parameters.AddWithValue("@BuildingId", dt.Rows[0]["Id"]);
dt = new DataTable();
da.Fill(dt);
rptTicketList.DataSource = dt;
rptTicketList.DataBind();
}
protected void btnStatus_Command(object sender, CommandEventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["con"].ConnectionString);
SqlCommand cmd = new SqlCommand("update Tickets set IsClosed = 1 where Id = @Id", con);
cmd.Parameters.AddWithValue("@Id", Convert.ToInt32(e.CommandArgument));
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Page_Load(null, null);
}
}
}