private void LoadOptions()
{
Contacts clsContact = new Contacts();
cboContact.DataTextField = "ContactName";
cboContact.DataValueField = "ContactID";
cboContact.DataSource = clsContact.CustomersDataTable(txtContactCode.Text).DefaultView;
cboContact.DataBind();
cboContact.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboContact.Items.Insert(1, new ListItem(Constants.PLUSCARDMEMBERS, Constants.PLUSCARDMEMBERSID_STRING));
cboContact.Items.Insert(2, new ListItem(Constants.ICCARDMEMBERS, Constants.ICCARDMEMBERSID_STRING));
cboContact.Items.Insert(3, new ListItem(Constants.GCCARDMEMBERS, Constants.GCCARDMEMBERSID_STRING));
cboContact.SelectedIndex = 0;
ProductGroup clsProductGroup = new ProductGroup(clsContact.Connection, clsContact.Transaction);
cboProductGroup.DataTextField = "ProductGroupName";
cboProductGroup.DataValueField = "ProductGroupID";
cboProductGroup.DataSource = clsProductGroup.ListAsDataTable(txtProductGroupCode.Text, "ProductGroupName").DefaultView;
cboProductGroup.DataBind();
cboProductGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboProductGroup.SelectedIndex = 0;
clsContact.CommitAndDispose();
cboProductGroup_SelectedIndexChanged(null, System.EventArgs.Empty);
txtQuantity.Text = "1";
txtPromoValue.Text = "0";
}
private void LoadOptions()
{
Contacts clsContact = new Contacts();
cboContact.DataTextField = "ContactName";
cboContact.DataValueField = "ContactID";
cboContact.DataSource = clsContact.SuppliersAsDataTable(txtContactCode.Text).DefaultView;
cboContact.DataBind();
cboContact.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboContact.SelectedIndex = 0;
ProductGroup clsProductGroup = new ProductGroup(clsContact.Connection, clsContact.Transaction);
cboProductGroup.DataTextField = "ProductGroupName";
cboProductGroup.DataValueField = "ProductGroupID";
cboProductGroup.DataSource = clsProductGroup.ListAsDataTable(txtProductGroupCode.Text, "ProductGroupName").DefaultView;
cboProductGroup.DataBind();
cboProductGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboProductGroup.SelectedIndex = 0;
clsContact.CommitAndDispose();
cboProductGroup_SelectedIndexChanged(null, System.EventArgs.Empty);
txtPromoBySupplierValue.Text = "0";
txtCouponRemarks.Text = "{DateNow}: Congratulations you qualified for our annual raffle promo brought to you by HOUSEWARE PLAZA SUPERSTORE and {SupplierName}.";
txtCouponRemarks.Text += Environment.NewLine + Environment.NewLine + "Please proceed to our customer service for more info.";
txtCouponRemarks.Text += Environment.NewLine + Environment.NewLine + "Products: {ProductGroup}";
txtCouponRemarks.Text += Environment.NewLine + Environment.NewLine + "Total Amount Puchased: {Amount}";
txtCouponRemarks.Text += Environment.NewLine + "OR No: {ORNo}";
txtCouponRemarks.Text += Environment.NewLine + "Customer Name: {CustomerName}";
txtCouponRemarks.Text += Environment.NewLine + "Check Ctr: {CheckCounter}";
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
Contacts clsContact = new Contacts();
cboContactCode.DataTextField = "ContactCode";
cboContactCode.DataValueField = "ContactCode";
cboContactCode.DataSource = clsContact.ListAsDataTable("ContactCode",SortOption.Ascending);
cboContactCode.DataBind();
cboContactCode.Items.Add( new ListItem("All Codes","0"));
cboContactCode.SelectedIndex = cboContactCode.Items.Count - 1;
cboContactName.DataTextField = "ContactName";
cboContactName.DataValueField = "ContactName";
cboContactName.DataSource = clsContact.ListAsDataTable("ContactName",SortOption.Ascending);
cboContactName.DataBind();
cboContactName.Items.Add( new ListItem("All Contacts","0"));
cboContactName.SelectedIndex = cboContactName.Items.Count - 1;
clsContact.CommitAndDispose();
ContactGroups clsContactGroup = new ContactGroups();
cboGroup.DataTextField = "ContactGroupName";
cboGroup.DataValueField = "ContactGroupID";
cboGroup.DataSource = clsDataClass.DataReaderToDataTable(clsContactGroup.List("ContactGroupName",SortOption.Ascending));
cboGroup.DataBind();
cboGroup.Items.Add( new ListItem("All Contact Groups","0"));
cboGroup.SelectedIndex = cboGroup.Items.Count - 1;
clsContactGroup.CommitAndDispose();
cboDeleted.SelectedIndex = cboDeleted.Items.Count - 1;
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
Contacts clsContact = new Contacts();
cboContactCode.DataTextField = "ContactName";
cboContactCode.DataValueField = "ContactID";
cboContactCode.DataSource = clsContact.AgentsAsDataTable(null, 0, "ContactCode",SortOption.Ascending);
cboContactCode.DataBind();
cboContactCode.Items.Add(new ListItem("Summarized", "0"));
cboContactCode.SelectedIndex = cboContactCode.Items.Count - 1;
cboReportType.Items.Add(new ListItem("Summarized Report", "0"));
cboReportType.Items.Add(new ListItem("Summarized With Details", "1"));
cboReportType.SelectedIndex = cboReportType.Items.Count - 1;
Positions clsPosition = new Positions(clsContact.Connection, clsContact.Transaction);
cboPosition.DataTextField = "PositionName";
cboPosition.DataValueField = "PositionID";
cboPosition.DataSource = clsPosition.ListAsDataTable(null, SortOption.Ascending, 0);
cboPosition.DataBind();
cboPosition.Items.Add(new ListItem(Positions.DEFAULT_ALL_POSITIONS, "0"));
cboPosition.SelectedIndex = cboPosition.Items.Count - 1;
Department clsDepartment = new Department(clsContact.Connection, clsContact.Transaction);
cboDepartment.DataTextField = "DepartmentName";
cboDepartment.DataValueField = "DepartmentID";
cboDepartment.DataSource = clsDepartment.ListAsDataTable();
cboDepartment.DataBind();
cboDepartment.Items.Add(new ListItem(Department.DEFAULT_ALL_DEPARTMENTS, "0"));
cboDepartment.SelectedIndex = cboDepartment.Items.Count - 1;
clsContact.CommitAndDispose();
txtStartTransactionDate.Text = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
txtEndTransactionDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
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 LoadOptions()
{
Contacts clsContact = new Contacts();
cboSupplier.DataTextField = "ContactName";
cboSupplier.DataValueField = "ContactID";
cboSupplier.DataSource = clsContact.SuppliersAsDataTable(null, 0, "ContactName", SortOption.Ascending).DefaultView;
cboSupplier.DataBind();
Branch clsBranch = new Branch(clsContact.Connection, clsContact.Transaction);
cboBranch.DataTextField = "BranchCode";
cboBranch.DataValueField = "BranchID";
cboBranch.DataSource = clsBranch.ListAsDataTable().DefaultView;
cboBranch.DataBind();
clsContact.CommitAndDispose();
cboSupplier.SelectedIndex = 0;
cboSupplier_SelectedIndexChanged(null, null);
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(cboBranch.Items.FindByValue(Constants.BRANCH_ID_MAIN.ToString()));
cboBranch_SelectedIndexChanged(null, null);
NewTransaction();
}
private void LoadRecord()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
Contacts clsContact = new Contacts();
ContactDetails clsDetails = clsContact.Details(iID);
clsContact.CommitAndDispose();
lblContactID.Text = clsDetails.ContactID.ToString();
txtContactCode.Text = clsDetails.ContactCode;
txtContactName.Text = clsDetails.ContactName;
cboGroup.SelectedIndex = cboGroup.Items.IndexOf(cboGroup.Items.FindByValue(clsDetails.ContactGroupID.ToString()));
cboModeOfTerms.SelectedIndex = cboModeOfTerms.Items.IndexOf(cboModeOfTerms.Items.FindByValue(clsDetails.ModeOfTerms.ToString("d")));
txtTerms.Text = clsDetails.Terms.ToString("#,##0");
txtAddress.Text = clsDetails.Address;
txtBusinessName.Text = clsDetails.BusinessName;
txtTelephoneNo.Text = clsDetails.TelephoneNo;
txtRemarks.Text = clsDetails.Remarks;
txtDebit.Text = clsDetails.Debit.ToString("#,##0.#0");
txtCredit.Text = clsDetails.Credit.ToString("#,##0.#0");
clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked;
//if (clsDetails.IsCreditAllowed == 0)
// chkIsCreditAllowed.Checked = false;
//else
// chkIsCreditAllowed.Checked = true;
txtCreditLimit.Text = clsDetails.CreditLimit.ToString("#,##0.#0");
cboDepartment.SelectedIndex = cboDepartment.Items.IndexOf(cboDepartment.Items.FindByValue(clsDetails.DepartmentID.ToString()));
cboPosition.SelectedIndex = cboPosition.Items.IndexOf(cboPosition.Items.FindByValue(clsDetails.PositionID.ToString()));
}
private void LoadOptions()
{
Contacts clsContact = new Contacts();
cboSupplier.DataTextField = "ContactName";
cboSupplier.DataValueField = "ContactID";
cboSupplier.DataSource = clsContact.SuppliersAsDataTable(null, 0, "ContactName", SortOption.Ascending).DefaultView;
cboSupplier.DataBind();
bool boIsePurchaseOrder = bool.TryParse(lblIsePurchaseOrder.Text, out boIsePurchaseOrder) ? boIsePurchaseOrder : false;
Branch clsBranch = new Branch(clsContact.Connection, clsContact.Transaction);
cboBranch.DataTextField = "BranchCode";
cboBranch.DataValueField = "BranchID";
cboBranch.DataSource = clsBranch.ListAsDataTable(OnlyIncludeIneSales: boIsePurchaseOrder).DefaultView;
cboBranch.DataBind();
clsContact.CommitAndDispose();
cboSupplier.SelectedIndex = 0;
cboSupplier_SelectedIndexChanged(null, null);
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(cboBranch.Items.FindByValue(Constants.BRANCH_ID_MAIN.ToString()));
cboBranch_SelectedIndexChanged(null, null);
lblIsePurchaseOrder.Text = boIsePurchaseOrder ? "true" : "false";
NewTransaction();
}
private bool Delete()
{
bool boRetValue = false;
string stIDs = "";
foreach(DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList");
if (chkList!=null)
{
if (chkList.Checked == true)
{
stIDs += chkList.Value + ",";
boRetValue = true;
}
}
}
if (boRetValue)
{
Contacts clsContact = new Contacts();
clsContact.Delete( stIDs.Substring(0,stIDs.Length-1));
clsContact.CommitAndDispose();
}
return boRetValue;
}
protected void lstItem_ItemCommand(object sender, DataListCommandEventArgs e)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)e.Item.FindControl("chkList");
string stParam = string.Empty;
switch (e.CommandName)
{
case "imgItemDelete":
Contacts clsContact = new Contacts();
clsContact.Delete(chkList.Value);
clsContact.CommitAndDispose();
LoadList();
break;
case "imgItemEdit":
stParam = "?task=" + Common.Encrypt("edit", Session.SessionID) + "&id=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect("Default.aspx" + stParam);
break;
}
}
private void SaveRecord()
{
Int64 iContactID = Int64.Parse(cboContact.SelectedItem.Value);
Int16 iGuarantorID = Int16.Parse(cboGuarantor.SelectedItem.Value);
string javaScript;
if (iContactID == 0)
{
javaScript = "window.alert('Please select a customer to change the guarantor.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
if (iGuarantorID == 0)
{
javaScript = "window.alert('Please select a valid guarantor.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
Contacts clsContacts = new Contacts();
clsContacts.UpdateGuarantor(iContactID, iGuarantorID, clsAccessUserDetails.Name);
clsContacts.CommitAndDispose();
cboContact_SelectedIndexChanged(null, null);
javaScript = "window.alert('Guarantor for " + cboContact.SelectedItem.Text + " has been updated.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
}
private Int64 SaveRecord()
{
ContactDetails clsDetails = new ContactDetails();
clsDetails.ContactCode = txtVendorCode.Text;
clsDetails.ContactName = txtVendorName.Text;
clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboModeOfTerms.SelectedItem.Value);
clsDetails.Terms = Convert.ToInt32(txtTerms.Text);
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtTelephoneNo.Text;
clsDetails.Remarks = txtRemarks.Text;
clsDetails.Debit = Convert.ToDecimal(txtDebit.Text);
clsDetails.Credit = Convert.ToDecimal(txtCredit.Text);
clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked;
//if (chkIsCreditAllowed.Checked == false)
//else
// clsDetails.IsCreditAllowed = 1;
clsDetails.CreditLimit = Convert.ToDecimal(txtCreditLimit.Text);
clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value);
clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value);
// 13Mar2015 : Added for Pharmaceuticals
clsDetails.TINNo = txtTINNo.Text;
clsDetails.LTONo = txtLTONo.Text;
Contacts clsContact = new Contacts();
Int64 id = clsContact.Insert(clsDetails);
clsContact.CommitAndDispose();
return id;
}
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 SaveRecord()
{
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
Contacts clsContact = new Contacts();
ContactDetails clsDetails = new ContactDetails();
clsDetails.ContactID = Convert.ToInt32(lblContactID.Text);
clsDetails.ContactCode = txtContactCode.Text;
clsDetails.ContactName = txtLastName.Text + ", " + txtFirstName.Text + " " + txtMiddleName.Text;
clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboModeOfTerms.SelectedItem.Value);
clsDetails.Terms = Convert.ToInt32(txtTerms.Text);
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtTelephoneNo.Text;
clsDetails.Remarks = txtRemarks.Text;
clsDetails.Debit = Convert.ToDecimal(txtDebit.Text);
clsDetails.Credit = Convert.ToDecimal(txtCredit.Text);
clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked;
clsDetails.CreditLimit = Convert.ToDecimal(txtCreditLimit.Text);
clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value);
clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value);
ContactAddOnDetails clsAddOnDetails = new ContactAddOnDetails();
clsAddOnDetails.ContactID = clsDetails.ContactID;
clsAddOnDetails.Salutation = cboSalutation.SelectedItem.Value;
clsAddOnDetails.FirstName = txtFirstName.Text;
clsAddOnDetails.MiddleName = txtMiddleName.Text;
clsAddOnDetails.LastName = txtLastName.Text;
clsAddOnDetails.SpouseName = "";
DateTime dteBirthDate = Constants.C_DATE_MIN_VALUE;
dteBirthDate = DateTime.TryParse(txtBirthDate.Text, out dteBirthDate) ? dteBirthDate : Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.BirthDate = dteBirthDate;
clsAddOnDetails.SpouseBirthDate = Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.AnniversaryDate = Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.Address1 = txtAddress.Text;
clsAddOnDetails.Address2 = string.Empty;
clsAddOnDetails.City = string.Empty;
clsAddOnDetails.State = string.Empty;
clsAddOnDetails.ZipCode = string.Empty;
clsAddOnDetails.CountryID = Constants.C_DEF_COUNTRY_ID;
clsAddOnDetails.CountryCode = Constants.C_DEF_COUNTRY_CODE;
clsAddOnDetails.BusinessPhoneNo = txtTelephoneNo.Text;
clsAddOnDetails.HomePhoneNo = string.Empty;
clsAddOnDetails.MobileNo = txtMobileNo.Text;
clsAddOnDetails.FaxNo = string.Empty;
clsAddOnDetails.EmailAddress = string.Empty;
clsDetails.AdditionalDetails = clsAddOnDetails;
clsContact.Update(clsDetails);
clsContact.CommitAndDispose();
}
private void SetParameters (ReportDocument Report)
{
ParameterFieldDefinition paramField;
ParameterValues currentValues;
ParameterDiscreteValue discreteParam;
paramField = Report.DataDefinition.ParameterFields["CompanyName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = CompanyDetails.CompanyName;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PrintedBy"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = Session["Name"].ToString();
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
DateTime StartTransactionDate = DateTime.MinValue;
try
{ StartTransactionDate = Convert.ToDateTime(txtStartTransactionDate.Text + " " + txtStartTime.Text); }
catch { }
DateTime EndTransactionDate = DateTime.MinValue;
try
{ EndTransactionDate = Convert.ToDateTime(txtEndTransactionDate.Text + " " + txtEndTime.Text); }
catch { }
paramField = Report.DataDefinition.ParameterFields["StartTransactionDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = StartTransactionDate.ToString("yyyy-MM-dd HH:mm");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["EndTransactionDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = EndTransactionDate.ToString("yyyy-MM-dd HH:mm");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
if (cboContactCode.SelectedItem.Value != "0")
{
Contacts clsContact = new Contacts();
ContactDetails clsContactDetails = clsContact.Details(long.Parse(cboContactCode.SelectedValue));
clsContact.CommitAndDispose();
paramField = Report.DataDefinition.ParameterFields["AgentsName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsContactDetails.ContactName;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["Address"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsContactDetails.Address;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["ContactNo"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsContactDetails.TelephoneNo;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
}
}
protected void grpPriceLevel_OnCheckedChanged(Object sender, EventArgs e)
{
RadioButton rdoPrice = (RadioButton)sender;
DataListItem item = (DataListItem)rdoPrice.NamingContainer;
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
Int64 iContactID = Int64.Parse(chkList.Value);
PriceLevel enumPriceLevel = PriceLevel.SRP;
switch (rdoPrice.ID)
{
case "rdoPrice": enumPriceLevel = PriceLevel.SRP; break;
case "rdoWSPrice": enumPriceLevel = PriceLevel.WSPrice; break;
case "rdoLevel1": enumPriceLevel = PriceLevel.One; break;
case "rdoLevel2": enumPriceLevel = PriceLevel.Two; break;
case "rdoLevel3": enumPriceLevel = PriceLevel.Three; break;
case "rdoLevel4": enumPriceLevel = PriceLevel.Four; break;
case "rdoLevel5": enumPriceLevel = PriceLevel.Five; break;
}
Contacts clsContacts = new Contacts();
clsContacts.UpdatePriceLevel(iContactID, enumPriceLevel);
clsContacts.CommitAndDispose();
}
private void LoadList()
{
Contacts clsContact = new Contacts();
string SortField = "ContactCode";
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 strContactCode = txtContactCode.Text;
string strContactName = txtContactName.Text;
string strContactGroupCode = cboGroup.SelectedItem.Text;
Int16 intModeOfTerms = Int16.Parse(cboModeOfTerms.SelectedItem.Value);
PageData.DataSource = clsContact.ListAsDataTable(ContactGroupCategory.CUSTOMER, ContactCode: strContactCode, ContactName: strContactName, ContactGroupCode: strContactGroupCode, SortField: SortField, SortOrder: sortoption, ModeOfTerms: intModeOfTerms).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 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;
}
}
private void LoadList()
{
Contacts clsContact = new Contacts();
string SortField = "ContactCode";
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); }
if (Request.QueryString["Search"]==null)
{
PageData.DataSource = clsContact.ListAsDataTable(SortField, sortoption).DefaultView;
}
else
{
string SearchKey = Common.Decrypt((string)Request.QueryString["search"],Session.SessionID);
PageData.DataSource = clsContact.SearchAsDataTable(SearchKey, 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;
}
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;
}
protected void imgContactCodeSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Contacts clsContact = new Contacts();
cboContact.DataTextField = "ContactName";
cboContact.DataValueField = "ContactID";
cboContact.DataSource = clsContact.CustomersDataTable(txtContactCode.Text).DefaultView;
cboContact.DataBind();
cboContact.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboContact.Items.Insert(1, new ListItem(Constants.PLUSCARDMEMBERS, Constants.PLUSCARDMEMBERSID_STRING));
cboContact.Items.Insert(2, new ListItem(Constants.ICCARDMEMBERS, Constants.ICCARDMEMBERSID_STRING));
cboContact.Items.Insert(3, new ListItem(Constants.GCCARDMEMBERS, Constants.GCCARDMEMBERSID_STRING));
if (cboContact.Items.Count > 4) cboContact.SelectedIndex = 4; else cboContact.SelectedIndex = 0;
clsContact.CommitAndDispose();
}
private void LoadRecord()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
Contacts clsContact = new Contacts();
ContactDetails clsDetails = clsContact.Details(iID);
clsContact.CommitAndDispose();
lblContactID.Text = clsDetails.ContactID.ToString();
txtContactCode.Text = clsDetails.ContactCode;
txtContactName.Text = clsDetails.ContactName;
cboGroup.SelectedIndex = cboGroup.Items.IndexOf(cboGroup.Items.FindByValue(clsDetails.ContactGroupID.ToString()));
cboModeOfTerms.SelectedIndex = cboModeOfTerms.Items.IndexOf(cboModeOfTerms.Items.FindByValue(clsDetails.ModeOfTerms.ToString("d")));
txtTerms.Text = clsDetails.Terms.ToString("###0");
txtAddress.Text = clsDetails.Address;
txtBusinessName.Text = clsDetails.BusinessName;
txtTelephoneNo.Text = clsDetails.TelephoneNo;
txtRemarks.Text = clsDetails.Remarks;
txtDebit.Text = clsDetails.Debit.ToString("###0.#0");
chkIsCreditAllowed.Checked = clsDetails.IsCreditAllowed;
cboDepartment.SelectedIndex = cboDepartment.Items.IndexOf(cboDepartment.Items.FindByValue(clsDetails.DepartmentID.ToString()));
cboPosition.SelectedIndex = cboPosition.Items.IndexOf(cboPosition.Items.FindByValue(clsDetails.PositionID.ToString()));
txtCreditCardNo.Text = clsDetails.CreditDetails.CreditCardNo;
cboCreditCardType.SelectedIndex = cboCreditCardType.Items.IndexOf(cboCreditCardType.Items.FindByValue(clsDetails.CreditDetails.CardTypeDetails.CardTypeID.ToString()));
txtCreditAwardDate.Text = clsDetails.CreditDetails.CreditAwardDate.ToString("yyyy-MMM-dd");
txtExpiryDate.Text = clsDetails.CreditDetails.ExpiryDate.ToString("yyyy-MMM-dd");
cboCreditCardStatus.SelectedIndex = cboCreditCardStatus.Items.IndexOf(cboCreditCardStatus.Items.FindByValue(clsDetails.CreditDetails.CreditCardStatus.ToString("d")));
lblCreditCardActive.Text = clsDetails.CreditDetails.CreditActive ? "Active" : "InActive (Hold/Suspended)";
txtCreditLimit.Text = clsDetails.CreditLimit.ToString("###0.#0");
txtCredit.Text = clsDetails.Credit.ToString("###0.#0");
txtPaidAmount.Text = "0.00";
txtCurrentBalance.Text = (clsDetails.CreditLimit - clsDetails.Credit).ToString("###0.#0");
lblLastBillingDate.Text = "Last Billing Date:" + clsDetails.CreditDetails.LastBillingDate.ToString("yyyy-MMM-dd");
// 26Oct2014 - add the additional information
cboSalutation.SelectedIndex = cboSalutation.Items.IndexOf(cboSalutation.Items.FindByValue(clsDetails.AdditionalDetails.Salutation));
txtFirstName.Text = clsDetails.AdditionalDetails.FirstName;
txtMiddleName.Text = clsDetails.AdditionalDetails.MiddleName;
txtLastName.Text = clsDetails.AdditionalDetails.LastName;
txtBirthDate.Text = clsDetails.AdditionalDetails.BirthDate.ToString("yyyy-MM-dd");
txtMobileNo.Text = clsDetails.AdditionalDetails.MobileNo;
LoadPurchases(clsDetails.ContactID);
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
Contacts clsContact = new Contacts();
cboCustomer.DataTextField = "ContactName";
cboCustomer.DataValueField = "ContactID";
cboCustomer.DataSource = clsContact.CustomersDataTable(null).DefaultView;
cboCustomer.DataBind();
clsContact.CommitAndDispose();
cboCustomer.SelectedIndex = 0;
cboCustomer_SelectedIndexChanged(null, null);
Branch clsBranch = new Branch();
cboBranch.DataTextField = "BranchCode";
cboBranch.DataValueField = "BranchID";
cboBranch.DataSource = clsBranch.ListAsDataTable().DefaultView;
cboBranch.DataBind();
clsBranch.CommitAndDispose();
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(cboBranch.Items.FindByValue(Constants.BRANCH_ID_MAIN.ToString()));
cboBranch_SelectedIndexChanged(null, null);
}
private void LoadRecord()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
Contacts clsContact = new Contacts();
ContactDetails clsDetails = clsContact.Details(iID);
clsContact.CommitAndDispose();
lblContactID.Text = clsDetails.ContactID.ToString();
lblCustomerCode.Text = clsDetails.ContactCode;
txtFirstName.Text = clsDetails.ContactCode;
txtLastName.Text = clsDetails.ContactName;
cboGroup.SelectedIndex = cboGroup.Items.IndexOf(cboGroup.Items.FindByValue(clsDetails.ContactGroupID.ToString()));
txtBusinessName.Text = clsDetails.BusinessName;
txtRemarks.Text = clsDetails.Remarks;
cboDepartment.SelectedIndex = cboDepartment.Items.IndexOf(cboDepartment.Items.FindByValue(clsDetails.DepartmentID.ToString()));
cboPosition.SelectedIndex = cboPosition.Items.IndexOf(cboPosition.Items.FindByValue(clsDetails.PositionID.ToString()));
cboSalutation.SelectedIndex = cboSalutation.Items.IndexOf(cboSalutation.Items.FindByValue(clsDetails.AdditionalDetails.Salutation));
txtFirstName.Text = clsDetails.AdditionalDetails.FirstName;
txtMiddleName.Text = clsDetails.AdditionalDetails.MiddleName;
txtLastName.Text = clsDetails.AdditionalDetails.LastName;
txtSpouseName.Text = clsDetails.AdditionalDetails.SpouseName;
txtBirthDate.Text = clsDetails.AdditionalDetails.BirthDate == Constants.C_DATE_MIN_VALUE ? "" : clsDetails.AdditionalDetails.BirthDate.ToString("yyyy-MM-dd");
txtSpouseBirthDate.Text = clsDetails.AdditionalDetails.SpouseBirthDate == Constants.C_DATE_MIN_VALUE ? "" : clsDetails.AdditionalDetails.SpouseBirthDate.ToString("yyyy-MM-dd");
txtAnniversaryDate.Text = clsDetails.AdditionalDetails.AnniversaryDate == Constants.C_DATE_MIN_VALUE ? "" : clsDetails.AdditionalDetails.AnniversaryDate.ToString("yyyy-MM-dd");
txtAddress1.Text = clsDetails.AdditionalDetails.Address1;
txtAddress2.Text = clsDetails.AdditionalDetails.Address2;
txtCity.Text = clsDetails.AdditionalDetails.City;
txtState.Text = clsDetails.AdditionalDetails.State;
txtZipCode.Text = clsDetails.AdditionalDetails.ZipCode;
cboCountry.SelectedIndex = cboCountry.Items.IndexOf(cboCountry.Items.FindByValue(clsDetails.AdditionalDetails.CountryID.ToString()));
txtBusinessPhoneNo.Text = clsDetails.AdditionalDetails.BusinessPhoneNo;
txtHomePhoneNo.Text = clsDetails.AdditionalDetails.HomePhoneNo;
txtMobileNo.Text = clsDetails.AdditionalDetails.MobileNo;
txtFaxNo.Text = clsDetails.AdditionalDetails.FaxNo;
txtEmailAddress.Text = clsDetails.AdditionalDetails.EmailAddress;
}
private void SaveRecord()
{
Contacts clsContact = new Contacts();
ContactDetails clsDetails = new ContactDetails();
clsDetails.ContactID = Convert.ToInt32(lblContactID.Text);
clsDetails.ContactCode = txtContactCode.Text;
clsDetails.ContactName = txtContactName.Text;
clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboModeOfTerms.SelectedItem.Value);
clsDetails.Terms = Convert.ToInt32(txtTerms.Text);
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtTelephoneNo.Text;
clsDetails.Remarks = txtRemarks.Text;
clsDetails.Debit = Convert.ToDecimal(txtDebit.Text);
clsDetails.Credit = Convert.ToDecimal(txtCredit.Text);
clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked;
//if (chkIsCreditAllowed.Checked == false)
// clsDetails.IsCreditAllowed = 0;
//else
// clsDetails.IsCreditAllowed = 1;
clsDetails.CreditLimit = Convert.ToDecimal(txtCreditLimit.Text);
clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value);
clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value);
clsContact.Update(clsDetails);
clsContact.CommitAndDispose();
}
private void SaveRecord()
{
Contacts clsContact = new Contacts();
ContactDetails clsDetails = new ContactDetails();
clsDetails.ContactID = Convert.ToInt32(lblContactID.Text);
clsDetails.ContactCode = lblCustomerCode.Text;
clsDetails.ContactName = txtLastName.Text + ", " + txtFirstName.Text + " " + txtMiddleName.Text;
clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
clsDetails.ModeOfTerms = ModeOfTerms.Months;
clsDetails.Terms = 0;
clsDetails.Address = txtAddress1.Text + " " + txtAddress2.Text + " " + txtCity.Text + " " + txtState.Text + " " + txtZipCode.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtBusinessPhoneNo.Text;
clsDetails.Remarks = txtRemarks.Text;
clsDetails.Debit = 0;
clsDetails.Credit = 0;
clsDetails.IsCreditAllowed = false;
clsDetails.CreditLimit = 0;
clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value);
clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value);
DateTime dteBirthDate = Constants.C_DATE_MIN_VALUE;
DateTime dteSpouseBirthDate = Constants.C_DATE_MIN_VALUE;
DateTime dteAnniversaryDate = Constants.C_DATE_MIN_VALUE;
dteBirthDate = DateTime.TryParse(txtBirthDate.Text, out dteBirthDate) ? dteBirthDate : Constants.C_DATE_MIN_VALUE;
dteSpouseBirthDate = DateTime.TryParse(txtSpouseBirthDate.Text, out dteSpouseBirthDate) ? dteSpouseBirthDate : Constants.C_DATE_MIN_VALUE;
dteAnniversaryDate = DateTime.TryParse(txtAnniversaryDate.Text, out dteAnniversaryDate) ? dteAnniversaryDate : Constants.C_DATE_MIN_VALUE;
ContactAddOnDetails clsAddOnDetails = new ContactAddOnDetails();
clsAddOnDetails.ContactID = clsDetails.ContactID;
clsAddOnDetails.Salutation = cboSalutation.SelectedItem.Value;
clsAddOnDetails.FirstName = txtFirstName.Text;
clsAddOnDetails.MiddleName = txtMiddleName.Text;
clsAddOnDetails.LastName = txtLastName.Text;
clsAddOnDetails.SpouseName = txtSpouseName.Text;
clsAddOnDetails.BirthDate = dteBirthDate;
clsAddOnDetails.SpouseBirthDate = dteSpouseBirthDate;
clsAddOnDetails.AnniversaryDate = dteAnniversaryDate;
clsAddOnDetails.Address1 = txtAddress1.Text;
clsAddOnDetails.Address2 = txtAddress2.Text;
clsAddOnDetails.City = txtCity.Text;
clsAddOnDetails.State = txtState.Text;
clsAddOnDetails.ZipCode = txtZipCode.Text;
clsAddOnDetails.CountryID = int.Parse(cboCountry.SelectedItem.Value);
clsAddOnDetails.CountryCode = cboCountry.SelectedItem.Text;
clsAddOnDetails.BusinessPhoneNo = txtBusinessPhoneNo.Text;
clsAddOnDetails.HomePhoneNo = txtHomePhoneNo.Text;
clsAddOnDetails.MobileNo = txtMobileNo.Text;
clsAddOnDetails.FaxNo = txtFaxNo.Text;
clsAddOnDetails.EmailAddress = txtEmailAddress.Text;
clsDetails.AdditionalDetails = clsAddOnDetails;
clsContact.Update(clsDetails);
clsContact.CommitAndDispose();
}
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;
}
protected void imgAgentSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
cboAgent.Items.Clear();
Contacts clsContact = new Contacts();
cboAgent.DataTextField = "ContactName";
cboAgent.DataValueField = "ContactID";
cboAgent.DataSource = clsContact.AgentsAsDataTable(txtAgent.Text, 0, "ContactName", SortOption.Ascending);
cboAgent.DataBind();
if (string.IsNullOrEmpty(txtAgent.Text))
cboAgent.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
else
cboAgent.Items.Insert(0, new ListItem(Constants.ALL + " LIKE " + txtAgent.Text, Constants.ZERO_STRING));
cboAgent.SelectedIndex = 0;
clsContact.CommitAndDispose();
}
private void LoadContactData()
{
Contacts clsContact = new Contacts();
try
{
string searchkey = "" + txtSearch.Text;
System.Data.DataTable dt;
if (mContactGroupCategory == ContactGroupCategory.AGENT)
dt = clsContact.AgentsAsDataTable(searchkey, 100, "ContactName", SortOption.Ascending);
else
dt = clsContact.CustomersDataTable(searchkey, 100, HasCreditOnly, "ContactName", SortOption.Ascending);
clsContact.CommitAndDispose();
this.dgStyle.MappingName = dt.TableName;
dgContacts.DataSource = dt;
dgContacts.Select(0);
dgContacts.CurrentRowIndex=0;
}
catch (IndexOutOfRangeException){}
catch (Exception ex)
{
clsContact.CommitAndDispose();
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
protected void rdoPriceLevelAll_CheckedChanged(Object sender, EventArgs e)
{
HtmlInputCheckBox chkList = null;
RadioButton rdoPriceLevelAll = (RadioButton)sender;
RadioButton rdoPrice = null;
Int64 iContactID = 0;
Contacts clsContacts = new Contacts();
PriceLevel enumPriceLevel = PriceLevel.SRP;
foreach (DataListItem item in lstItem.Items)
{
chkList = (HtmlInputCheckBox)item.FindControl("chkList");
iContactID = Int64.Parse(chkList.Value);
switch (rdoPriceLevelAll.ID)
{
case "rdoPriceAll": enumPriceLevel = PriceLevel.SRP; rdoPrice = (RadioButton)item.FindControl("rdoPrice"); break;
case "rdoWSPriceAll": enumPriceLevel = PriceLevel.WSPrice; rdoPrice = (RadioButton)item.FindControl("rdoWSPrice"); break;
case "rdoLevel1All": enumPriceLevel = PriceLevel.One; rdoPrice = (RadioButton)item.FindControl("rdoLevel1"); break;
case "rdoLevel2All": enumPriceLevel = PriceLevel.Two; rdoPrice = (RadioButton)item.FindControl("rdoLevel2"); break;
case "rdoLevel3All": enumPriceLevel = PriceLevel.Three; rdoPrice = (RadioButton)item.FindControl("rdoLevel3"); break;
case "rdoLevel4All": enumPriceLevel = PriceLevel.Four; rdoPrice = (RadioButton)item.FindControl("rdoLevel4"); break;
case "rdoLevel5All": enumPriceLevel = PriceLevel.Five; rdoPrice = (RadioButton)item.FindControl("rdoLevel5"); break;
}
clsContacts.UpdatePriceLevel(iContactID, enumPriceLevel);
rdoPrice.Checked = rdoPriceLevelAll.Checked;
}
clsContacts.CommitAndDispose();
}