private void btnSubmitAliases_ServerClick(object sender, System.EventArgs e)
{
BECompanies.tbl_CompanyAliasesRow alias;
BPCompanyAliases bp = new BPCompanyAliases();
BECompanies DSCompanyAliases = bp.SelectCompanyAliasesByCompanyID(CompanyID);
if (CompanyHasAliases == false)
{
alias = DSCompanyAliases.tbl_CompanyAliases.Newtbl_CompanyAliasesRow();
}
else
{
if (DSCompanyAliases.tbl_CompanyAliases.Count > 0)
{
CompanyHasAliases = true;
alias = DSCompanyAliases.tbl_CompanyAliases[0];
}
else
{
CompanyHasAliases = false;
alias = DSCompanyAliases.tbl_CompanyAliases.Newtbl_CompanyAliasesRow();
}
}
alias.CompanyID = CompanyID;
if (txtDescription.Text.Trim().Length > 0)
{
alias.Description = txtDescription.Text.Trim();
}
else
{
alias.SetDescriptionNull();
}
if (txtBox.Text.Trim().Length > 0)
{
alias.Box = txtBox.Text.Trim();
}
else
{
alias.SetDescriptionNull();
}
if (txtPin.Text.Trim().Length > 0)
{
alias.Pin = txtPin.Text.Trim();
}
else
{
alias.SetPinNull();
}
if (txtItemNumber.Text.Trim().Length > 0)
{
alias.ItemNumber = txtItemNumber.Text.Trim();
}
else
{
alias.SetItemNumberNull();
}
if (txtBox2.Text.Trim().Length > 0)
{
alias.Box2 = txtBox2.Text.Trim();
}
else
{
alias.SetBox2Null();
}
// if (txtPin2.Text.Trim().Length > 0)
// {
// alias.Pin2 = txtPin2.Text;
// }
// else
// {
// alias.SetPin2Null();
// }
if (txtMajorOD.Text.Trim().Length > 0)
{
alias.MajorOD = txtMajorOD.Text.Trim();
}
else
{
alias.SetMajorODNull();
}
if (txtMinorOD.Text.Trim().Length > 0)
{
alias.MinorOD = txtMinorOD.Text.Trim();
}
else
{
alias.SetMinorODNull();
}
if (txtInsideDiameter.Text.Trim().Length > 0)
{
alias.InsideDiameter = txtInsideDiameter.Text.Trim();
}
else
{
alias.SetInsideDiameterNull();
}
if (txtSealtoSeal.Text.Trim().Length > 0)
{
alias.SealtoSealLength = txtSealtoSeal.Text.Trim();
}
else
{
alias.SetSealtoSealLengthNull();
}
if (txtFloatBore.Text.Trim().Length > 0)
{
alias.FloatBore = txtFloatBore.Text.Trim();
}
else
{
alias.SetFloatBoreNull();
}
// if (txtQuantity.Text.Trim().Length > 0)
// {
// alias.Quantity = txtQuantity.Text;
// }
// else
// {
// alias.SetQuantityNull();
// }
if(txtComments.Text.Trim().Length > 0)
{
alias.GeneralComments = txtComments.Text.Trim();
}
if (txtExtraColumn1.Text.Trim().Length > 0)
{
alias.ExtraColumn1 = txtExtraColumn1.Text.Trim();
}
else
{
alias.SetExtraColumn1Null();
}
if (txtExtraColumn2.Text.Trim().Length > 0)
{
alias.ExtraColumn2 = txtExtraColumn2.Text.Trim();
}
else
{
alias.SetExtraColumn2Null();
}
if (txtExtraColumn3.Text.Trim().Length > 0)
{
alias.ExtraColumn3 = txtExtraColumn3.Text.Trim();
}
else
{
alias.SetExtraColumn3Null();
}
if (txtExtraColumn4.Text.Trim().Length > 0)
{
alias.ExtraColumn4 = txtExtraColumn4.Text.Trim();
}
else
{
alias.SetExtraColumn4Null();
}
if (txtExtraColumn5.Text.Trim().Length > 0)
{
alias.ExtraColumn5 = txtExtraColumn5.Text.Trim();
}
else
{
alias.SetExtraColumn5Null();
}
if (txtExtraColumn6.Text.Trim().Length > 0)
{
alias.ExtraColumn6 = txtExtraColumn6.Text.Trim();
}
else
{
alias.SetExtraColumn6Null();
}
if (txtExtraColumn7.Text.Trim().Length > 0)
{
alias.ExtraColumn7 = txtExtraColumn7.Text.Trim();
}
else
{
alias.SetExtraColumn7Null();
}
if (txtExtraColumn8.Text.Trim().Length > 0)
{
alias.ExtraColumn8 = txtExtraColumn8.Text.Trim();
}
else
{
alias.SetExtraColumn8Null();
}
if (txtExtraColumn9.Text.Trim().Length > 0)
{
alias.ExtraColumn9 = txtExtraColumn9.Text.Trim();
}
else
{
alias.SetExtraColumn9Null();
}
if (txtExtraColumn10.Text.Trim().Length > 0)
{
alias.ExtraColumn10 = txtExtraColumn10.Text.Trim();
}
else
{
alias.SetExtraColumn10Null();
}
if (CompanyHasAliases == false)
{
DSCompanyAliases.tbl_CompanyAliases.Rows.Add(alias);
}
bp.Update(DSCompanyAliases);
//potential bug fix - not sure if it's what they really want yet. 20090209 - hs
//if(CompanyID == Convert.ToInt32(ConfigurationSettings.AppSettings["OryxCompanyID"]))
//bp.SyncExtraColumnAliases(CompanyID);
}
private void GetAliasInformation()
{
BPCompanyAliases bp = new BPCompanyAliases();
BECompanies DSCompanyAliases = bp.SelectCompanyAliasesByCompanyID(CompanyID);
if (DSCompanyAliases.tbl_CompanyAliases.Count > 0)
{
CompanyHasAliases = true;
BECompanies.tbl_CompanyAliasesRow alias = DSCompanyAliases.tbl_CompanyAliases[0];
if (!alias.IsDescriptionNull())
{
txtDescription.Text = alias.Description;
}
if (!alias.IsBoxNull())
{
txtBox.Text = alias.Box;
}
if (!alias.IsPinNull())
{
txtPin.Text = alias.Pin;
}
if (!alias.IsItemNumberNull())
{
txtItemNumber.Text = alias.ItemNumber;
}
if (!alias.IsBox2Null())
{
txtBox2.Text = alias.Box2;
}
// if (!alias.IsPin2Null())
// {
// txtPin2.Text = alias.Pin2;
// }
if (!alias.IsMajorODNull())
{
txtMajorOD.Text = alias.MajorOD;
}
if (!alias.IsMinorODNull())
{
txtMinorOD.Text = alias.MinorOD;
}
if (!alias.IsInsideDiameterNull())
{
txtInsideDiameter.Text = alias.InsideDiameter;
}
if (!alias.IsSealtoSealLengthNull())
{
txtSealtoSeal.Text = alias.SealtoSealLength;
}
if (!alias.IsFloatBoreNull())
{
txtFloatBore.Text = alias.FloatBore;
}
// if (!alias.IsQuantityNull())
// {
// txtQuantity.Text = alias.Quantity;
// }
if(!alias.IsGeneralCommentsNull())
{
txtComments.Text = alias.GeneralComments;
}
//extra columns
if (!alias.IsExtraColumn1Null())
{
txtExtraColumn1.Text = alias.ExtraColumn1;
}
if (!alias.IsExtraColumn2Null())
{
txtExtraColumn2.Text = alias.ExtraColumn2;
}
if (!alias.IsExtraColumn3Null())
{
txtExtraColumn3.Text = alias.ExtraColumn3;
}
if (!alias.IsExtraColumn4Null())
{
txtExtraColumn4.Text = alias.ExtraColumn4;
}
if (!alias.IsExtraColumn5Null())
{
txtExtraColumn5.Text = alias.ExtraColumn5;
}
if (!alias.IsExtraColumn6Null())
{
txtExtraColumn6.Text = alias.ExtraColumn6;
}
if (!alias.IsExtraColumn7Null())
{
txtExtraColumn7.Text = alias.ExtraColumn7;
}
if (!alias.IsExtraColumn8Null())
{
txtExtraColumn8.Text = alias.ExtraColumn8;
}
if (!alias.IsExtraColumn9Null())
{
txtExtraColumn9.Text = alias.ExtraColumn9;
}
if (!alias.IsExtraColumn10Null())
{
txtExtraColumn10.Text = alias.ExtraColumn10;
}
}
else
{
CompanyHasAliases = false;
}
}
private void btnSubmit_ServerClick(object sender, EventArgs e)
{
if (chkCompanyRentalInventory.Checked)
{
pnlColumnAliases.Visible = false;
}
BPCompanies bp = new BPCompanies();
BECompanies.tbl_CompaniesRow Company;
DSCompanies = new BECompanies();
if (CompanyID == 0)
{
// Add new Company
Company = DSCompanies.tbl_Companies.Newtbl_CompaniesRow();
}
else
{
// Edit a Company
DSCompanies = bp.SelectCompaniesByID(CompanyID);
Company = DSCompanies.tbl_Companies.FindByCompanyID(CompanyID);
}
//all content to be updated/inserted between here
Company.CompanyName = txtCompanyName.Text;
ImageWizard ddlCompanyImage = Page.FindControl("ddlCompanyImage") as ImageWizard;
if (ddlCompanyImage.SelectedImage > 0)
{
Company.CompanyImageID = Convert.ToInt32(ddlCompanyImage.SelectedImage);
}
else
{
Company.SetCompanyImageIDNull();
}
Company.CompanyDescription = txtCompanyDescription.Text + " ";
Company.CompanyAddress1 = txtCompanyAddress1.Text;
Company.CompanyAddress2 = txtCompanyAddress2.Text;
Company.CompanyCity = txtCompanyCity.Text;
Company.CompanyProvince = txtCompanyProvince.Text;
Company.CompanyCountry = txtCompanyCountry.Text;
Company.CompanyPostalCode = txtCompanyPostalCode.Text;
Company.CompanyPhone = txtCompanyPhone.Text;
Company.CompanyFax = txtCompanyFax.Text;
Company.CompanyActive = chkCompanyActive.Checked;
if (CompanyID != Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings.Get("OryxCompanyID")))
{
Company.CompanyRentalInventory = chkCompanyRentalInventory.Checked;
}
else
{
Company.CompanyRentalInventory = true;
}
Company.DateModified = DateTime.Now;
Company.ModifiedByAdminID = Convert.ToInt32(OryxUser.OryxIdentity.MemberID);
//all content to be updated/inserted between here
if (CompanyID == 0)
{
//Add new Application Category
Company.DateCreated = DateTime.Now;
DSCompanies.tbl_Companies.Addtbl_CompaniesRow(Company);
}
bp.Update(DSCompanies);
//CreateResizedImage(BEImages DSImages, int ImageID, string prefix, int width, int height, Page page)
if (!Company.IsCompanyImageIDNull())
{
MWUtility.CreateResizedImage(Company.CompanyImageID, "l", "", imageSize, 0, this);
}
if (chkCompanyRentalInventory.Checked && CompanyID != Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["OryxCompanyID"]))
{
BPCompanyAliases bpAliases = new BPCompanyAliases();
//delete all of the company Aliases incase they have more aliases than Oryx, otherwise those extra columns would not get over-ridden.
DSNewCompanyAliases = bpAliases.SelectCompanyAliasesByCompanyID(CompanyID);
if (DSNewCompanyAliases.tbl_CompanyAliases.Count > 0)
{
BECompanies.tbl_CompanyAliasesRow deletealias = DSNewCompanyAliases.tbl_CompanyAliases[0];
deletealias.Delete();
bpAliases.Update(DSNewCompanyAliases);
}
//Get Oryx's Aliases first
DSCompanyAliases = bpAliases.SelectCompanyAliasesByCompanyID(Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings.Get("OryxCompanyID")));
if (DSCompanyAliases.tbl_CompanyAliases.Count > 0)
{
BECompanies.tbl_CompanyAliasesRow alias = DSCompanyAliases.tbl_CompanyAliases[0];
//replace the company Aliases with Oryx's aliases
BECompanies.tbl_CompanyAliasesRow newalias;
DSNewCompanyAliases = bpAliases.SelectCompanyAliasesByCompanyID(Company.CompanyID);
if (DSNewCompanyAliases.tbl_CompanyAliases.Count > 0)
{
CompanyHasAliases = true;
newalias = DSNewCompanyAliases.tbl_CompanyAliases[0];
}
else
{
CompanyHasAliases = false;
newalias = DSNewCompanyAliases.tbl_CompanyAliases.Newtbl_CompanyAliasesRow();
}
newalias.CompanyID = Company.CompanyID;
if (! alias.IsDescriptionNull()) newalias.Description = alias.Description;
if (! alias.IsBoxNull()) newalias.Box = alias.Box;
if (! alias.IsPinNull()) newalias.Pin = alias.Pin;
if (! alias.IsItemNumberNull()) newalias.ItemNumber = alias.ItemNumber;
if (! alias.IsBox2Null()) newalias.Box2 = alias.Box2;
if (! alias.IsMajorODNull()) newalias.MajorOD = alias.MajorOD;
if (! alias.IsMinorODNull()) newalias.MinorOD = alias.MinorOD;
if (! alias.IsInsideDiameterNull()) newalias.InsideDiameter = alias.InsideDiameter;
if (! alias.IsSealtoSealLengthNull()) newalias.SealtoSealLength = alias.SealtoSealLength;
if (! alias.IsFloatBoreNull()) newalias.FloatBore = alias.FloatBore;
if (! alias.IsGeneralCommentsNull()) newalias.GeneralComments = alias.GeneralComments;
if (! alias.IsExtraColumn1Null()) newalias.ExtraColumn1 = alias.ExtraColumn1;
if (! alias.IsExtraColumn2Null()) newalias.ExtraColumn2 = alias.ExtraColumn2;
if (! alias.IsExtraColumn3Null()) newalias.ExtraColumn3 = alias.ExtraColumn3;
if (! alias.IsExtraColumn4Null()) newalias.ExtraColumn4 = alias.ExtraColumn4;
if (! alias.IsExtraColumn5Null()) newalias.ExtraColumn5 = alias.ExtraColumn5;
if (! alias.IsExtraColumn6Null()) newalias.ExtraColumn6 = alias.ExtraColumn6;
if (! alias.IsExtraColumn7Null()) newalias.ExtraColumn7 = alias.ExtraColumn7;
if (! alias.IsExtraColumn8Null()) newalias.ExtraColumn8 = alias.ExtraColumn8;
if (! alias.IsExtraColumn9Null()) newalias.ExtraColumn9 = alias.ExtraColumn9;
if (! alias.IsExtraColumn10Null()) newalias.ExtraColumn10 = alias.ExtraColumn10;
if (CompanyHasAliases == false)
{
DSNewCompanyAliases.tbl_CompanyAliases.Rows.Add(newalias);
}
bpAliases.Update(DSNewCompanyAliases);
}
}
if (CompanyID == 0)
{
Response.Redirect("EditCompanies.aspx?CompanyID=" + Company.CompanyID);
}
else
{
Response.Redirect("BrowseCompanies.aspx");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (CompanyID != Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings.Get("OryxCompanyID")))
{
//Delete Company
BPCompanies bp = new BPCompanies();
BECompanies.tbl_CompaniesRow Company;
DSCompanies = bp.SelectCompaniesByID(CompanyID);
Company = DSCompanies.tbl_Companies.FindByCompanyID(CompanyID);
Company.Delete();
bp.Update(DSCompanies);
//Delete Company Aliases
BPCompanyAliases bpAliases = new BPCompanyAliases();
DSCompanies = bpAliases.SelectCompanyAliasesByCompanyID(CompanyID);
foreach (BECompanies.tbl_CompanyAliasesRow row in DSCompanies.tbl_CompanyAliases.Rows)
{
row.Delete();
}
bpAliases.Update(DSCompanies);
//Delete Company Emails
BPCompanyEmails bpEmails = new BPCompanyEmails();
DSCompanies = bpEmails.SelectCompanyEmailsByCompanyID(CompanyID);
foreach (BECompanies.tbl_CompanyEmailsRow row in DSCompanies.tbl_CompanyEmails.Rows)
{
row.Delete();
}
bpEmails.Update(DSCompanies);
Response.Redirect("BrowseCompanies.aspx");
}
else
{
//TODO: Insert Message here stating that Oryx company Cannot be deleted, please see your web master
}
}
private void RenameLabels()
{
ClearLabels();
if (ddlCompanies.SelectedValue != "0")
{
BPCompanyAliases bp = new BPCompanyAliases();
BECompanies ds = bp.SelectCompanyAliasesByCompanyID(Convert.ToInt32(ddlCompanies.SelectedValue));
if (ds.tbl_CompanyAliases.Rows.Count > 0)
{
BECompanies.tbl_CompanyAliasesRow aliases = ((BECompanies.tbl_CompanyAliasesRow) ds.tbl_CompanyAliases.Rows[0]);
lblItemNumber.Text = aliases.ItemNumber;
lblDescription.Text = aliases.Description;
lblBox.Text = aliases.Box;
lblPin.Text = aliases.Pin;
lblBox2.Text = aliases.Box2;
lblMajorOD.Text = aliases.MajorOD;
lblMinorOD.Text = aliases.MinorOD;
lblInsideDiameter.Text = aliases.InsideDiameter;
lblSealToSeal.Text = aliases.SealtoSealLength;
lblFloatBore.Text = aliases.FloatBore;
if (!aliases.IsExtraColumn1Null()) {lblExtraColumn1.Text = aliases.ExtraColumn1;}
if (!aliases.IsExtraColumn2Null()) {lblExtraColumn2.Text = aliases.ExtraColumn2;}
if (!aliases.IsExtraColumn3Null()) {lblExtraColumn3.Text = aliases.ExtraColumn3;}
if (!aliases.IsExtraColumn4Null()) {lblExtraColumn4.Text = aliases.ExtraColumn4;}
if (!aliases.IsExtraColumn5Null()) {lblExtraColumn5.Text = aliases.ExtraColumn5;}
if (!aliases.IsExtraColumn6Null()) {lblExtraColumn6.Text = aliases.ExtraColumn6;}
if (!aliases.IsExtraColumn7Null()) {lblExtraColumn7.Text = aliases.ExtraColumn7;}
if (!aliases.IsExtraColumn8Null()) {lblExtraColumn8.Text = aliases.ExtraColumn8;}
if (!aliases.IsExtraColumn9Null()) {lblExtraColumn9.Text = aliases.ExtraColumn9;}
if (!aliases.IsExtraColumn10Null()) {lblExtraColumn10.Text = aliases.ExtraColumn10;}
}
}
if (lblItemNumber.Text == "")
lblItemNumber.Text = "Serial # ";
if (lblDescription.Text == "")
lblDescription.Text = "Description ";
if (lblBox.Text == "")
lblBox.Text = "Box ";
if (lblPin.Text == "")
lblPin.Text = "Pin ";
if (lblBox2.Text == "")
lblBox2.Text = "Box 2 ";
if (lblMajorOD.Text == "")
lblMajorOD.Text = "Major OD ";
if (lblMinorOD.Text == "")
lblMinorOD.Text = "Minor OD ";
if (lblInsideDiameter.Text == "")
lblInsideDiameter.Text = "Inside Diameter ";
if (lblSealToSeal.Text == "")
lblSealToSeal.Text = "Seal To Seal ";
if (lblFloatBore.Text == "")
lblFloatBore.Text = "Float Bore ";
for (int i=1; i<=10; i++)
{
if (((Label) this.FindControl("lblExtraColumn" + i)).Text == "")
{
this.FindControl("lblExtraColumn" + i).Visible = false;
this.FindControl("txtExtraColumn" + i).Visible = false;
}
else
{
this.FindControl("lblExtraColumn" + i).Visible = true;
this.FindControl("txtExtraColumn" + i).Visible = true;
}
}
}
