protected void LoadMainDataGrid() { try { EntityLib elib = new EntityLib(); DataTable dt = elib.SelectEntityData(_EntityID, _UserID); } catch (Exception ex) { this.lblErrorMsg.Text = "Error when loading data grid: " + ex.Message; } }
protected void DeleteThisID() { try { EntityLib elib = new EntityLib(); DataTable dt = elib.DeleteEntityByID(_EntityID, _UserID); Response.Redirect("EntityList.aspx", false); } catch (Exception ex) { lblErrorMsg.Text = "Error when attempting to delete ID " + _EntityID.ToString() + ": " + ex.Message; } }
protected void LoadCurrencyTypeList() { try { EntityLib el = new EntityLib(); DataTable dt = el.SelectCurrencyTypeList(0, 1, _UserID); ddlCurrencyE.DataValueField = ""; ddlCurrencyE.DataTextField = ""; ddlCurrencyE.DataSource = dt; ddlCurrencyE.DataBind(); } catch (Exception ex) { this.lblErrorMsg.Text = "Error encountered when loading currency types: " + ex.Message; } }
protected void btnSaveEntityData_Click(object sender, EventArgs e) { try { DateTime d = DateTime.Now; int act = Convert.ToInt32(ddlActiveE.SelectedValue); int DivID = Convert.ToInt32(ddlDivIDE.SelectedValue); int id = Convert.ToInt32(lblEntityIDE.Text); string Addr = txtAddressE.Text; string attribs = "0000000000"; string Contact = txtContactNameE.Text; string CPhone = txtContactPhoneE.Text; string Cell = txtCellPhoneE.Text; string CEmail = txtContactEmailE.Text; string City = txtAddrCityE.Text; string Country = ddlCountryListE.SelectedValue; string CurrCode = ddlCurrencyE.SelectedValue; string CustID = txtCustomerIDE.Text; string Desc = txtDescriptionE.Text; string Email = txtEmailAddrE.Text; string EntCode = txtEntityCodeE.Text; string EntStat = ddlEntityStatusE.SelectedValue; string EntType = ddlEntityTypeE.SelectedValue; string FEINTaxNr = txtFEINTaxNbrE.Text; string Fax = txtFaxE.Text; string FName = txtFirstNameE.Text; string FullName = txtEntityNameE.Text; string GeoArea = ddlGeoAreaE.SelectedValue; string LName = txtLastNameE.Text; string MName = txtMiddleNameE.Text; string PCode = txtPostalCodeE.Text; string Phone = txtMainPhoneE.Text; string Suff = txtSuffixE.Text; string sBDate = txtBeginDateE.Text; string sEDate = txtEndDateE.Text; string StProv = ddlStateProvE.SelectedValue; string SuppID = txtSupplierIDE.Text; string VendClass = txtVendorClassE.Text; string VendID = txtVendorIDE.Text; string VendTypeID = ddlVendorTypeE.Text; string YardType = ""; int EmpID = 0; int IsCust = 0; int IsVend = 0; int IsSupp = 0; int IsEmp = 0; int IsSource = 0; int IsComp = 0; int IsDest = 0; int IsMill = 0; int IsYard = 0; int IsExp = 0; int IsExt = 0; int IsLT = 0; int IsLIMS = 0; int IsGP = 0; if (EntType == "CMP") { IsComp = 1; } if (chkCustomerE.Checked == true) { IsCust = 1; } if (chkVendorE.Checked == true) { IsVend = 1; } if (chkSupplierE.Checked == true) { IsSupp = 1; } if (chkEmployeeE.Checked == true) { IsEmp = 1; } if (chkSourceE.Checked == true) { IsSource = 1; } ; if (chkAccessGP.Checked == true) { IsGP = 1; } if (chkAccessLIMS.Checked == true) { IsLIMS = 1; } if (chkAccessLT.Checked == true) { IsLT = 1; } EntityLib el = new EntityLib(); DataTable dt = el.UpdateEntityData(id, EntType, FullName, LName, FName, MName, Suff, "", EntStat, EntCode, Desc, IsEmp, IsCust, IsSupp, IsVend, IsComp, IsExt, IsExp, IsSource, IsDest, IsMill, IsYard, GeoArea, sBDate, sEDate, FEINTaxNr, Addr, City, StProv, Country, PCode, VendID, CustID, SuppID, EmpID, attribs, "", VendClass, VendTypeID, YardType, Phone, Cell, Fax, Email, CurrCode, IsLT, IsLIMS, IsGP, act, DivID, "C5073803VW00", Contact, CEmail, CPhone, "", _UserID); //the last two digits in the C5073803VW number are fillers - cannot be sure what is supposed to be there in two-five digits. divGridFilters.Style["display"] = "none"; } catch (Exception ex) { this.lblErrorMsg.Text = "Error generated when trying to save Entity data: " + ex.Message; } }
protected void gvMainData_RowCommand(object sender, GridViewCommandEventArgs e) { String s = String.Empty; string cname = e.CommandName.ToString(); int RowID = Convert.ToInt32(e.CommandArgument); GridViewRow r = gvMainData.Rows[RowID]; DataRowView rv = (DataRowView)r.DataItem; DateTime BDate = DateTime.Now; string sBDate = BDate.ToString("MM/dd/yyyy"); int EntID = Convert.ToInt32(r.Cells[0].Text); EntityLib el = new EntityLib(); DataTable dt = el.SelectEntityData(EntID, _UserID); try { switch (cname) { case "Edit1": DateTime d = DateTime.Now; lblEntityIDE.Text = dt.Rows[0]["EntityID"].ToString(); txtEntityNameE.Text = dt.Rows[0]["EntityFullName"].ToString(); s = dt.Rows[0]["EntityTypeCode"].ToString(); ddlEntityTypeE.SelectedValue = s; txtEntityCodeE.Text = dt.Rows[0]["EntityCode"].ToString(); txtLastNameE.Text = dt.Rows[0]["LastName"].ToString(); txtFirstNameE.Text = dt.Rows[0]["FirstName"].ToString(); txtMiddleNameE.Text = dt.Rows[0]["MiddleName"].ToString(); txtSuffixE.Text = dt.Rows[0]["Suffix"].ToString(); ddlEntityStatusE.SelectedValue = dt.Rows[0]["EntityStatus"].ToString(); txtDescriptionE.Text = dt.Rows[0]["EntityDescription"].ToString(); ddlGeoAreaE.SelectedValue = "0"; s = dt.Rows[0]["GeoArea"].ToString(); if (s.Length > 0) { ddlGeoAreaE.SelectedValue = s; } txtBeginDateE.Text = dt.Rows[0]["sBeginDate"].ToString(); txtEndDateE.Text = dt.Rows[0]["sEndDate"].ToString(); txtAddressE.Text = dt.Rows[0]["Address1"].ToString(); txtAddrCityE.Text = dt.Rows[0]["City"].ToString(); ddlStateProvE.SelectedValue = dt.Rows[0]["StateCode"].ToString(); ddlCountryListE.SelectedValue = dt.Rows[0]["CountryCode"].ToString(); txtFEINTaxNbrE.Text = dt.Rows[0]["FEINTaxNbr"].ToString(); txtPostalCodeE.Text = dt.Rows[0]["PostalCode"].ToString(); txtMainPhoneE.Text = dt.Rows[0]["MainPhone"].ToString(); txtCellPhoneE.Text = dt.Rows[0]["CellPhone"].ToString(); txtFaxE.Text = dt.Rows[0]["MainFax"].ToString(); txtEmailAddrE.Text = dt.Rows[0]["EmailAddress"].ToString(); ddlCurrencyE.SelectedValue = "0"; txtVendorIDE.Text = dt.Rows[0]["VendorID"].ToString(); txtVendorClassE.Text = dt.Rows[0]["VendorClass"].ToString(); ddlVendorTypeE.SelectedValue = dt.Rows[0]["VendorTypeID"].ToString(); txtCustomerIDE.Text = dt.Rows[0]["CustomerID"].ToString(); txtSupplierIDE.Text = dt.Rows[0]["SupplierID"].ToString(); chkCustomerE.Checked = false; chkVendorE.Checked = false; chkSupplierE.Checked = false; chkEmployeeE.Checked = false; if (dt.Rows[0]["sIsCustomer"].ToString() == "Yes") { chkCustomerE.Checked = true; } if (dt.Rows[0]["sIsVendor"].ToString() == "Yes") { chkCustomerE.Checked = true; } if (dt.Rows[0]["sIsSupplier"].ToString() == "Yes") { chkCustomerE.Checked = true; } if (dt.Rows[0]["sIsEmployee"].ToString() == "Yes") { chkEmployeeE.Checked = true; } chkSourceE.Checked = false; divGridFilters.Style["display"] = "none"; divEditItem.Style["display"] = "block"; if (ddlEntityTypeE.SelectedValue == "IND") { this.trIndividualNameE.Style["display"] = "table-row"; lblEntNameE.Style["display"] = "none"; txtEntityNameE.Style["display"] = "none"; } else { this.trIndividualNameE.Style["display"] = "none"; lblEntNameE.Style["display"] = "inline"; txtEntityNameE.Style["display"] = "inline"; } break; case "Inact1": break; default: break; } } catch (Exception ex) { this.lblErrorMsg.Text = "Error generated: " + ex.Message; } }
protected void LoadMainDataGrid(int ResetPage) { try { int Type = Convert.ToInt32(ddlTypeF.SelectedValue); string Name = txtNameF.Text; string Cd = txtCodeF.Text; string Stat = ddlStatusF.SelectedValue; string addr = txtAddressF.Text; string City = txtCityF.Text; string stcode = ddlStateIDF.SelectedValue; string cntry = ddlCountryListF.SelectedValue; string pcode = txtPostalCodeF.Text; string email = txtEmailAddressF.Text; string GeoArea = txtGeoAreaF.Text; string phone = txtPhoneF.Text; string taxnbr = txtFEINTaxNbrF.Text; int PgSize = Convert.ToInt32(this.ddlPageSize.SelectedValue); gvMainData.PageSize = PgSize; this._PgSize = PgSize; if (Name != XName && Cd != XCode && Stat != XStatus && addr != XAddress && City != XCity && stcode != XStateID && cntry != XCountry && pcode != XProduct && email != XEmail && GeoArea != XGeo && phone != XPhone && taxnbr != XTaxNbr) { _PgNbr = 0; gvMainData.PageIndex = 0; } if (ResetPage == 1) { _PgNbr = 0; gvMainData.PageIndex = 0; } XName = Name; XCode = Cd; XCountry = cntry; XEmail = email; XGeo = GeoArea; XStatus = Stat; XAddress = addr; XCity = City; XProduct = pcode; XStateID = stcode; XTaxNbr = taxnbr; ViewState["AddressFilter"] = XAddress; ViewState["CityFilter"] = XCity; ViewState["CountryFilter"] = XCountry; ViewState["CodeFilter"] = Cd; ViewState["EmailFilter"] = XEmail; ViewState["GeoFilter"] = XGeo; ViewState["NameFilter"] = Name; ViewState["PhoneFilter"] = XPhone; ViewState["ProductFilter"] = XProduct; ViewState["StateFilter"] = XStateID; ViewState["StatusFilter"] = Stat; ViewState["TaxNbrFilter"] = XTaxNbr; EntityLib elib = new EntityLib(); DataTable dt = elib.SelectEntityList(Name, Cd, Type, Stat, addr, City, stcode, cntry, pcode, email, GeoArea, taxnbr, "0", phone, 0, 20000, 0, 1, _UserID); gvMainData.DataSource = dt; gvMainData.DataBind(); if (dt.Rows.Count < 1) { lblErrorMsg.Text = "No rows were returned that matched your criteria."; } } catch (Exception ex) { this.lblErrorMsg.Text = "Error when loading data grid: " + ex.Message; } }