private void LoadList()
{
TransferOut clsTransferOut = new TransferOut();
DataClass clsDataClass = new DataClass();
Common Common = new Common();
string SortField = "TransferOutID";
if (Request.QueryString["sortfield"] != null)
{
SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID);
}
SortOption sortoption = SortOption.Ascending;
if (Request.QueryString["sortoption"] != null)
{
sortoption = (SortOption)Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true);
}
DateTime dteTransferStartDate = DateTime.MinValue;
try { if (txtOrderStartDate.Text != string.Empty)
{
dteTransferStartDate = Convert.ToDateTime(txtOrderStartDate.Text + " " + txtOrderStartTime.Text);
}
}
catch { }
DateTime dteTransferEndDate = DateTime.MinValue;
try { if (txtOrderEndDate.Text != string.Empty)
{
dteTransferEndDate = Convert.ToDateTime(txtOrderEndDate.Text + " " + txtOrderEndTime.Text);
}
}
catch { }
DateTime dtePostingStartDate = DateTime.MinValue;
try { if (txtPostingStartDate.Text != string.Empty)
{
dtePostingStartDate = Convert.ToDateTime(txtPostingStartDate.Text + " " + txtPostingStartTime.Text);
}
}
catch { }
DateTime dtePostingEndDate = DateTime.MinValue;
try { if (txtPostingEndDate.Text != string.Empty)
{
dtePostingEndDate = Convert.ToDateTime(txtPostingEndDate.Text + " " + txtPostingEndTime.Text);
}
}
catch { }
string SearchKey = txtSearch.Text;
TransferOutStatus status = (TransferOutStatus)Enum.Parse(typeof(TransferOutStatus), cboStatus.SelectedItem.Value);
PageData.DataSource = clsTransferOut.SearchAsDataTable(status, dteTransferStartDate, dteTransferEndDate, dtePostingStartDate, dtePostingEndDate, SearchKey, SortField, sortoption).DefaultView;
clsTransferOut.CommitAndDispose();
int iPageSize = Convert.ToInt16(Session["PageSize"]);
PageData.AllowPaging = true;
PageData.PageSize = iPageSize;
try
{
PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
catch
{
PageData.CurrentPageIndex = 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
cboCurrentPage.Items.Clear();
for (int i = 0; i < PageData.PageCount; i++)
{
int iValue = i + 1;
cboCurrentPage.Items.Add(new ListItem(iValue.ToString(), iValue.ToString()));
if (PageData.CurrentPageIndex == i)
{
cboCurrentPage.Items[i].Selected = true;
}
else
{
cboCurrentPage.Items[i].Selected = false;
}
}
lblDataCount.Text = " of " + " " + PageData.PageCount;
}
protected void lstItem_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Header)
{
LoadSortFieldOptions(e);
}
else if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataRowView dr = (DataRowView)e.Item.DataItem;
HtmlInputCheckBox chkList = (HtmlInputCheckBox)e.Item.FindControl("chkList");
chkList.Value = dr["TransferOutID"].ToString();
TransferOutStatus status = (TransferOutStatus)Enum.Parse(typeof(TransferOutStatus), dr["Status"].ToString());
if (status == TransferOutStatus.Posted || status == TransferOutStatus.Cancelled)
{
chkList.Attributes.Add("disabled", "false");
ImageButton imgItemDelete = (ImageButton)e.Item.FindControl("imgItemDelete");
ImageButton imgItemEdit = (ImageButton)e.Item.FindControl("imgItemEdit");
ImageButton imgItemPost = (ImageButton)e.Item.FindControl("imgItemPost");
imgItemDelete.Enabled = false; imgItemDelete.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif";
imgItemEdit.Enabled = false; imgItemEdit.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif";
imgItemPost.Enabled = false; imgItemPost.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif";
}
HyperLink lnkTransferOutNo = (HyperLink)e.Item.FindControl("lnkTransferOutNo");
lnkTransferOutNo.Text = dr["TransferOutNo"].ToString();
Common Common = new Common();
string stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&transferoutid=" + Common.Encrypt(chkList.Value.ToString(), Session.SessionID);
lnkTransferOutNo.NavigateUrl = "Default.aspx" + stParam;
Label lblTransferOutDate = (Label)e.Item.FindControl("lblTransferOutDate");
lblTransferOutDate.Text = Convert.ToDateTime(dr["TransferOutDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
Label lblSupplierID = (Label)e.Item.FindControl("lblSupplierID");
lblSupplierID.Text = dr["SupplierID"].ToString();
HyperLink lblSupplierCode = (HyperLink)e.Item.FindControl("lblSupplierCode");
lblSupplierCode.Text = dr["SupplierCode"].ToString();
stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&id=" + Common.Encrypt(lblSupplierID.Text, Session.SessionID);
lblSupplierCode.NavigateUrl = Constants.ROOT_DIRECTORY + "/PurchasesAndPayables/_Vendor/Default.aspx" + stParam;
Label lblReqDeliveryDate = (Label)e.Item.FindControl("lblReqDeliveryDate");
lblReqDeliveryDate.Text = Convert.ToDateTime(dr["RequiredDeliveryDate"].ToString()).ToString("yyyy-MM-dd");
Label lblBranchID = (Label)e.Item.FindControl("lblBranchID");
lblBranchID.Text = dr["BranchID"].ToString();
Label lblBranchCode = (Label)e.Item.FindControl("lblBranchCode");
lblBranchCode.Text = dr["BranchCode"].ToString();
Label lblTransferOutSubTotal = (Label)e.Item.FindControl("lblTransferOutSubTotal");
lblTransferOutSubTotal.Text = Convert.ToDecimal(dr["SubTotal"].ToString()).ToString("#,##0.#0");
Label lblTransferOutRemarks = (Label)e.Item.FindControl("lblTransferOutRemarks");
lblTransferOutRemarks.Text = dr["Remarks"].ToString();
//For anchor
// HtmlGenericControl divExpCollAsst = (HtmlGenericControl) e.Item.FindControl("divExpCollAsst");
// HtmlAnchor anchorDown = (HtmlAnchor) e.Item.FindControl("anchorDown");
// anchorDown.HRef = "javascript:ToggleDiv('" + divExpCollAsst.ClientID + "')";
}
}
public System.Data.DataTable SearchAsDataTable(TransferOutStatus TransferOutStatus, DateTime OrderStartDate, DateTime OrderEndDate, DateTime PostingStartDate, DateTime PostingEndDate, string SearchKey, string SortField, SortOption SortOrder)
{
try
{
if (SortField == string.Empty || SortField == null) SortField = "TransferOutID";
string SQL = SQLSelect() + "WHERE Status = @Status AND (TransferOutNo LIKE @SearchKey or TransferOutDate LIKE @SearchKey or SupplierCode LIKE @SearchKey " +
"or SupplierContact LIKE @SearchKey or BranchCode LIKE @SearchKey or RequiredDeliveryDate LIKE @SearchKey) ";
if (OrderStartDate != DateTime.MinValue) SQL += "AND TransferOutDate >= @OrderStartDate ";
if (OrderEndDate != DateTime.MinValue) SQL += "AND TransferOutDate <= @OrderEndDate ";
if (PostingStartDate != DateTime.MinValue) SQL += "AND TransferOutDate >= @PostingStartDate ";
if (PostingEndDate != DateTime.MinValue) SQL += "AND TransferOutDate <= @PostingEndDate ";
SQL += "ORDER BY " + SortField;
if (SortOrder == SortOption.Ascending)
SQL += " ASC";
else
SQL += " DESC";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@Status", TransferOutStatus.ToString("d"));
cmd.Parameters.AddWithValue("@SearchKey", "%" + SearchKey + "%");
if (OrderStartDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderStartDate", OrderStartDate.ToString("yyyy-MM-dd HH:mm:ss"));
if (OrderEndDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderEndDate", OrderEndDate.ToString("yyyy-MM-dd HH:mm:ss"));
if (PostingStartDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingStartDate", PostingStartDate.ToString("yyyy-MM-dd HH:mm:ss"));
if (PostingEndDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingEndDate", PostingEndDate.ToString("yyyy-MM-dd HH:mm:ss"));
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public MySqlDataReader List(TransferOutStatus TransferOutStatus, DateTime StartDate, DateTime EndDate)
{
try
{
string SQL = SQLSelect() + "WHERE Status = @Status AND DeliveryDate BETWEEN @StartDate AND @EndDate ORDER BY TransferOutID ASC";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmStartDate = new MySqlParameter("@StartDate",MySqlDbType.DateTime);
prmStartDate.Value = StartDate.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmStartDate);
MySqlParameter prmEndDate = new MySqlParameter("@EndDate",MySqlDbType.DateTime);
prmEndDate.Value = EndDate.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmEndDate);
MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
prmStatus.Value = TransferOutStatus.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlDataReader myReader = base.ExecuteReader(cmd);
return myReader;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable SearchAsDataTable(TransferOutStatus TransferOutStatus, string SearchKey, string SortField, SortOption SortOrder)
{
try
{
if (SortField == string.Empty || SortField == null) SortField = "TransferOutID";
string SQL = SQLSelect() + "WHERE Status = @Status AND (TransferOutNo LIKE @SearchKey or TransferOutDate LIKE @SearchKey or SupplierCode LIKE @SearchKey " +
"or SupplierContact LIKE @SearchKey or BranchCode LIKE @SearchKey or RequiredDeliveryDate LIKE @SearchKey) " +
"ORDER BY " + SortField;
if (SortOrder == SortOption.Ascending)
SQL += " ASC";
else
SQL += " DESC";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
prmStatus.Value = TransferOutStatus.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
prmSearchKey.Value = "%" + SearchKey + "%";
cmd.Parameters.Add(prmSearchKey);
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public MySqlDataReader Search(TransferOutStatus TransferOutStatus, string SearchKey, string SortField, SortOption SortOrder)
{
try
{
if (SortField == string.Empty || SortField == null) SortField = "TransferOutID";
string SQL = SQLSelect() + "WHERE Status = @Status AND (TransferOutNo LIKE @SearchKey or TransferOutDate LIKE @SearchKey or SupplierCode LIKE @SearchKey " +
"or SupplierContact LIKE @SearchKey or BranchCode LIKE @SearchKey or RequiredDeliveryDate LIKE @SearchKey) " +
"ORDER BY " + SortField;
if (SortOrder == SortOption.Ascending)
SQL += " ASC";
else
SQL += " DESC";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
prmStatus.Value = TransferOutStatus.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
prmSearchKey.Value = "%" + SearchKey + "%";
cmd.Parameters.Add(prmSearchKey);
MySqlDataReader myReader = base.ExecuteReader(cmd);
return myReader;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public MySqlDataReader List(TransferOutStatus TransferOutStatus, long SupplierID, string SortField, SortOption SortOrder)
{
try
{
if (SortField == string.Empty || SortField == null) SortField = "TransferOutID";
string SQL = SQLSelect() + "WHERE Status =@Status AND SupplierID = @SupplierID ORDER BY " + SortField;
if (SortOrder == SortOption.Ascending)
SQL += " ASC";
else
SQL += " DESC";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
prmStatus.Value = TransferOutStatus.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlParameter prmSupplierID = new MySqlParameter("@SupplierID",MySqlDbType.Int64);
prmSupplierID.Value = SupplierID;
cmd.Parameters.Add(prmSupplierID);
MySqlDataReader myReader = base.ExecuteReader(cmd);
return myReader;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAsDataTable(TransferOutStatus TransferOutStatus, DateTime OrderStartDate, DateTime OrderEndDate, DateTime PostingStartDate, DateTime PostingEndDate, string SortField, SortOption SortOrder)
{
if (SortField == string.Empty || SortField == null) SortField = "TransferOutID";
string SQL = SQLSelect() + "WHERE Status = @Status ";
if (OrderStartDate != DateTime.MinValue) SQL += "AND TransferOutDate >= @OrderStartDate ";
if (OrderEndDate != DateTime.MinValue) SQL += "AND TransferOutDate <= @OrderEndDate ";
if (PostingStartDate != DateTime.MinValue) SQL += "AND TransferOutDate >= @PostingStartDate ";
if (PostingEndDate != DateTime.MinValue) SQL += "AND TransferOutDate <= @PostingEndDate ";
SQL += "ORDER BY " + SortField;
if (SortOrder == SortOption.Ascending)
SQL += " ASC";
else
SQL += " DESC";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@Status", TransferOutStatus.ToString("d"));
if (OrderStartDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderStartDate", OrderStartDate.ToString("yyyy-MM-dd HH:mm:ss"));
if (OrderEndDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderEndDate", OrderEndDate.ToString("yyyy-MM-dd HH:mm:ss"));
if (PostingStartDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingStartDate", PostingStartDate.ToString("yyyy-MM-dd HH:mm:ss"));
if (PostingEndDate != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingEndDate", PostingEndDate.ToString("yyyy-MM-dd HH:mm:ss"));
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
public System.Data.DataTable ListAsDataTable(TransferOutStatus TransferOutStatus, string SortField, SortOption SortOrder)
{
if (SortField == string.Empty || SortField == null) SortField = "TransferOutID";
string SQL = SQLSelect() + "WHERE Status = @Status ORDER BY " + SortField;
if (SortOrder == SortOption.Ascending)
SQL += " ASC";
else
SQL += " DESC";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
prmStatus.Value = TransferOutStatus.ToString("d");
cmd.Parameters.Add(prmStatus);
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
