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) { ProductSubGroupUnitsMatrix clsUnitMatrix = new ProductSubGroupUnitsMatrix(); clsUnitMatrix.Delete(stIDs.Substring(0, stIDs.Length - 1)); clsUnitMatrix.CommitAndDispose(); } return(boRetValue); }
private void SaveRecord() { ProductSubGroupUnitsMatrix clsUnitMatrix = new ProductSubGroupUnitsMatrix(); ProductSubGroupUnitsMatrixDetails clsDetails = new ProductSubGroupUnitsMatrixDetails(); clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text); clsDetails.BaseUnitID = Convert.ToInt32(lblBaseUnitID.Text); clsDetails.BaseUnitValue = Convert.ToDecimal(txtBaseUnitValue.Text); clsDetails.BottomUnitID = Convert.ToInt32(cboBottomUnit.SelectedItem.Value); clsDetails.BottomUnitValue = Convert.ToDecimal(txtBottomUnitValue.Text); clsUnitMatrix.Update(clsDetails); clsUnitMatrix.CommitAndDispose(); }
private void LoadRecord() { Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID)); ProductSubGroupUnitsMatrix clsUnitMatrix = new ProductSubGroupUnitsMatrix(); ProductSubGroupUnitsMatrixDetails clsDetails = clsUnitMatrix.Details(iID); lblBaseUnitID.Text = clsDetails.BaseUnitID.ToString(); txtBaseUnit.Text = Convert.ToString(clsDetails.BaseUnitName); txtBaseUnitValue.Text = clsDetails.BaseUnitValue.ToString(); // cboBottomUnit.Items.RemoveAt( cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(lblBaseUnitID.Text))); cboBottomUnit.SelectedIndex = cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(clsDetails.BottomUnitID.ToString())); txtBottomUnitValue.Text = clsDetails.BottomUnitValue.ToString(); clsUnitMatrix.CommitAndDispose(); }
private Int64 SaveRecord() { ProductSubGroupUnitsMatrix clsUnitMatrix = new ProductSubGroupUnitsMatrix(); ProductSubGroupUnitsMatrixDetails clsDetails = new ProductSubGroupUnitsMatrixDetails(); clsDetails.SubGroupID = Convert.ToInt32(lblSubGroupID.Text); clsDetails.BaseUnitID = Convert.ToInt32(lblBaseUnitID.Text); clsDetails.BaseUnitValue = Convert.ToDecimal(txtBaseUnitValue.Text); clsDetails.BottomUnitID = Convert.ToInt32(cboBottomUnit.SelectedItem.Value); clsDetails.BottomUnitValue = Convert.ToDecimal(txtBottomUnitValue.Text); Int64 id = clsUnitMatrix.Insert(clsDetails); clsUnitMatrix.CommitAndDispose(); return(id); }
private void LoadOptions() { DataClass clsDataClass = new DataClass(); Int32 iID = Convert.ToInt32(Common.Decrypt(Request.QueryString["id"], Session.SessionID)); lblMatrixID.Text = iID.ToString(); Int32 subgroupid = Convert.ToInt32(Common.Decrypt(Request.QueryString["subgroupid"], Session.SessionID)); lblSubGroupID.Text = subgroupid.ToString(); ProductSubGroupUnitsMatrix clsUnitMatrix = new ProductSubGroupUnitsMatrix(); cboBottomUnit.DataTextField = "UnitName"; cboBottomUnit.DataValueField = "UnitID"; cboBottomUnit.DataSource = clsDataClass.DataReaderToDataTable(clsUnitMatrix.AvailableUnitsForProduct(subgroupid, "UnitName", SortOption.Ascending)).DefaultView; cboBottomUnit.DataBind(); cboBottomUnit.SelectedIndex = cboBottomUnit.Items.Count - 1; clsUnitMatrix.CommitAndDispose(); }
private void LoadOptions() { DataClass clsDataClass = new DataClass(); int subgroupid = Convert.ToInt32(Common.Decrypt(Request.QueryString["subgroupid"].ToString(), Session.SessionID)); lblSubGroupID.Text = Convert.ToString(subgroupid); ProductSubGroupUnitsMatrix clsUnitMatrix = new ProductSubGroupUnitsMatrix(); ProductSubGroupUnitsMatrixDetails clsUnitDetails = clsUnitMatrix.LastDetails(subgroupid); if (clsUnitDetails.BottomUnitName == null) { ProductSubGroup clsProductSubGroup = new ProductSubGroup(); ProductSubGroupDetails clsDetails = clsProductSubGroup.Details(subgroupid); clsProductSubGroup.CommitAndDispose(); txtBaseUnit.Text = clsDetails.BaseUnitName; lblBaseUnitID.Text = Convert.ToString(clsDetails.BaseUnitID); } else { txtBaseUnit.Text = clsUnitDetails.BottomUnitName; lblBaseUnitID.Text = Convert.ToString(clsUnitDetails.BottomUnitID); } cboBottomUnit.DataTextField = "UnitName"; cboBottomUnit.DataValueField = "UnitID"; cboBottomUnit.DataSource = clsDataClass.DataReaderToDataTable(clsUnitMatrix.AvailableUnitsForProduct(subgroupid, "UnitName", SortOption.Ascending)).DefaultView; cboBottomUnit.DataBind(); if (cboBottomUnit.Items.Contains(new ListItem(txtBaseUnit.Text, lblBaseUnitID.Text))) { cboBottomUnit.Items.RemoveAt(cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(lblBaseUnitID.Text))); } cboBottomUnit.SelectedIndex = cboBottomUnit.Items.Count - 1; clsUnitMatrix.CommitAndDispose(); }
private void LoadList() { ProductSubGroupUnitsMatrix clsProductSubGroupUnitsMatrix = new ProductSubGroupUnitsMatrix(); DataClass clsDataClass = new DataClass(); string SortField = "MatrixID"; 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(clsProductSubGroupUnitsMatrix.List(Convert.ToInt64(lblSubGroupID.Text), SortField, sortoption)).DefaultView; } else { string SearchKey = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID); PageData.DataSource = clsDataClass.DataReaderToDataTable(clsProductSubGroupUnitsMatrix.Search(lblSubGroupID.Text, SortField, sortoption)).DefaultView; } clsProductSubGroupUnitsMatrix.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; }