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