private void ListImages()
{
ImageFilesDAL obj = new ImageFilesDAL();
DataSet objDataset = new DataSet();
try
{
//string where = " UserCreated =" + _user.UserID;
string where = string.Empty;
if (ddlStock.SelectedValue.Trim() != "0")
{
where += " 1=1 And AuthorID =1 ";
}
else
{
where += " 1=1 And (( AuthorID =0 ) OR (AuthorID is null ))";
}
if (!string.IsNullOrEmpty(fileName.Text))
{
where += " AND ImageFileName like N'%" + fileName.Text + "%'";
}
//if (Drop_Chuyenmuc.SelectedValue.Trim() != "0")
// where += string.Format(" AND Categorys_ID IN (SELECT * FROM [fn_Return_Category_Tree] ({0}))", this.Drop_Chuyenmuc.SelectedValue);
if (!String.IsNullOrEmpty(txt_FromDate.Text.Trim()))
{
where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)>=0) ", UltilFunc.ToDate(this.txt_FromDate.Value.ToString().Trim(), "MM/dd/yyyy"));
}
if (!String.IsNullOrEmpty(txt_ToDate.Text.Trim()))
{
where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)<=0)", UltilFunc.ToDate(this.txt_ToDate.Value.ToString().Trim(), "MM/dd/yyyy"));
}
else
{
if (ddlStock.SelectedValue.Trim() == "0")
{
where += " AND " + string.Format(" DATEDIFF(DAY,DateCreated,'{0}')=0 ", DateTime.Now.ToString("MM/dd/yyyy"));
}
}
where += " ORDER BY DateCreated DESC";
objDataset = obj.ListAllImages(where);
if (objDataset != null)
{
DataView _dv = obj.BindGridListImages(objDataset.Tables[0]);
dlImages.DataSource = _dv;
dlImages.DataBind();
}
objDataset.Clear();
}
catch
{
dlImages.DataSource = null;
dlImages.DataBind();
}
}
private void ListImages()
{
ImageFilesDAL obj = new ImageFilesDAL();
DataSet objDataset = new DataSet();
string where = " UserCreated =" + user.UserID;
//if (!String.IsNullOrEmpty(txt_FromDate.Text.Trim()))
// where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)>=0) ", UltilFunc.ToDate(this.txt_FromDate.Value.ToString().Trim(), "MM/dd/yyyy"));
//if (!String.IsNullOrEmpty(txt_ToDate.Text.Trim()))
// where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)<=0) ", UltilFunc.ToDate(this.txt_ToDate.Value.ToString().Trim(), "MM/dd/yyyy"));
//else
where += " AND " + string.Format(" DATEDIFF(DAY,DateCreated,'{0}')=0 ", DateTime.Now.ToString("MM/dd/yyyy"));
where += " ORDER BY DateCreated DESC";
objDataset = obj.ListAllImages(where);
if (objDataset != null)
{
DataView _dv = obj.BindGridListImages(objDataset.Tables[0]);
dlImages.DataSource = _dv;
dlImages.DataBind();
}
}
private void ListImages()
{
ImageFilesDAL obj = new ImageFilesDAL();
DataSet objDataset = new DataSet();
//string where = " UserCreated =" + _user.UserID;
string where = "";
if (ddlStock.SelectedValue.Trim() != "0")
{
where += " 1=1 And AuthorID =1 ";
}
else
{
where += " 1=1 And (( AuthorID =0 ) OR (AuthorID is null ))";
}
if (!String.IsNullOrEmpty(txt_FromDate.Text.Trim()))
{
where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)>=0) ", UltilFunc.ToDate(this.txt_FromDate.Value.ToString().Trim(), "MM/dd/yyyy"));
}
if (!String.IsNullOrEmpty(txt_ToDate.Text.Trim()))
{
where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)<=0) ", UltilFunc.ToDate(this.txt_ToDate.Value.ToString().Trim(), "MM/dd/yyyy"));
}
else
{
if (ddlStock.SelectedValue.Trim() == "0")
{
where += " AND " + string.Format(" DATEDIFF(DAY,DateCreated,'{0}')=0 ", DateTime.Now.ToString("MM/dd/yyyy"));
}
}
where += " ORDER BY DateCreated DESC";
objDataset = obj.ListAllImages(where);
if (objDataset != null)
{
DataView _dv = obj.BindGridListImages(objDataset.Tables[0]);
dlImages.DataSource = _dv;
dlImages.DataBind();
}
}
private void ListImages()
{
try
{
ImageFilesDAL obj = new ImageFilesDAL();
DataSet objDataset = new DataSet();
// Populate the repeater control with the Items DataSet
PagedDataSource objPds = new PagedDataSource();
//string where = " UserCreated =" + _user.UserID;
string where = "";
if (ddlStock.SelectedValue.Trim() != "0")
{
where += " 1=1 And AuthorID =1 ";
}
else
{
where += " 1=1 And (( AuthorID =0 ) OR (AuthorID is null ))";
}
if (!string.IsNullOrEmpty(txtTenfile.Text))
{
where += " AND ImageFileName like N'%" + txtTenfile.Text + "%'";
}
if (Drop_Chuyenmuc.SelectedValue.Trim() != "0")
{
where += string.Format(" AND Categorys_ID IN (SELECT * FROM [fn_Return_Category_Tree] ({0}))", this.Drop_Chuyenmuc.SelectedValue);
}
if (!String.IsNullOrEmpty(txt_FromDate.Text.Trim()))
{
where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)>=0)", UltilFunc.ToDate(this.txt_FromDate.Value.ToString().Trim(), "MM/dd/yyyy"));
}
if (!String.IsNullOrEmpty(txt_ToDate.Text.Trim()))
{
where += " AND " + string.Format(" (Datediff(DAY,'{0}',DateCreated)<=0) ", UltilFunc.ToDate(this.txt_ToDate.Value.ToString().Trim(), "MM/dd/yyyy"));
}
else
{
if (ddlStock.SelectedValue.Trim() == "0")
{
where += " AND " + string.Format(" DATEDIFF(DAY,DateCreated,'{0}')=0 ", DateTime.Now.ToString("MM/dd/yyyy"));
}
}
where += " ORDER BY DateCreated DESC";
objDataset = obj.ListAllImages(where);
if (objDataset != null && objDataset.Tables[0].Rows.Count > 0)
{
DataTable _dv = obj.BindGridListImages2Table(objDataset.Tables[0]);
objPds.DataSource = _dv.DefaultView;
objPds.AllowPaging = true;
if (ddlStock.SelectedValue.Trim() != "0")
{
objPds.PageSize = 30;
}
else
{
objPds.PageSize = 12;
}
objPds.CurrentPageIndex = CurrentPage;
lblCurrentPage.Text = "Page: " + (CurrentPage + 1).ToString() + " / " + objPds.PageCount.ToString();
// Disable Prev or Next buttons if necessary
cmdNext.Visible = true;
cmdPrev.Visible = true;
cmdPrev.Enabled = !objPds.IsFirstPage;
cmdNext.Enabled = !objPds.IsLastPage;
//dlImages.DataSource = _dv;
dlImages.DataSource = objPds;
dlImages.DataBind();
}
else
{
lblCurrentPage.Text = "";
cmdNext.Visible = false;
cmdPrev.Visible = false;
dlImages.DataSource = null;
dlImages.DataBind();
}
objDataset.Dispose();
}
catch
{
dlImages.DataSource = null;
dlImages.DataBind();
}
}
