private void LoadOptions() { ContactGroups clsContactGroup = new ContactGroups(); cboGroup.DataTextField = "ContactGroupName"; cboGroup.DataValueField = "ContactGroupID"; cboGroup.DataSource = clsContactGroup.ListAsDataTable().DefaultView; cboGroup.DataBind(); cboGroup.SelectedIndex = cboGroup.Items.Count - 1; Department clsDepartment = new Department(clsContactGroup.Connection, clsContactGroup.Transaction); cboDepartment.DataTextField = "DepartmentName"; cboDepartment.DataValueField = "DepartmentID"; cboDepartment.DataSource = clsDepartment.ListAsDataTable().DefaultView; cboDepartment.DataBind(); cboDepartment.SelectedIndex = 0; Positions clsPosition = new Positions(clsContactGroup.Connection, clsContactGroup.Transaction); cboPosition.DataTextField = "PositionName"; cboPosition.DataValueField = "PositionID"; cboPosition.DataSource = clsPosition.ListAsDataTable("PositionName", SortOption.Ascending, 0).DefaultView; cboPosition.DataBind(); cboPosition.SelectedIndex = 0; clsContactGroup.CommitAndDispose(); }
private void LoadOptions() { ContactGroups clsContactGroup = new ContactGroups(); cboGroup.DataTextField = "ContactGroupName"; cboGroup.DataValueField = "ContactGroupID"; cboGroup.DataSource = clsContactGroup.ListAsDataTable().DefaultView; cboGroup.DataBind(); cboGroup.SelectedIndex = 0; //cboGroup.Items.Count - 1; cboGroup.SelectedIndex = cboGroup.Items.IndexOf(cboGroup.Items.FindByValue(ContactGroupCategory.CUSTOMER.ToString("d"))); Department clsDepartment = new Department(clsContactGroup.Connection, clsContactGroup.Transaction); cboDepartment.DataTextField = "DepartmentName"; cboDepartment.DataValueField = "DepartmentID"; cboDepartment.DataSource = clsDepartment.ListAsDataTable().DefaultView; cboDepartment.DataBind(); cboDepartment.SelectedIndex = 0; Positions clsPosition = new Positions(clsContactGroup.Connection, clsContactGroup.Transaction); cboPosition.DataTextField = "PositionName"; cboPosition.DataValueField = "PositionID"; cboPosition.DataSource = clsPosition.ListAsDataTable("PositionName", SortOption.Ascending, 0).DefaultView; cboPosition.DataBind(); cboPosition.SelectedIndex = 0; Salutation clsSalutation = new Salutation(clsContactGroup.Connection, clsContactGroup.Transaction); cboSalutation.DataTextField = "SalutationName"; cboSalutation.DataValueField = "SalutationCode"; cboSalutation.DataSource = clsSalutation.ListAsDataTable().DefaultView; cboSalutation.DataBind(); cboSalutation.SelectedIndex = 0; cboSalutation.SelectedIndex = cboSalutation.Items.IndexOf(cboSalutation.Items.FindByValue("MR")); Contacts clsContacts = new Contacts(clsContactGroup.Connection, clsContactGroup.Transaction); cboSoldBy.DataTextField = "ContactName"; cboSoldBy.DataValueField = "ContactCode"; cboSoldBy.DataSource = clsContacts.AgentsAsDataTable(SortField: "ContactName").DefaultView; cboSoldBy.DataBind(); cboSoldBy.SelectedIndex = 0; Security.AccessUser clsAccessUser = new Security.AccessUser(clsContactGroup.Connection, clsContactGroup.Transaction); cboConfirmedBy.DataTextField = "Name"; cboConfirmedBy.DataValueField = "Name"; cboConfirmedBy.DataSource = clsAccessUser.ListAsDataTable(SortField: "Name").DefaultView; cboConfirmedBy.DataBind(); cboConfirmedBy.SelectedIndex = 0; Security.Country clsCountry = new Security.Country(clsContactGroup.Connection, clsContactGroup.Transaction); cboCountry.DataTextField = "CountryName"; cboCountry.DataValueField = "CountryID"; cboCountry.DataSource = clsCountry.ListAsDataTable().DefaultView; cboCountry.DataBind(); cboCountry.SelectedIndex = 0; clsContactGroup.CommitAndDispose(); }
private void LoadRecord() { Int16 iID = Convert.ToInt16(Common.Decrypt(Request.QueryString["id"], Session.SessionID)); Positions clsPosition = new Positions(); PositionDetails clsDetails = clsPosition.Details(iID); clsPosition.CommitAndDispose(); lblPositionID.Text = clsDetails.PositionID.ToString(); txtPositionCode.Text = clsDetails.PositionCode; txtPositionName.Text = clsDetails.PositionName; }
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"); }
private void LoadOptions() { Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID)); lblContactID.Text = iID.ToString(); ContactGroups clsContactGroup = new ContactGroups(); cboGroup.DataTextField = "ContactGroupName"; cboGroup.DataValueField = "ContactGroupID"; cboGroup.DataSource = clsContactGroup.ListAsDataTable().DefaultView; cboGroup.DataBind(); cboGroup.SelectedIndex = cboGroup.Items.Count - 1; Department clsDepartment = new Department(clsContactGroup.Connection, clsContactGroup.Transaction); cboDepartment.DataTextField = "DepartmentName"; cboDepartment.DataValueField = "DepartmentID"; cboDepartment.DataSource = clsDepartment.ListAsDataTable().DefaultView; cboDepartment.DataBind(); cboDepartment.SelectedIndex = 0; Positions clsPosition = new Positions(clsContactGroup.Connection, clsContactGroup.Transaction); cboPosition.DataTextField = "PositionName"; cboPosition.DataValueField = "PositionID"; cboPosition.DataSource = clsPosition.ListAsDataTable("PositionName", SortOption.Ascending, 0).DefaultView; cboPosition.DataBind(); cboPosition.SelectedIndex = 0; cboCreditCardStatus.Items.Clear(); foreach (CreditCardStatus selection in Enum.GetValues(typeof(CreditCardStatus))) { cboCreditCardStatus.Items.Add(new ListItem(selection.ToString("G"), selection.ToString("d"))); } cboCreditCardStatus.SelectedIndex = cboCreditCardStatus.Items.IndexOf(cboCreditCardStatus.Items.FindByValue(CreditCardStatus.All.ToString("d"))); Data.CardType clsCardType = new Data.CardType(clsContactGroup.Connection, clsContactGroup.Transaction); cboCreditCardType.Items.Clear(); cboCreditCardType.DataTextField = "CardTypeName"; cboCreditCardType.DataValueField = "CardTypeID"; cboCreditCardType.DataSource = clsCardType.ListAsDataTable(new CardTypeDetails(CreditCardTypes.Internal)).DefaultView; cboCreditCardType.DataBind(); cboCreditCardType.SelectedIndex = 0; Billing clsBilling = new Billing(clsContactGroup.Connection, clsContactGroup.Transaction); cboBillingDate.DataTextField = "BillingDate"; cboBillingDate.DataValueField = "BillingFile"; cboBillingDate.DataSource = clsBilling.ListBillingDateAsDataTable(CreditType.Individual, long.Parse(lblContactID.Text), limit: 10).DefaultView; cboBillingDate.DataBind(); cboBillingDate.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.PLEASE_SELECT)); cboBillingDate.SelectedIndex = 0; Salutation clsSalutation = new Salutation(clsContactGroup.Connection, clsContactGroup.Transaction); cboSalutation.DataTextField = "SalutationName"; cboSalutation.DataValueField = "SalutationCode"; cboSalutation.DataSource = clsSalutation.ListAsDataTable().DefaultView; cboSalutation.DataBind(); cboSalutation.SelectedIndex = 0; cboSalutation.SelectedIndex = cboSalutation.Items.IndexOf(cboSalutation.Items.FindByValue("MR")); clsContactGroup.CommitAndDispose(); }
private Int16 SaveRecord() { Positions clsPosition = new Positions(); PositionDetails clsDetails = new PositionDetails(); clsDetails.PositionCode = txtPositionCode.Text; clsDetails.PositionName = txtPositionName.Text; Int16 id = clsPosition.Insert(clsDetails); clsPosition.CommitAndDispose(); return id; }
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) { Positions clsPosition = new Positions(); clsPosition.Delete( stIDs.Substring(0,stIDs.Length-1)); clsPosition.CommitAndDispose(); } return boRetValue; }
private void LoadList() { Positions clsPosition = new Positions(); DataClass clsDataClass = new DataClass(); string SortField = "PositionID"; 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 = clsDataClass.DataReaderToDataTable(clsPosition.List(SortField, sortoption, 0)).DefaultView; } else { string SearchKey = Common.Decrypt((string)Request.QueryString["search"],Session.SessionID); PageData.DataSource = clsDataClass.DataReaderToDataTable(clsPosition.Search(SearchKey, SortField, sortoption, 0)).DefaultView; } clsPosition.CommitAndDispose(); int iPageSize = Convert.ToInt16(Session["PageSize"]) ; PageData.AllowPaging = true; PageData.PageSize = iPageSize; try { PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1; lstItem.DataSource = PageData; lstItem.DataBind(); } catch { PageData.CurrentPageIndex = 1; lstItem.DataSource = PageData; lstItem.DataBind(); } cboCurrentPage.Items.Clear(); for (int i=0; i < PageData.PageCount;i++) { int iValue = i + 1; cboCurrentPage.Items.Add(new ListItem(iValue.ToString(),iValue.ToString())); if (PageData.CurrentPageIndex == i) { cboCurrentPage.Items[i].Selected = true;} else { cboCurrentPage.Items[i].Selected = false;} } lblDataCount.Text = " of " + " " + PageData.PageCount; }
protected void lstItem_ItemCommand(object sender, DataListCommandEventArgs e) { HtmlInputCheckBox chkList = (HtmlInputCheckBox)e.Item.FindControl("chkList"); string stParam = string.Empty; switch (e.CommandName) { case "imgItemDelete": Positions clsPosition = new Positions(); clsPosition.Delete(chkList.Value); clsPosition.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() { Positions clsPosition = new Positions(); PositionDetails clsDetails = new PositionDetails(); clsDetails.PositionID = Convert.ToInt16(lblPositionID.Text); clsDetails.PositionCode = txtPositionCode.Text; clsDetails.PositionName = txtPositionName.Text; clsPosition.Update(clsDetails); clsPosition.CommitAndDispose(); }