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);
}
}
