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["BranchTransferID"].ToString(); BranchTransferStatus status = (BranchTransferStatus)Enum.Parse(typeof(BranchTransferStatus), dr["Status"].ToString()); if (status == BranchTransferStatus.Posted || status == BranchTransferStatus.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 lnkBranchTransferNo = (HyperLink)e.Item.FindControl("lnkBranchTransferNo"); lnkBranchTransferNo.Text = dr["BranchTransferNo"].ToString(); string stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&BranchTransferID=" + Common.Encrypt(chkList.Value.ToString(), Session.SessionID); lnkBranchTransferNo.NavigateUrl = "Default.aspx" + stParam; Label lblBranchTransferDate = (Label)e.Item.FindControl("lblBranchTransferDate"); lblBranchTransferDate.Text = Convert.ToDateTime(dr["BranchTransferDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); Label lblBranchIDFrom = (Label)e.Item.FindControl("lblBranchIDFrom"); lblBranchIDFrom.Text = dr["BranchIDFrom"].ToString(); HyperLink lnkBranchCodeFrom = (HyperLink)e.Item.FindControl("lnkBranchCodeFrom"); lnkBranchCodeFrom.Text = dr["BranchCodeFrom"].ToString(); stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&id=" + Common.Encrypt(lblBranchIDFrom.Text, Session.SessionID); lnkBranchCodeFrom.NavigateUrl = Constants.ROOT_DIRECTORY + "/Inventory/_Branch/Default.aspx" + stParam; Label lblBranchIDTo = (Label)e.Item.FindControl("lblBranchIDTo"); lblBranchIDTo.Text = dr["BranchIDTo"].ToString(); HyperLink lnkBranchCodeTo = (HyperLink)e.Item.FindControl("lnkBranchCodeTo"); lnkBranchCodeTo.Text = dr["BranchCodeTo"].ToString(); stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&id=" + Common.Encrypt(lblBranchIDTo.Text, Session.SessionID); lnkBranchCodeTo.NavigateUrl = Constants.ROOT_DIRECTORY + "/Inventory/_Branch/Default.aspx" + stParam; Label lblReqDeliveryDate = (Label)e.Item.FindControl("lblReqDeliveryDate"); lblReqDeliveryDate.Text = Convert.ToDateTime(dr["RequiredDeliveryDate"].ToString()).ToString("yyyy-MM-dd"); Label lblBranchTransferSubTotal = (Label)e.Item.FindControl("lblBranchTransferSubTotal"); lblBranchTransferSubTotal.Text = Convert.ToDecimal(dr["SubTotal"].ToString()).ToString("#,##0.#0"); Label lblBranchTransferRemarks = (Label)e.Item.FindControl("lblBranchTransferRemarks"); lblBranchTransferRemarks.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 + "')"; } }
private void LoadList() { BranchTransfer clsBranchTransfer = new BranchTransfer(); DataClass clsDataClass = new DataClass(); Common Common = new Common(); string SortField = "BranchTransferID"; 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 (txtTransferStartDate.Text != string.Empty) { dteTransferStartDate = Convert.ToDateTime(txtTransferStartDate.Text + " " + txtTransferStartTime.Text); } } catch { } DateTime dteTransferEndDate = DateTime.MinValue; try { if (txtTransferEndDate.Text != string.Empty) { dteTransferEndDate = Convert.ToDateTime(txtTransferEndDate.Text + " " + txtTransferEndTime.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 { } BranchTransferDetails searchKey = new BranchTransferDetails(); searchKey.BranchTransferNo = txtSearch.Text; BranchTransferStatus status = (BranchTransferStatus)Enum.Parse(typeof(BranchTransferStatus), cboStatus.SelectedItem.Value); PageData.DataSource = clsBranchTransfer.ListAsDataTable(0, 0, searchKey, status, dteTransferStartDate, dteTransferEndDate, dtePostingStartDate, dtePostingEndDate, null, null, SortField, sortoption).DefaultView; clsBranchTransfer.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; }
public System.Data.DataTable ListAsDataTable(Int64 BranchTransferID = 0, Int64 SupplierID = 0, BranchTransferDetails SearchKey = new BranchTransferDetails(), BranchTransferStatus BranchTransferstatus = BranchTransferStatus.All, DateTime? OrderStartDate = null, DateTime? OrderEndDate = null, DateTime? PostingStartDate = null, DateTime? PostingEndDate = null, DateTime? DeliveryStartDate = null, DateTime? DeliveryEndDate = null, string SortField = "BranchTransferID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE 1=1 "; if (BranchTransferID != 0) SQL += "AND BranchTransferID = @BranchTransferID "; if (SupplierID != 0) SQL += "AND SupplierID = @SupplierID "; if (BranchTransferstatus != BranchTransferStatus.All) SQL += "AND Status = @Status "; if (OrderStartDate.GetValueOrDefault() != DateTime.MinValue) SQL += "AND BranchTransferDate >= @OrderStartDate "; if (OrderEndDate.GetValueOrDefault() != DateTime.MinValue) SQL += "AND BranchTransferDate <= @OrderEndDate "; if (PostingStartDate.GetValueOrDefault() != DateTime.MinValue) SQL += "AND BranchTransferDate >= @PostingStartDate "; if (PostingEndDate.GetValueOrDefault() != DateTime.MinValue) SQL += "AND BranchTransferDate <= @PostingEndDate "; if (DeliveryStartDate.GetValueOrDefault() != DateTime.MinValue) SQL += "AND DeliveryDate >= @DeliveryStartDate "; if (DeliveryEndDate.GetValueOrDefault() != DateTime.MinValue) SQL += "AND DeliveryDate <= @DeliveryEndDate "; SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "BranchTransferID") + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; if (BranchTransferID != 0) cmd.Parameters.AddWithValue("@BranchTransferID", BranchTransferID); if (SupplierID != 0) cmd.Parameters.AddWithValue("@SupplierID", SupplierID); if (BranchTransferstatus != BranchTransferStatus.All) cmd.Parameters.AddWithValue("@Status", BranchTransferstatus.ToString("d")); if (OrderStartDate.GetValueOrDefault() != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderStartDate", OrderStartDate.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : OrderStartDate); if (OrderEndDate.GetValueOrDefault() != DateTime.MinValue) cmd.Parameters.AddWithValue("@OrderEndDate", OrderEndDate.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : OrderEndDate); if (PostingStartDate.GetValueOrDefault() != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingStartDate", PostingStartDate.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : PostingStartDate); if (PostingEndDate.GetValueOrDefault() != DateTime.MinValue) cmd.Parameters.AddWithValue("@PostingEndDate", PostingEndDate.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : PostingEndDate); if (DeliveryStartDate.GetValueOrDefault() != DateTime.MinValue) cmd.Parameters.AddWithValue("@DeliveryStartDate", DeliveryStartDate.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : DeliveryStartDate); if (DeliveryEndDate.GetValueOrDefault() != DateTime.MinValue) cmd.Parameters.AddWithValue("@DeliveryEndDate", DeliveryEndDate.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : DeliveryEndDate); cmd.CommandText = SQL; 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; }