private void LoadMembers()
{
Contacts clsContact = new Contacts();
DataClass clsDataClass = new DataClass();
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactCode = true;
clsContactColumns.ContactName = true;
clsContactColumns.RewardDetails = true;
ContactColumns clsSearchColumns = new ContactColumns();
clsSearchColumns.ContactCode = true;
clsSearchColumns.ContactName = true;
clsSearchColumns.RewardDetails = true;
cboCustomer.DataTextField = "ContactName";
cboCustomer.DataValueField = "ContactID";
string SearchKey = "%" + txtCustomer.Text;
cboCustomer.DataSource = clsContact.Customers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsSearchColumns, SearchKey, 20, false, "ContactName", System.Data.SqlClient.SortOrder.Ascending).DefaultView;
cboCustomer.DataBind();
clsContact.CommitAndDispose();
if (cboCustomer.Items.Count == 0)
{
cboCustomer.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
}
cboCustomer.SelectedIndex = 0;
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
Int32 iID = Convert.ToInt32(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
ProductGroup clsProductGroup = new ProductGroup();
cboProductGroup.DataTextField = "ProductGroupName";
cboProductGroup.DataValueField = "ProductGroupID";
cboProductGroup.DataSource = clsProductGroup.ListAsDataTable(SortField: "ProductGroupName").DefaultView;
cboProductGroup.DataBind();
cboProductGroup.SelectedIndex = cboProductGroup.Items.Count - 1;
Data.Unit clsUnit = new Data.Unit(clsProductGroup.Connection, clsProductGroup.Transaction);
cboProductUnit.DataTextField = "UnitName";
cboProductUnit.DataValueField = "UnitID";
cboProductUnit.DataSource = clsUnit.ListAsDataTable(SortField: "UnitName").DefaultView;
cboProductUnit.DataBind();
cboProductUnit.SelectedIndex = cboProductUnit.Items.Count - 1;
clsUnit.CommitAndDispose();
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactName = true;
ContactColumns clsContactSearchColumns = new ContactColumns();
Contacts clsContact = new Contacts(clsProductGroup.Connection, clsProductGroup.Transaction);
cboSupplier.DataTextField = "ContactName";
cboSupplier.DataValueField = "ContactID";
cboSupplier.DataSource = clsContact.Suppliers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsContactSearchColumns, string.Empty, 0, false, "ContactName", System.Data.SqlClient.SortOrder.Ascending).DefaultView;
cboSupplier.DataBind();
cboSupplier.SelectedIndex = cboSupplier.Items.Count - 1;
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductGroup.Connection, clsProductGroup.Transaction);
ProductUnitsMatrixDetails clsUnitDetails = clsUnitMatrix.LastDetails(iID);
if (clsUnitDetails.BottomUnitName == null)
{
cboProductUnit.Enabled = true;
}
// Added July 9, 2010
Terminal clsTerminal = new Terminal(clsProductGroup.Connection, clsProductGroup.Transaction);
TerminalDetails clsTerminalDetails = clsTerminal.Details(Int32.Parse(Session["BranchID"].ToString()), Session["TerminalNo"].ToString());
txtWSPriceMarkUp.Text = clsTerminalDetails.WSPriceMarkUp.ToString();
txtMargin.Text = clsTerminalDetails.RETPriceMarkUp.ToString();
clsProductGroup.CommitAndDispose();
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
ProductGroup clsProductGroup = new ProductGroup();
cboProductGroup.DataTextField = "ProductGroupName";
cboProductGroup.DataValueField = "ProductGroupID";
cboProductGroup.DataSource = clsProductGroup.ListAsDataTable(SortField: "ProductGroupName").DefaultView;
cboProductGroup.DataBind();
cboProductGroup.SelectedIndex = cboProductGroup.Items.Count - 1;
Data.Unit clsUnit = new Data.Unit(clsProductGroup.Connection, clsProductGroup.Transaction);
cboProductUnit.DataTextField = "UnitName";
cboProductUnit.DataValueField = "UnitID";
cboProductUnit.DataSource = clsUnit.ListAsDataTable(SortField: "UnitName").DefaultView;
cboProductUnit.DataBind();
cboProductUnit.SelectedIndex = cboProductUnit.Items.Count - 1;
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactName = true;
ContactColumns clsContactSearchColumns = new ContactColumns();
Contacts clsContact = new Contacts(clsProductGroup.Connection, clsProductGroup.Transaction);
cboSupplier.DataTextField = "ContactName";
cboSupplier.DataValueField = "ContactID";
cboSupplier.DataSource = clsContact.Suppliers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsContactSearchColumns, string.Empty, 0, false, "ContactName", System.Data.SqlClient.SortOrder.Ascending).DefaultView;
cboSupplier.DataBind();
cboSupplier.SelectedIndex = cboSupplier.Items.Count - 1;
//// Added July 9, 2010
// Remove Nov 22, 2011 - overwritten when a subgroup is selected
//Terminal clsTerminal = new Terminal(clsProductGroup.Connection, clsProductGroup.Transaction);
//TerminalDetails clsTerminalDetails = clsTerminal.Details(1);
//txtWSPriceMarkUp.Text = clsTerminalDetails.WSPriceMarkUp.ToString();
//txtMargin.Text = clsTerminalDetails.RETPriceMarkUp.ToString();
//txtVAT.Text = clsTerminalDetails.VAT.ToString("###.#0");
//txtEVAT.Text = clsTerminalDetails.EVAT.ToString("###.#0");
//txtLocalTax.Text = clsTerminalDetails.LocalTax.ToString("###.#0");
clsProductGroup.CommitAndDispose();
cboProductGroup_SelectedIndexChanged(null, null);
}
protected void cboContact_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
if (cboContact.SelectedItem.Value != Constants.ZERO_STRING)
{
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactCode = true;
clsContactColumns.ContactName = true;
clsContactColumns.CreditDetails = true;
ContactColumns clsSearchColumns = new ContactColumns();
clsSearchColumns.ContactCode = true;
clsSearchColumns.ContactName = true;
clsSearchColumns.CreditDetails = true;
Int64 iGuarantorID = Int64.Parse(cboContact.SelectedItem.Value);
Contacts clsContact = new Contacts();
Data.ContactDetails clsContactDetails = clsContact.Details(iGuarantorID);
System.Data.DataTable dt = clsContact.CustomersWithCredits(clsContactColumns, iGuarantorID, SortField: "CreditCardNo"); // "", dteExpiryDateFrom, dteExpiryDateTo, enumCreditCardStatus, Int32.Parse(cboCreditType.SelectedItem.Value),
clsContact.CommitAndDispose();
lstItemCustomer.DataSource = dt.DefaultView;
lstItemCustomer.DataBind();
txtCreditCardTypeCode.Text = clsContactDetails.CreditDetails.CardTypeDetails.CardTypeCode;
txtCreditCardTypeCode.ToolTip = clsContactDetails.CreditDetails.CardTypeDetails.CardTypeID.ToString();
divGuarantorInfo.Visible = true;
}
else
{
divGuarantorInfo.Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string TranslateFlag(this ContactColumns value, Translator translator)
{
if (value == ContactColumns.None)
{
return(ContactColumns.None.Translate(translator));
}
else
{
var list = new List <string>();
foreach (var flag in Flags)
{
if (value.HasFlag(flag))
{
list.Add(flag.Translate(translator));
}
}
return(string.Join(", ", list));
}
}
protected void cboContact_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
if (cboContact.SelectedItem.Value != Constants.ZERO_STRING)
{
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactCode = true;
clsContactColumns.ContactName = true;
clsContactColumns.CreditDetails = true;
ContactColumns clsSearchColumns = new ContactColumns();
clsSearchColumns.ContactCode = true;
clsSearchColumns.ContactName = true;
clsSearchColumns.CreditDetails = true;
Int64 iContactID = Int64.Parse(cboContact.SelectedItem.Value);
Contacts clsContact = new Contacts();
Data.ContactDetails clsContactDetails = clsContact.Details(iContactID);
Data.ContactDetails clsGuarantorDetails = clsContact.Details(clsContactDetails.CreditDetails.GuarantorID);
clsContact.CommitAndDispose();
txtGuarantorName.Text = clsGuarantorDetails.ContactName.ToString();
txtGuarantorName.ToolTip = clsGuarantorDetails.ContactID.ToString();
divContactInfo.Visible = true;
}
else
{
divContactInfo.Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string Translate(this ContactColumns value, Translator translator)
{
switch (value)
{
case ContactColumns.None:
return(translator.Get("Enum.ContactColumns.None", "Value 'None' in ContactColumns enum", "None"));
case ContactColumns.Organization:
return(translator.Get("Enum.ContactColumns.Organization", "Value 'Organization' in ContactColumns enum", "Organization"));
case ContactColumns.Name:
return(translator.Get("Enum.ContactColumns.Name", "Value 'Name' in ContactColumns enum", "Name"));
case ContactColumns.Street:
return(translator.Get("Enum.ContactColumns.Street", "Value 'Street' in ContactColumns enum", "Street"));
case ContactColumns.Place:
return(translator.Get("Enum.ContactColumns.Place", "Value 'Place' in ContactColumns enum", "Place"));
case ContactColumns.State:
return(translator.Get("Enum.ContactColumns.State", "Value 'State' in ContactColumns enum", "State"));
case ContactColumns.Mail:
return(translator.Get("Enum.ContactColumns.Mail", "Value 'Mail' in ContactColumns enum", "Mail"));
case ContactColumns.Phone:
return(translator.Get("Enum.ContactColumns.Phone", "Value 'Phone' in ContactColumns enum", "Phone"));
case ContactColumns.Subscriptions:
return(translator.Get("Enum.ContactColumns.Subscriptions", "Value 'Subscriptions' in ContactColumns enum", "Subscriptions"));
case ContactColumns.Tags:
return(translator.Get("Enum.ContactColumns.Tags", "Value 'Tags' in ContactColumns enum", "Tags"));
default:
throw new NotSupportedException();
}
}
public new DataTable Suppliers(ContactColumns clsContactColumns, long SequenceNoStart, System.Data.SqlClient.SortOrder SequenceSortOrder, ContactColumns SearchColumns, string SearchKey, Int32 Limit, bool HasCreditOnly, string SortField, System.Data.SqlClient.SortOrder SortOrder)
{
return(null);
}
private void LoadContactData(System.Data.SqlClient.SortOrder SequenceSortOrder)
{
try
{
tblLayout.Controls.Clear();
Int64 intSequenceNoStart = 0;
if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending)
{
try { intSequenceNoStart = long.Parse(cmdTableLeft.Tag.ToString()); }
catch { }
}
else
{
try { intSequenceNoStart = long.Parse(cmdTableRight.Tag.ToString()); }
catch { }
}
// Sep 24, 2014 put an override if cmdSubGroupLeft.Tag = 0
// always do an asceding coz its already the end.
if (intSequenceNoStart < Constants.C_RESTOPLUS_MAX_TABLES)
{
intSequenceNoStart = 0; //reset to 0 if it's 1
}
if (intSequenceNoStart == 0)
{
SequenceSortOrder = System.Data.SqlClient.SortOrder.Ascending;
}
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactCode = true;
clsContactColumns.LastCheckInDate = true;
ContactColumns clsSearchColumns = new ContactColumns();
Contacts clsContact = new Contacts();
System.Data.DataTable dtContact;
if (ContactGroupCategory == Data.ContactGroupCategory.TABLES)
{
dtContact = clsContact.Tables(clsContactColumns, intSequenceNoStart, SequenceSortOrder, clsSearchColumns, string.Empty, SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending ? Constants.C_RESTOPLUS_MAX_TABLES : Constants.C_RESTOPLUS_MAX_TABLES + 1, false, "SequenceNo", SequenceSortOrder);
}
else
{
dtContact = clsContact.Customers(clsContactColumns, intSequenceNoStart, SequenceSortOrder, clsSearchColumns, string.Empty, SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending ? Constants.C_RESTOPLUS_MAX_TABLES : Constants.C_RESTOPLUS_MAX_TABLES + 1, false, "SequenceNo", SequenceSortOrder);
}
// re-order the products by sequence no
if (dtContact.Rows.Count > 0)
{
System.Data.DataView dv = dtContact.DefaultView;
dv.Sort = "SequenceNo";
dtContact = dv.ToTable();
}
int iRow = 0;
int iCol = 0;
int iCtr = 1;
Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(clsContact.Connection, clsContact.Transaction);
Data.SalesTransactionDetails clsSalesTransactionDetails = new Data.SalesTransactionDetails();
Data.MergeTable clsMergeTable = new Data.MergeTable(clsContact.Connection, clsContact.Transaction);
Data.MergeTableDetails clsMergeTableDetails = new Data.MergeTableDetails();
if (dtContact.Rows.Count == 0)
{
cmdTableLeft.Tag = "0".ToString(); // reset the sequenceno to 0 if no record
cmdTableRight.Tag = "0".ToString(); // reset the sequenceno to 0 if no record
}
foreach (System.Data.DataRow dr in dtContact.Rows)
{
//if (iCol == 5) { iCol = 0; iRow++; }
#region Sequence # Counter
if (iCtr > Constants.C_RESTOPLUS_MAX_TABLES)
{
break;
}
if (iCtr == 1)
{
cmdTableLeft.Tag = dr[Data.ContactColumnNames.SequenceNo].ToString();
}
if (iCtr >= 1 && dtContact.Rows.Count > Constants.C_RESTOPLUS_MAX_TABLES)
{
cmdTableRight.Tag = dr[Data.ContactColumnNames.SequenceNo].ToString();
}
#endregion
ProductButton cmdTable = new ProductButton();
cmdTable.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
cmdTable.BackColor = System.Drawing.Color.Red;
cmdTable.Dock = System.Windows.Forms.DockStyle.Fill;
cmdTable.FlatAppearance.BorderColor = System.Drawing.Color.Gold;
cmdTable.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
cmdTable.ForeColor = System.Drawing.SystemColors.ControlText;
cmdTable.GradientBottom = System.Drawing.Color.DarkRed;
cmdTable.GradientTop = System.Drawing.Color.Red;
cmdTable.ImageAlign = System.Drawing.ContentAlignment.TopCenter;
cmdTable.Location = new System.Drawing.Point(3, 3);
cmdTable.Size = new System.Drawing.Size(245, 90);
cmdTable.TabIndex = 118;
cmdTable.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
cmdTable.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
cmdTable.UseVisualStyleBackColor = false;
cmdTable.Name = "cmdTable" + iCtr.ToString();
cmdTable.Text = dr[Data.ContactColumnNames.ContactCode].ToString();
cmdTable.Tag = dr[Data.ContactColumnNames.ContactID].ToString();
cmdTable.Click += new System.EventHandler(cmdTable_Click);
if (DateTime.Parse(dr[Data.ContactColumnNames.LastCheckInDate].ToString()) != Constants.C_DATE_MIN_VALUE)
{
TimeSpan iLapse = DateTime.Now - DateTime.Parse(dr[Data.ContactColumnNames.LastCheckInDate].ToString());
Label lblLastCheckInDate = new System.Windows.Forms.Label();
lblLastCheckInDate.AutoSize = true;
lblLastCheckInDate.BackColor = System.Drawing.Color.Transparent;
lblLastCheckInDate.Font = new System.Drawing.Font("Tahoma", 7.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lblLastCheckInDate.ForeColor = System.Drawing.Color.Blue;
lblLastCheckInDate.Location = new System.Drawing.Point(5, 5);
lblLastCheckInDate.Name = "lblLastCheckInDate" + iCtr.ToString();
lblLastCheckInDate.TabIndex = 1;
lblLastCheckInDate.Text = "";
lblLastCheckInDate.Text = "CheckIn: " + DateTime.Parse(dr[Data.ContactColumnNames.LastCheckInDate].ToString()).ToString("dd-MMM hh:mm tt") + " [" + iLapse.Hours.ToString("0#") + "hrs " + iLapse.Minutes.ToString("0#") + "mins]";
cmdTable.Controls.Add(lblLastCheckInDate);
}
string stTransactionNo = clsSalesTransactions.getSuspendedTransactionNo(long.Parse(dr[Data.ContactColumnNames.ContactID].ToString()), mclsTerminalDetails.TerminalNo, mclsTerminalDetails.BranchID);
if (stTransactionNo != string.Empty)
{
clsSalesTransactionDetails = clsSalesTransactions.Details(stTransactionNo, mclsTerminalDetails.TerminalNo, mclsTerminalDetails.BranchID);
cmdTable.Text = dr[Data.ContactColumnNames.ContactCode].ToString();
decimal decAmountDue = Convert.ToDecimal(clsSalesTransactionDetails.SubTotal + clsSalesTransactionDetails.Charge - clsSalesTransactionDetails.Discount);
cmdTable.Text += Environment.NewLine + Environment.NewLine + "Amount Due:" + decAmountDue.ToString("#,###.#0");
Label lblNoOfPax = new System.Windows.Forms.Label();
lblNoOfPax.AutoSize = true;
lblNoOfPax.BackColor = System.Drawing.Color.Transparent;
lblNoOfPax.Font = new System.Drawing.Font("Tahoma", 7.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lblNoOfPax.ForeColor = System.Drawing.Color.White;
lblNoOfPax.Location = new System.Drawing.Point(210, 75);
lblNoOfPax.Name = "lblNoOfPax" + iCtr.ToString();
lblNoOfPax.TabIndex = 1;
lblNoOfPax.Text = "";
lblNoOfPax.Text = clsSalesTransactionDetails.PaxNo.ToString() + "Pax";
cmdTable.Controls.Add(lblNoOfPax);
// Jan 31, 2015 : Lemu
// Added disabling of Suspended Transactions.
// Put the SuspendedOpen Status to in LoadTransaction
if (mboShowAvailableTableOnly || clsSalesTransactionDetails.TransactionStatus == TransactionStatus.SuspendedOpen)
{
cmdTable.BackColor = System.Drawing.Color.DarkGray;
cmdTable.GradientBottom = System.Drawing.Color.DarkGray;
cmdTable.GradientTop = System.Drawing.Color.DarkGray;
cmdTable.Enabled = false;
if (clsSalesTransactionDetails.TransactionStatus == TransactionStatus.SuspendedOpen)
{
cmdTable.BackColor = System.Drawing.Color.Gray;
cmdTable.GradientBottom = System.Drawing.Color.Gray;
cmdTable.GradientTop = System.Drawing.Color.Gray;
cmdTable.Enabled = true;
cmdTable.Text += Environment.NewLine + "(open in other terminal)";
}
}
else
{
cmdTable.BackColor = System.Drawing.Color.DarkBlue;
cmdTable.GradientBottom = System.Drawing.Color.DarkBlue;
cmdTable.GradientTop = System.Drawing.Color.LightBlue;
}
}
Label lblMerge = new System.Windows.Forms.Label();
lblMerge.AutoSize = true;
lblMerge.BackColor = System.Drawing.Color.Transparent;
lblMerge.Font = new System.Drawing.Font("Tahoma", 7.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lblMerge.ForeColor = System.Drawing.Color.White;
lblMerge.Location = new System.Drawing.Point(5, 75);
lblMerge.Name = "lblMerge" + iCtr.ToString();
lblMerge.TabIndex = 1;
lblMerge.Text = "Merged";
lblMerge.Visible = false;
cmdTable.Controls.Add(lblMerge);
clsMergeTableDetails = clsMergeTable.Details(dr[Data.ContactColumnNames.ContactCode].ToString());
if (clsMergeTableDetails.ChildTableCode == dr[Data.ContactColumnNames.ContactCode].ToString() &&
clsMergeTableDetails.MainTableCode != dr[Data.ContactColumnNames.ContactCode].ToString())
{
cmdTable.BackColor = System.Drawing.Color.DarkGray;
cmdTable.GradientBottom = System.Drawing.Color.DarkGray;
cmdTable.GradientTop = System.Drawing.Color.LightGray;
cmdTable.Enabled = false;
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Visible = true;
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Text = "Merged to " + clsMergeTableDetails.MainTableCode;
}
tblLayout.Controls.Add(cmdTable, iCol, iRow);
iCol++; iCtr++;
}
clsContact.CommitAndDispose();
}
catch (IndexOutOfRangeException) {}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadList()
{
Contacts clsContact = new Contacts();
DataClass clsDataClass = new DataClass();
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactCode = true;
clsContactColumns.ContactName = true;
//clsContactColumns.ContactGroupID = true;
//clsContactColumns.ContactGroupName = true;
//clsContactColumns.ModeOfTerms = true;
//clsContactColumns.Terms = true;
//clsContactColumns.Address = true;
//clsContactColumns.BusinessName = true;
//clsContactColumns.TelephoneNo = true;
//clsContactColumns.Remarks = true;
//clsContactColumns.Debit = true;
//clsContactColumns.Credit = true;
//clsContactColumns.CreditLimit = true;
//clsContactColumns.IsCreditAllowed = true;
//clsContactColumns.DateCreated = true;
//clsContactColumns.Deleted = true;
//clsContactColumns.DepartmentID = true;
//clsContactColumns.DepartmentName = true;
//clsContactColumns.PositionID = true;
//clsContactColumns.PositionName = true;
clsContactColumns.RewardDetails = true;
//clsContactColumns.CreditDetails = true;
ContactColumns clsSearchColumns = new ContactColumns();
clsSearchColumns.ContactCode = true;
clsSearchColumns.ContactName = true;
clsSearchColumns.RewardDetails = true;
string SortField = "ContactID";
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);
}
string SearchKey = string.Empty;
if (Request.QueryString["Search"] != null)
{
SearchKey = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID);
}
PageData.DataSource = clsContact.Customers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsSearchColumns, SearchKey, 0, false, null, System.Data.SqlClient.SortOrder.Ascending).DefaultView;
clsContact.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;
}
private void LoadList()
{
Contacts clsContact = new Contacts();
DataClass clsDataClass = new DataClass();
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactCode = true;
clsContactColumns.ContactName = true;
clsContactColumns.CreditDetails = true;
ContactColumns clsSearchColumns = new ContactColumns();
clsSearchColumns.ContactCode = true;
clsSearchColumns.ContactName = true;
clsSearchColumns.CreditDetails = true;
string SortField = "ContactID";
if (Request.QueryString["sortfield"] != null)
{
SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID);
}
System.Data.SqlClient.SortOrder sortoption = System.Data.SqlClient.SortOrder.Ascending;
if (Request.QueryString["sortoption"] != null)
{
sortoption = (System.Data.SqlClient.SortOrder)Enum.Parse(typeof(System.Data.SqlClient.SortOrder), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true);
}
string SearchKey = string.Empty;
if (Request.QueryString["Search"] != null)
{
SearchKey = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID);
txtSearch.Text = SearchKey;
}
string strSearch = txtSearch.Text.Trim();
DateTime dteExpiryDateFrom = DateTime.TryParse(txtExpiryDateFrom.Text, out dteExpiryDateFrom) ? dteExpiryDateFrom : DateTime.MinValue;
DateTime dteExpiryDateTo = DateTime.TryParse(txtExpiryDateTo.Text, out dteExpiryDateTo) ? dteExpiryDateTo : DateTime.MinValue;
CreditCardStatus enumCreditCardStatus = (CreditCardStatus)Enum.Parse(typeof(CreditCardStatus), cboCreditCardStatus.SelectedItem.Value);
PageData.DataSource = clsContact.CustomersWithCredits(clsContactColumns, LastNameFrom: txtLastNameFrom.Text, LastNameTo: txtLastNameTo.Text, CustomerCode_CreditCardNo: strSearch, CreditCardExpiryDateFrom: dteExpiryDateFrom, CreditCardExpiryDateTo: dteExpiryDateTo, CreditCardStatus: enumCreditCardStatus, CreditCardTypeID: Int32.Parse(cboCreditType.SelectedItem.Value), CheckCustomersGuarantor: true, SortField: SortField, SortOrder: sortoption).DefaultView;
clsContact.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;
}
private void LoadList()
{
Contacts clsContact = new Contacts();
DataClass clsDataClass = new DataClass();
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactCode = true;
clsContactColumns.ContactName = true;
clsContactColumns.RewardDetails = true;
ContactColumns clsSearchColumns = new ContactColumns();
clsSearchColumns.ContactCode = true;
clsSearchColumns.ContactName = true;
clsSearchColumns.RewardDetails = true;
string SortField = "ContactID";
if (Request.QueryString["sortfield"] != null)
{
SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID);
}
System.Data.SqlClient.SortOrder sortoption = System.Data.SqlClient.SortOrder.Ascending;
if (Request.QueryString["sortoption"] != null)
{
sortoption = (System.Data.SqlClient.SortOrder)Enum.Parse(typeof(System.Data.SqlClient.SortOrder), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true);
}
string SearchKey = string.Empty;
if (Request.QueryString["Search"] != null)
{
SearchKey = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID);
txtSearch.Text = SearchKey;
}
string strSearch = txtSearch.Text.Trim();
Constants.DateSelectionString BirthDate = (Constants.DateSelectionString)Enum.Parse(typeof(Constants.DateSelectionString), cboBirthDate.SelectedItem.Value);
DateTime dteRewardExpiryDateFrom = DateTime.TryParse(txtRewardExpiryDateFrom.Text, out dteRewardExpiryDateFrom) ? dteRewardExpiryDateFrom : DateTime.MinValue;
DateTime dteRewardExpiryDateTo = DateTime.TryParse(txtRewardExpiryDateTo.Text, out dteRewardExpiryDateTo) ? dteRewardExpiryDateTo : DateTime.MinValue;
Int16 intRewardCardStatus = (cboRewardCardStatus.SelectedItem.Value == Constants.ALL) ? Int16.Parse("-1") : Int16.Parse(cboRewardCardStatus.SelectedItem.Value);
PageData.DataSource = clsContact.CustomersWithRewards(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, 0, strSearch, dteRewardExpiryDateFrom, dteRewardExpiryDateTo, BirthDate, intRewardCardStatus, SortField, sortoption).DefaultView;
clsContact.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;
ImageButton imgItemEdit = (ImageButton)e.Item.FindControl("imgItemEdit");
ImageButton imgPrintBilling = (ImageButton)e.Item.FindControl("imgPrintBilling");
HtmlInputCheckBox chkList = (HtmlInputCheckBox)e.Item.FindControl("chkList");
chkList.Value = dr["ContactID"].ToString();
if (chkList.Value == "1" || chkList.Value == "2")
{
chkList.Attributes.Add("disabled", "false");
imgItemEdit.Enabled = false; imgItemEdit.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif";
imgPrintBilling.Enabled = false;; imgPrintBilling.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif";
}
else
{
imgItemEdit.Enabled = cmdEdit.Visible; if (!imgItemEdit.Enabled)
{
imgItemEdit.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif";
}
if (DateTime.Parse(dr["LastBillingDate"].ToString()) != DateTime.MinValue && DateTime.Parse(dr["LastBillingDate"].ToString()) != Constants.C_DATE_MIN_VALUE)
{
imgPrintBilling.Enabled = imgPrintBilling.Visible; if (!imgPrintBilling.Enabled)
{
imgPrintBilling.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/print.gif";
}
imgPrintBilling.ToolTip = DateTime.Parse(dr["LastBillingDate"].ToString()).ToString("yyyy-MMM-dd");
}
else
{
imgPrintBilling.Enabled = false;; imgPrintBilling.ImageUrl = Constants.ROOT_DIRECTORY + "/_layouts/images/blank.gif";
imgPrintBilling.ToolTip = Constants.C_DATE_MIN_VALUE_STRING;
}
}
HyperLink lnkContactCode = (HyperLink)e.Item.FindControl("lnkContactCode");
lnkContactCode.Text = dr["ContactCode"].ToString();
lnkContactCode.NavigateUrl = "Default.aspx?task=" + Common.Encrypt("details", Session.SessionID) + "&id=" + Common.Encrypt(chkList.Value, Session.SessionID);
HyperLink lnkContactName = (HyperLink)e.Item.FindControl("lnkContactName");
lnkContactName.Text = dr["ContactName"].ToString();
lnkContactName.NavigateUrl = "Default.aspx?task=" + Common.Encrypt("details", Session.SessionID) + "&id=" + Common.Encrypt(chkList.Value, Session.SessionID);
Label lblCreditType = (Label)e.Item.FindControl("lblCreditType");
lblCreditType.Text = dr["CardTypeCode"].ToString().ToString();
//Label lblCreditCardNo = (Label)e.Item.FindControl("lblCreditCardNo");
//lblCreditCardNo.Text = dr["CreditCardNo"].ToString();
//Label lblCreditCardStatus = (Label)e.Item.FindControl("lblCreditCardStatus");
//lblCreditCardStatus.Text = Enum.Parse(typeof(CreditCardStatus), dr["CreditCardStatus"].ToString()).ToString();
//Label lblCreditActive = (Label)e.Item.FindControl("lblCreditActive");
//lblCreditActive.Text = Data.Contacts.checkCreditActive((CreditCardStatus)Enum.Parse(typeof(CreditCardStatus), dr["CreditCardStatus"].ToString())) ? "Active" : "InActive";
//Label lblExpiryDate = (Label)e.Item.FindControl("lblExpiryDate");
//lblExpiryDate.Text = Convert.ToDateTime(dr["ExpiryDate"].ToString()).ToString("dd-MMM-yyyy");
//decimal decCreditLimit = Convert.ToDecimal(dr["CreditLimit"].ToString());
//decimal decCredit = Convert.ToDecimal(dr["Credit"].ToString());
//decimal decAvailableCredit = decCreditLimit - decCredit;
//Label lblCreditLimit = (Label)e.Item.FindControl("lblCreditLimit");
//lblCreditLimit.Text = decCreditLimit.ToString("#,##0.#");
//Label lblCredit = (Label)e.Item.FindControl("lblCredit");
//lblCredit.Text = decCredit.ToString("#,##0.#");
//Label lblAvailableCredit = (Label)e.Item.FindControl("lblAvailableCredit");
//lblAvailableCredit.Text = decAvailableCredit.ToString("#,##0.#");
//Label lblTotalPurchases = (Label)e.Item.FindControl("lblTotalPurchases");
//lblTotalPurchases.Text = Convert.ToDecimal(dr["TotalPurchases"].ToString()).ToString("#,##0.#");
//Label lblLastBillingDate = (Label)e.Item.FindControl("lblLastBillingDate");
//lblLastBillingDate.Text = Convert.ToDateTime(dr["LastBillingDate"].ToString()).ToString("dd-MMM-yyyy");
DataClass clsDataClass = new DataClass();
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactCode = true;
clsContactColumns.ContactName = true;
clsContactColumns.CreditDetails = true;
ContactColumns clsSearchColumns = new ContactColumns();
clsSearchColumns.ContactCode = true;
clsSearchColumns.ContactName = true;
clsSearchColumns.CreditDetails = true;
Int64 iGuarantorID = Int64.Parse(dr["ContactID"].ToString());
DataList lstItemCustomer = (DataList)e.Item.FindControl("lstItemCustomer");
if (iGuarantorID != 0)
{
Contacts clsContact = new Contacts();
System.Data.DataTable dt = clsContact.CustomersWithCredits(clsContactColumns, GuarantorID: iGuarantorID, SortField: "CreditCardNo");
clsContact.CommitAndDispose();
lstItemCustomer.DataSource = dt.DefaultView;
lstItemCustomer.DataBind();
lstItemCustomer.Visible = true;
}
else
{
lstItemCustomer.Visible = false;
}
}
}
private void LoadList()
{
Contacts clsContact = new Contacts();
DataClass clsDataClass = new DataClass();
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactCode = true;
clsContactColumns.ContactName = true;
clsContactColumns.RewardDetails = true;
ContactColumns clsSearchColumns = new ContactColumns();
clsSearchColumns.ContactCode = true;
clsSearchColumns.ContactName = true;
clsSearchColumns.RewardDetails = true;
string SortField = "ContactID";
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);
}
string SearchKey = txtSearch.Text;
string ContactGroupCode = "";
ContactGroupCode = cboGroup.SelectedIndex == 0 ? "" : cboGroup.SelectedItem.Text;
DateTime dteBirthDateFrom = Constants.C_DATE_MIN_VALUE;
DateTime dteBirthDateTo = Constants.C_DATE_MIN_VALUE;
DateTime dteAnniversaryDateFrom = Constants.C_DATE_MIN_VALUE;
DateTime dteAnniversaryDateTo = Constants.C_DATE_MIN_VALUE;
dteBirthDateFrom = DateTime.TryParse(txtBirthStartDate.Text, out dteBirthDateFrom) ? dteBirthDateFrom : Constants.C_DATE_MIN_VALUE;
dteBirthDateTo = DateTime.TryParse(txtBirthEndDate.Text, out dteBirthDateTo) ? dteBirthDateTo : Constants.C_DATE_MIN_VALUE;
dteAnniversaryDateFrom = DateTime.TryParse(txtAnnivStartDate.Text, out dteAnniversaryDateFrom) ? dteAnniversaryDateFrom : Constants.C_DATE_MIN_VALUE;
dteAnniversaryDateTo = DateTime.TryParse(txtAnnivEndDate.Text, out dteAnniversaryDateTo) ? dteAnniversaryDateTo : Constants.C_DATE_MIN_VALUE;
//PageData.DataSource = clsContact.Customers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsSearchColumns, SearchKey, 0, false, null, System.Data.SqlClient.SortOrder.Ascending).DefaultView;
PageData.DataSource = clsContact.ListAsDataTable(ContactGroupCategory.CUSTOMER, ContactCode: SearchKey, ContactName: SearchKey, ContactGroupCode: ContactGroupCode, SortField: SortField, SortOrder: sortoption, BirthDateFrom: dteBirthDateFrom.ToString("yyyy-MM-dd"), BirthDateTo: dteBirthDateTo.ToString("yyyy-MM-dd"), AnniversaryDateFrom: dteAnniversaryDateFrom.ToString("yyyy-MM-dd"), AnniversaryDateTo: dteAnniversaryDateTo.ToString("yyyy-MM-dd"), BirthMonth: cboBirthMonth.SelectedIndex, AnniversaryMonth: cboAnniversaryMonth.SelectedIndex).DefaultView;
//clsContact.CustomersDataTable(SearchKey, SortField: SortField, SortOrder: sortoption).DefaultView;
clsContact.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 NamedIntViewModel(Translator translator, ContactColumns columns, bool selected)
: this((int)columns, columns.TranslateFlag(translator), selected)
{
}
