protected void grdRequest_ItemCommand(object sender, GridCommandEventArgs e)
{
try
{
if (e.CommandName == "Select")
{
GridDataItem dataitem = e.Item as GridDataItem;
DataTable dd = Main.SelectJobFromRegister("CASE4", dataitem["REQUEST_ID"].Text, "", "", System.DateTime.Now);
grdRequest.DataSource = dd;
grdRequest.DataBind();
DataTable dtEvents = Main.SelectJobFromRegister("CASE16", dataitem["REQUEST_ID"].Text, "", "", System.DateTime.Now);
GrdEvents.DataSource = dtEvents;
GrdEvents.DataBind();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
lblError.Visible = true;
return;
}
}
private void BindGrdEvents()
{
GrdEvents.DataSource = null;
GrdEvents.DataBind();
PnlSearch.BindControls(FilterDictionary, TableName);
#region BetweenDateFromat
string Date = "";
string Dt1 = "20170101";
string Dt2 = DateTime.Now.ToString("yyyyMMdd");
object DateFilter1 = Config.DateTimeFormat(TxtFilterEvents_StartDt.Text.Trim());
object DateFilter2 = Config.DateTimeFormat(TxtFilterEvents_EndDt.Text.Trim());
if (DateFilter1 == null && DateFilter2 == null)
{
Date = "";
}
else
{
if (DateFilter1 != null)
{
Dt1 = ((DateTime)DateFilter1).ToString("yyyyMMdd");
}
if (DateFilter2 != null)
{
Dt2 = ((DateTime)DateFilter2).ToString("yyyyMMdd");
}
Date = Dt1 + "&" + Dt2;
}
#endregion
var Dictionary = new Dictionary <string, object>()
{
{ "ID", TxtFilterEventsID.Text },
{ "EventsTypesID", int.Parse(DListFilterEventsTypes.SelectedValue) },
{ "OrganizationsID", int.Parse(DListFilterOrganizations.SelectedValue) },
{ "EventsDirectionTypesID", int.Parse(DListFilterEventsDirectionTypes.SelectedValue) },
{ "EventsPolicyTypesID", int.Parse(DListFilterEventsPolicyTypes.SelectedValue) },
{ "Name(LIKE)", TxtFilterName.Text },
{ "Subject(LIKE)", TxtFilterSubject.Text },
{ "Place(LIKE)", TxtFilterPlace.Text },
{ "Organizer(LIKE)", TxtFilterOrganizer.Text },
{ "Events_StartDt(BETWEEN)", Config.DateTimeFilter(TxtFilterEvents_StartDt.Text, TxtFilterEvents_EndDt.Text) },
{ "Events_EndDt(BETWEEN)", Config.DateTimeFilter(TxtFilterEvents_StartDt.Text, TxtFilterEvents_EndDt.Text) },
};
int PageNum;
int RowNumber = 20;
if (!int.TryParse(Config._GetQueryString("p"), out PageNum))
{
PageNum = 1;
}
HdnPageNumber.Value = PageNum.ToString();
DALC.DataTableResult FilterList = DALC.GetFilterList(TableName, Dictionary, PageNum, RowNumber);
if (FilterList.Count == -1)
{
return;
}
if (FilterList.Dt.Rows.Count < 1 && PageNum > 1)
{
Config.RedirectURL(string.Format("/tools/events/?p={0}", PageNum - 1));
}
LblCount.Text = string.Format("Axtarış üzrə nəticə: {0}", FilterList.Count);
int Total_Count = 0;
if (FilterList.Count % RowNumber > 0)
{
Total_Count = (FilterList.Count / RowNumber) + 1;
}
else
{
Total_Count = FilterList.Count / RowNumber;
}
HdnTotalCount.Value = Total_Count.ToString();
PnlPager.Visible = FilterList.Count > RowNumber;
GrdEvents.DataSource = FilterList.Dt;
GrdEvents.DataBind();
}
