protected void Filter_Click(object sender, EventArgs e)
{
try
{
string strWhere = " 1=1 ";
if (Common.StringClass.Check(ddlFilterCinema.SelectedValue))
{
strWhere += " and CinId = '" + ddlFilterCinema.SelectedValue + "' ";
}
if (Common.StringClass.Check(ddlFilterFilm.SelectedValue))
{
strWhere += " and FilId = '" + ddlFilterFilm.SelectedValue + "' ";
}
if (Common.StringClass.Check(ddlFilterActive.SelectedValue))
{
strWhere += " and Status = '" + ddlFilterActive.SelectedValue + "' ";
}
grdShowTimes.CurrentPageIndex = 0;
grdShowTimes.DataSource = ShowTimesService.ShowTimes_GetByTop("", strWhere, "");
grdShowTimes.DataBind();
if (grdShowTimes.PageCount <= 1)
{
grdShowTimes.PagerStyle.Visible = false;
}
else
{
grdShowTimes.PagerStyle.Visible = true;
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void grdShowTimes_ItemCommand(object source, DataGridCommandEventArgs e)
{
try
{
string strCa = e.CommandArgument.ToString();
string strWhere = " 1=1 ";
DataGridItem item = default(DataGridItem);
if (e.CommandName == "Edit")
{
_insert = false;
DataTable dt = ShowTimesService.ShowTimes_GetById(strCa);
ddlCinId_Update.SelectedValue = dt.Rows[0]["CinId"].ToString();
ddlFilId_Update.SelectedValue = dt.Rows[0]["FilId"].ToString();
txtId.Value = dt.Rows[0]["ShoId"].ToString();
txtShowTime.Text = dt.Rows[0]["ShowTime"].ToString();
txtPrice.Text = dt.Rows[0]["Price"].ToString();
txtTime.Text = dt.Rows[0]["Time"].ToString();
chkActive.Checked = dt.Rows[0]["Status"].ToString() == "1" || dt.Rows[0]["Status"].ToString() == "True";
pnUpdate.Visible = true;
pnView.Visible = false;
}
if (e.CommandName == "Delete")
{
ShowTimesService.ShowTimes_Delete(strCa);
BindGrid();
}
if (e.CommandName == "Status")
{
string strA = "";
string str = e.Item.Cells[2].Text;
strA = str == "1" ? "0" : "1";
ShowTimesService.ShowTimes_Update_Status(strCa, strA);
BindGrid();
}
if (e.CommandName == "ascPrice")
{
if (Common.StringClass.Check(ddlFilterCinema.SelectedValue))
{
strWhere += " and CinId = '" + ddlFilterCinema.SelectedValue + "' ";
}
if (Common.StringClass.Check(ddlFilterFilm.SelectedValue))
{
strWhere += " and FilId = '" + ddlFilterFilm.SelectedValue + "' ";
}
if (Common.StringClass.Check(ddlFilterActive.SelectedValue))
{
strWhere += " and Status = '" + ddlFilterActive.SelectedValue + "' ";
}
grdShowTimes.DataSource = ShowTimesService.ShowTimes_GetByTop("", strWhere, "Price");
grdShowTimes.DataBind();
if (grdShowTimes.PageCount <= 1)
{
grdShowTimes.PagerStyle.Visible = false;
}
}
if (e.CommandName == "sortdesc")
{
if (Common.StringClass.Check(ddlFilterCinema.SelectedValue))
{
strWhere += " and CinId = '" + ddlFilterCinema.SelectedValue + "' ";
}
if (Common.StringClass.Check(ddlFilterFilm.SelectedValue))
{
strWhere += " and FilId = '" + ddlFilterFilm.SelectedValue + "' ";
}
if (Common.StringClass.Check(ddlFilterActive.SelectedValue))
{
strWhere += " and Status = '" + ddlFilterActive.SelectedValue + "' ";
}
grdShowTimes.DataSource = ShowTimesService.ShowTimes_GetByTop("", strWhere, "NameF");
grdShowTimes.DataBind();
if (grdShowTimes.PageCount <= 1)
{
grdShowTimes.PagerStyle.Visible = false;
}
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
