-
Notifications
You must be signed in to change notification settings - Fork 6
/
Copy pathSelect_Sitting.aspx.cs
124 lines (119 loc) · 4.73 KB
/
Select_Sitting.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Select_Sitting : System.Web.UI.Page
{
databaseaccesslayer dataObj = new databaseaccesslayer();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
string sql1 = @"select * from Application_Setting where User_Id=" + Session["Id"] + " and Appl_Id=14 and IsVaild=1";
DataTable dt1 = dataObj.Selectdatatable(sql1);
if (dt1.Rows.Count != 1)
{
Response.Redirect("MainPage.aspx");
}
drpIssueNumber.DataSource = dataObj.Selectdatatable("select Id,IssueNumber from Ta_Issue where IssaueStatus=1");
drpIssueNumber.DataTextField = "IssueNumber";
drpIssueNumber.DataValueField = "Id";
drpIssueNumber.DataBind();
drpIssueNumber.Items.Insert(0, "أختار رقم القضية");
addValidationGroup();
}
catch (Exception)
{
Response.Redirect("MainPage.aspx");
}
}
}
private void addValidationGroup()
{
foreach (Control ctrl in UpdatePanel1.Controls[0].Controls)
{
TextBox txtbx = ctrl as TextBox;
if (txtbx != null)
{
txtbx.Attributes["ValidationGroup"] = txtbx.ValidationGroup;
}
DropDownList drp = ctrl as DropDownList;
if (drp != null)
{
drp.Attributes["ValidationGroup"] = drp.ValidationGroup;
}
}
}
private void BindgrdTrades()
{
try
{
if (drpIssueNumber.SelectedIndex>0&&txtDateFrom.Text.Trim() != "" && txtDateTo.Text.Trim() != "")
{
gridSelect.DataSource = dataObj.Selectdatatable("select IssueNumber as رقم_القضية,HakamName as القاضي,SittingTime as الميعاد,SittingDate as التاريخ,s.Notes as ملاحظات from Ta_Sitting s left join Ta_Issue i on s.Issue_Id=i.Id where Type=1 and s.Issue_Id="+drpIssueNumber.SelectedItem.Value+" and SittingDate between '" + DateTime.Parse(txtDateFrom.Text).ToShortDateString() + "' and '" + DateTime.Parse(txtDateTo.Text).ToShortDateString() + "' order by i.Id desc");
gridSelect.DataBind();
}
else if(drpIssueNumber.SelectedIndex>0)
{
gridSelect.DataSource = dataObj.Selectdatatable("select IssueNumber as رقم_القضية,HakamName as القاضي,SittingTime as الميعاد,SittingDate as التاريخ,s.Notes as ملاحظات from Ta_Sitting s left join Ta_Issue i on s.Issue_Id=i.Id where Type=1 and s.Issue_Id="+drpIssueNumber.SelectedItem.Value+" order by i.Id desc");
gridSelect.DataBind();
}
else
{
gridSelect.DataSource = null;
gridSelect.DataBind();
}
}
catch (Exception ex)
{
dataObj.Alert(ex.Message, this);
}
}
protected void drpGovernate_TextChanged(object sender, EventArgs e)
{
BindgrdTrades();
}
protected void gridSelect_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
GridViewRow row = gridSelect.SelectedRow;
string sql = @"select * from Ta_Sitting where Issue_Id=" + drpIssueNumber.SelectedItem.Value + " and SittingDate='" + DateTime.Parse(row.Cells[4].Text).ToShortDateString() + "'";
DataTable dt = dataObj.Selectdatatable(sql);
if (dt.Rows.Count == 1)
{
Response.Redirect("Update_Sitting.aspx?Id=" + dt.Rows[0]["Id"].ToString());
}
}
catch (Exception ex)
{
dataObj.Alert(ex.Message, this);
}
}
protected void gridSelect_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gridSelect.PageIndex = e.NewPageIndex;
BindgrdTrades();
}
protected void txtDateFrom_TextChanged(object sender, EventArgs e)
{
BindgrdTrades();
}
protected void txtDateTo_TextChanged(object sender, EventArgs e)
{
BindgrdTrades();
}
protected void drpIssueNumber_SelectedIndexChanged(object sender, EventArgs e)
{
BindgrdTrades();
}
protected void btnReport_Click(object sender, EventArgs e)
{
Response.Redirect("ReportSeetings.aspx?Id=" + drpIssueNumber.SelectedValue);
}
}