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