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