public System.Data.DataTable ListAsDataTable(Int64 WBranchTransferID = 0, Int64 SupplierID = 0, WBranchTransferDetails SearchKey = new WBranchTransferDetails(), WBranchTransferStatus WBranchTransferstatus = WBranchTransferStatus.All, DateTime? OrderStartDate = null, DateTime? OrderEndDate = null, DateTime? PostingStartDate = null, DateTime? PostingEndDate = null, DateTime? DeliveryStartDate = null, DateTime? DeliveryEndDate = null, string SortField = "WBranchTransferID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE 1=1 "; if (WBranchTransferID != 0) SQL += "AND WBranchTransferID = @WBranchTransferID "; if (SupplierID != 0) SQL += "AND SupplierID = @SupplierID "; if (WBranchTransferstatus != WBranchTransferStatus.All) SQL += "AND Status = @Status "; if (OrderStartDate.GetValueOrDefault() != DateTime.MinValue) SQL += "AND WBranchTransferDate >= @OrderStartDate "; if (OrderEndDate.GetValueOrDefault() != DateTime.MinValue) SQL += "AND WBranchTransferDate <= @OrderEndDate "; if (PostingStartDate.GetValueOrDefault() != DateTime.MinValue) SQL += "AND WBranchTransferDate >= @PostingStartDate "; if (PostingEndDate.GetValueOrDefault() != DateTime.MinValue) SQL += "AND WBranchTransferDate <= @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 : "WBranchTransferID") + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; if (WBranchTransferID != 0) cmd.Parameters.AddWithValue("@WBranchTransferID", WBranchTransferID); if (SupplierID != 0) cmd.Parameters.AddWithValue("@SupplierID", SupplierID); if (WBranchTransferstatus != WBranchTransferStatus.All) cmd.Parameters.AddWithValue("@Status", WBranchTransferstatus.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; } catch (Exception ex) { throw base.ThrowException(ex); } }
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["WBranchTransferID"].ToString(); WBranchTransferStatus status = (WBranchTransferStatus)Enum.Parse(typeof(WBranchTransferStatus), dr["Status"].ToString()); if (status == WBranchTransferStatus.Posted || status == WBranchTransferStatus.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 lnkWBranchTransferNo = (HyperLink)e.Item.FindControl("lnkWBranchTransferNo"); lnkWBranchTransferNo.Text = dr["WBranchTransferNo"].ToString(); string stParam = "?task=" + Common.Encrypt("details", Session.SessionID) + "&WBranchTransferID=" + Common.Encrypt(chkList.Value.ToString(), Session.SessionID); lnkWBranchTransferNo.NavigateUrl = "Default.aspx" + stParam; Label lblWBranchTransferDate = (Label)e.Item.FindControl("lblWBranchTransferDate"); lblWBranchTransferDate.Text = Convert.ToDateTime(dr["WBranchTransferDate"].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 lblWBranchTransferSubTotal = (Label)e.Item.FindControl("lblWBranchTransferSubTotal"); lblWBranchTransferSubTotal.Text = Convert.ToDecimal(dr["SubTotal"].ToString()).ToString("#,##0.#0"); Label lblWBranchTransferRemarks = (Label)e.Item.FindControl("lblWBranchTransferRemarks"); lblWBranchTransferRemarks.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() { WBranchTransfer clsWBranchTransfer = new WBranchTransfer(); DataClass clsDataClass = new DataClass(); Common Common = new Common(); string SortField = "WBranchTransferID"; 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 { } WBranchTransferDetails searchKey = new WBranchTransferDetails(); searchKey.WBranchTransferNo = txtSearch.Text; WBranchTransferStatus status = (WBranchTransferStatus)Enum.Parse(typeof(WBranchTransferStatus), cboStatus.SelectedItem.Value); PageData.DataSource = clsWBranchTransfer.ListAsDataTable(0, 0, searchKey, status, dteTransferStartDate, dteTransferEndDate, dtePostingStartDate, dtePostingEndDate, null, null, SortField, sortoption).DefaultView; clsWBranchTransfer.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 WBranchTransferID = 0, Int64 SupplierID = 0, WBranchTransferDetails SearchKey = new WBranchTransferDetails(), WBranchTransferStatus WBranchTransferstatus = WBranchTransferStatus.All, DateTime?OrderStartDate = null, DateTime?OrderEndDate = null, DateTime?PostingStartDate = null, DateTime?PostingEndDate = null, DateTime?DeliveryStartDate = null, DateTime?DeliveryEndDate = null, string SortField = "WBranchTransferID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE 1=1 "; if (WBranchTransferID != 0) { SQL += "AND WBranchTransferID = @WBranchTransferID "; } if (SupplierID != 0) { SQL += "AND SupplierID = @SupplierID "; } if (WBranchTransferstatus != WBranchTransferStatus.All) { SQL += "AND Status = @Status "; } if (OrderStartDate.GetValueOrDefault() != DateTime.MinValue) { SQL += "AND WBranchTransferDate >= @OrderStartDate "; } if (OrderEndDate.GetValueOrDefault() != DateTime.MinValue) { SQL += "AND WBranchTransferDate <= @OrderEndDate "; } if (PostingStartDate.GetValueOrDefault() != DateTime.MinValue) { SQL += "AND WBranchTransferDate >= @PostingStartDate "; } if (PostingEndDate.GetValueOrDefault() != DateTime.MinValue) { SQL += "AND WBranchTransferDate <= @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 : "WBranchTransferID") + " "; SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC "; SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " "; if (WBranchTransferID != 0) { cmd.Parameters.AddWithValue("@WBranchTransferID", WBranchTransferID); } if (SupplierID != 0) { cmd.Parameters.AddWithValue("@SupplierID", SupplierID); } if (WBranchTransferstatus != WBranchTransferStatus.All) { cmd.Parameters.AddWithValue("@Status", WBranchTransferstatus.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); } catch (Exception ex) { throw base.ThrowException(ex); } }