/// <summary>
///
/// </summary>
/// <param name="part"></param>
/// <param name="attri"></param>
public static void AddPart(Control part, PartAttribute attri)
{
Guard.NotNull(Workbench.MainWorkspace, "Workbench.MainWorkspace");
Guard.NotNull(part, "part");
Guard.NotNull(attri, "attri");
part.Text = attri.Title;
Workbench.MainWorkspace.Show(part, attri);
}
private void SetUpResponse(Part part, PartAttribute attribute)
{
MyEmbedBuilder.AddField("Part", part.id, true);
MyEmbedBuilder.AddField("Brand", part.details.brand, true);
MyEmbedBuilder.AddField("Model", part.details.model, true);
if (attribute == PartAttribute.DURABILITY)
{
MyEmbedBuilder.AddField("Durability", part.details.durability, true);
}
else if (attribute == PartAttribute.POWER)
{
MyEmbedBuilder.AddField("Power", part.details.power, true);
}
else if (attribute == PartAttribute.SPEED)
{
MyEmbedBuilder.AddField("Speed", part.details.speed, true);
}
else if (attribute == PartAttribute.STEERING)
{
MyEmbedBuilder.AddField("Steering", part.details.steering, true);
}
else if (attribute == PartAttribute.FRONT_DUR_POWER)
{
MyEmbedBuilder.AddField("Durability", part.details.durability, true);
MyEmbedBuilder.AddField("Power", part.details.power, true);
}
else if (attribute == PartAttribute.BACK_SPEED_STEERING)
{
MyEmbedBuilder.AddField("Speed", part.details.speed, true);
MyEmbedBuilder.AddField("Steering", part.details.steering, true);
}
else if (attribute == PartAttribute.WHEELS_POWER_STEERING)
{
MyEmbedBuilder.AddField("Power", part.details.power, true);
MyEmbedBuilder.AddField("Steering", part.details.steering, true);
}
else if (attribute == PartAttribute.BODY_DUR_SPEED)
{
MyEmbedBuilder.AddField("Durability", part.details.durability, true);
MyEmbedBuilder.AddField("Speed", part.details.speed, true);
}
else
{
MyEmbedBuilder.AddField("Weight", part.details.weight, true);
}
MyEmbedBuilder.AddField("Rarity", part.details.rarity);
MyEmbedBuilder.WithThumbnailUrl(part.image);
}
private bool ParameterBehavior(IHttpBehavior behavior, string paramName, PartAttribute attr, EnctypeAttribute enctype, int argIndex, Encoding encoding, Formatters.IFormatter formatter)
{
if (attr == null)
{
return(false);
}
if (!attr.IsFile)
{
var pb = new HttpParameterBehavior(paramName, argIndex, encoding, formatter)
{
IsEncodeKey = enctype.DefaultEncodeKey,
IsEncodeValue = enctype.DefaultEncodeValue
};
behavior.PartKeys.Add(new HttpStringParameterStreamWrapperBehavior(pb));
}
else
{
behavior.PartKeys.Add(new HttpFileParameterBehavior(paramName, argIndex, encoding));
}
return(true);
}
private Part GetPartWithBestAttribute(List <Part> parts, PartAttribute attribute)
{
if (attribute == PartAttribute.DURABILITY)
{
return(parts.Aggregate((p1, p2) => p1.details.durability > p2.details.durability ? p1 : p2));
}
else if (attribute == PartAttribute.POWER)
{
return(parts.Aggregate((p1, p2) => p1.details.power > p2.details.power ? p1 : p2));
}
else if (attribute == PartAttribute.SPEED)
{
return(parts.Aggregate((p1, p2) => p1.details.speed > p2.details.speed ? p1 : p2));
}
else if (attribute == PartAttribute.STEERING)
{
return(parts.Aggregate((p1, p2) => p1.details.steering > p2.details.steering ? p1 : p2));
}
else if (attribute == PartAttribute.FRONT_DUR_POWER)
{
return(parts.Aggregate((p1, p2) => (p1.details.durability + p1.details.power) > (p2.details.durability + p2.details.power) ? p1 : p2));
}
else if (attribute == PartAttribute.BACK_SPEED_STEERING)
{
return(parts.Aggregate((p1, p2) => (p1.details.speed + p1.details.steering) > (p2.details.speed + p2.details.steering) ? p1 : p2));
}
else if (attribute == PartAttribute.WHEELS_POWER_STEERING)
{
return(parts.Aggregate((p1, p2) => (p1.details.steering + p1.details.power) > (p2.details.steering + p2.details.power) ? p1 : p2));
}
else if (attribute == PartAttribute.BODY_DUR_SPEED)
{
return(parts.Aggregate((p1, p2) => (p1.details.durability + p1.details.speed) > (p2.details.durability + p2.details.speed) ? p1 : p2));
}
else
{
return(parts.Aggregate((p1, p2) => p1.details.weight < p2.details.weight ? p1 : p2));
}
}
public string Clone(int partID = 0, int newPartID = 0, string upc = "", bool categories = false, bool relatedParts = false, bool attributes = false, bool content = false, bool vehicles = false, bool prices = false)
{
CurtDevDataContext db = new CurtDevDataContext();
List<string> messages = new List<string>();
// Validate the partID and shortDesc fields
if (partID == 0) { messages.Add("You must enter a part number."); }
if (newPartID == 0) { messages.Add("You must enter a part number."); }
if (upc.Trim().Length == 0) { messages.Add("You must enter a UPC."); }
int existing_part = 0;
// Make sure we don't have a product with this partID
existing_part = (from p in db.Parts
where p.partID.Equals(newPartID)
select p).Count();
if (existing_part != 0) { messages.Add("This part number exists."); }
#region clone part
if (messages.Count == 0) { // No errors, add the part
try {
ConvertedPart cp = ProductModels.GetPart(partID);
Part new_part = new Part {
partID = newPartID,
classID = cp.pClass,
dateAdded = DateTime.Now,
dateModified = DateTime.Now,
featured = cp.featured,
oldPartNumber = cp.oldPartNumber,
priceCode = cp.priceCode,
shortDesc = cp.shortDesc,
status = cp.status,
ACESPartTypeID = cp.ACESPartTypeID
};
db.Parts.InsertOnSubmit(new_part);
db.SubmitChanges();
messages.Add("Part Added Successfully");
try {
ProductModels.SaveAttribute(0,new_part.partID, "UPC", upc);
messages.Add("UPC Added Successfully");
} catch (Exception e) {
messages.Add(e.Message);
}
#region clone categories
if (categories) {
try {
List<CatParts> new_catparts = new List<CatParts>();
List<int> catparts = db.CatParts.Where(x => x.partID == partID).Select(x => x.catID).Distinct().ToList();
foreach (int catpart in catparts) {
CatParts ncp = new CatParts {
catID = catpart,
partID = new_part.partID
};
new_catparts.Add(ncp);
}
db.CatParts.InsertAllOnSubmit(new_catparts);
db.SubmitChanges();
messages.Add("Categories Cloned Successfully");
} catch {
messages.Add("There was a problem cloning the categories.");
}
}
#endregion
#region clone Related Parts
if (relatedParts) {
try {
List<RelatedPart> new_relparts = new List<RelatedPart>();
List<RelatedPart> relparts = db.RelatedParts.Where(x => x.partID == partID).ToList<RelatedPart>();
foreach (RelatedPart relpart in relparts) {
RelatedPart nrp = new RelatedPart {
relatedID = relpart.relatedID,
rTypeID = relpart.rTypeID,
partID = new_part.partID
};
new_relparts.Add(nrp);
}
db.RelatedParts.InsertAllOnSubmit(new_relparts);
db.SubmitChanges();
messages.Add("Related Parts Cloned Successfully");
} catch {
messages.Add("There was a problem cloning the related parts.");
}
}
#endregion
#region clone Attributes
if (attributes) {
try {
List<PartAttribute> new_attrs = new List<PartAttribute>();
List<PartAttribute> attributelist = db.PartAttributes.Where(x => x.partID == partID).Where(x => x.field.ToLower() != "upc").ToList<PartAttribute>();
foreach (PartAttribute attribute in attributelist) {
PartAttribute attr = new PartAttribute {
value = attribute.value,
field = attribute.field,
partID = new_part.partID,
sort = attribute.sort
};
new_attrs.Add(attr);
}
db.PartAttributes.InsertAllOnSubmit(new_attrs);
db.SubmitChanges();
messages.Add("Attributes Cloned Successfully");
} catch {
messages.Add("There was a problem cloning the attributes.");
}
}
#endregion
#region clone Content
if (content) {
try {
List<ContentBridge> new_content = new List<ContentBridge>();
List<ContentBridge> contents = (from cb in db.ContentBridges
where cb.partID == partID
select cb).ToList<ContentBridge>();
foreach (ContentBridge cont in contents) {
Content c = db.Contents.Where(x => x.contentID.Equals(cont.contentID)).FirstOrDefault();
Content new_c = new Content {
cTypeID = c.cTypeID,
text = c.text
};
db.Contents.InsertOnSubmit(new_c);
db.SubmitChanges();
ContentBridge cb = new ContentBridge {
partID = new_part.partID,
contentID = new_c.contentID
};
db.ContentBridges.InsertOnSubmit(cb);
db.SubmitChanges();
}
messages.Add("Contents Cloned Successfully");
} catch {
messages.Add("There was a problem cloning the contents.");
}
}
#endregion
#region clone Vehicles
if (vehicles) {
try {
List<VehiclePart> vehiclelist = db.VehicleParts.Where(x => x.partID == partID).ToList<VehiclePart>();
foreach (VehiclePart vp in vehiclelist) {
VehiclePart vehiclepart = new VehiclePart {
partID = new_part.partID,
vehicleID = vp.vehicleID,
drilling = vp.drilling,
installTime = vp.installTime,
exposed = vp.exposed
};
db.VehicleParts.InsertOnSubmit(vehiclepart);
db.SubmitChanges();
List<VehiclePartAttribute> new_vpattr = new List<VehiclePartAttribute>();
List<VehiclePartAttribute> vpattrs = db.VehiclePartAttributes.Where(x => x.vPartID == vp.vPartID).ToList<VehiclePartAttribute>();
foreach (VehiclePartAttribute vpa in vpattrs) {
VehiclePartAttribute new_vpa = new VehiclePartAttribute {
vPartID = vehiclepart.vPartID,
value = vpa.value,
field = vpa.field,
sort = vpa.sort
};
new_vpattr.Add(new_vpa);
};
db.VehiclePartAttributes.InsertAllOnSubmit(new_vpattr);
db.SubmitChanges();
messages.Add("Vehicles Cloned Successfully");
}
} catch {
messages.Add("There was a problem cloning the vehicles.");
}
}
#endregion
#region clone Prices
if (prices) {
try {
List<Price> new_prices = new List<Price>();
List<Price> pricelist = db.Prices.Where(x => x.partID == partID).ToList<Price>();
foreach (Price prc in pricelist) {
Price price = new Price {
priceType = prc.priceType,
price1 = prc.price1,
partID = new_part.partID,
enforced = prc.enforced
};
new_prices.Add(price);
}
db.Prices.InsertAllOnSubmit(new_prices);
db.SubmitChanges();
messages.Add("Prices Cloned Successfully");
} catch {
messages.Add("There was a problem cloning the prices.");
}
}
#endregion
ImportImages(new_part.partID);
db.indexPart(new_part.partID);
messages.Add("Part Cloned Successfully.");
} catch (Exception e) {
messages.Add(e.Message);
}
} else {
messages.Add("Part Clone Failed.");
}
#endregion
return Newtonsoft.Json.JsonConvert.SerializeObject(messages);
}
public static PartAttribute SaveAttribute(int attrID = 0, int partID = 0, string field = "", string value = "")
{
// Validate fields
if (partID <= 0) { throw new Exception("Part ID is invalid."); }
if (field.Length <= 0) { throw new Exception("Field is invalid."); }
if (value.Length <= 0) { throw new Exception("Value is invalid."); }
if (field.ToUpper() == "UPC") { // Validate UPC
if (!ValidateUPC(value)) {
throw new Exception("UPC exists.");
}
}
// Declare objects
CurtDevDataContext db = new CurtDevDataContext();
PartAttribute pa = new PartAttribute();
if (attrID == 0) {
// Add New Attribute
bool exists = db.PartAttributes.Where(x => x.partID == partID).Where(x => x.field == field).Count() > 0;
if (exists) {
throw new Exception("This attribute already exists!");
}
pa = new PartAttribute {
partID = partID,
field = field.Trim(),
value = value.Trim(),
sort = (db.PartAttributes.Where(x => x.partID.Equals(partID)).OrderByDescending(x => x.sort).Select(x => x.sort).FirstOrDefault() + 1)
};
// Commit to databse
db.PartAttributes.InsertOnSubmit(pa);
} else {
// Update Existing Attribute
// Retrive PartAttribute
pa = (from p in db.PartAttributes
where p.pAttrID.Equals(attrID)
select p).FirstOrDefault<PartAttribute>();
// Update values
pa.partID = partID;
pa.field = field.Trim();
pa.value = value.Trim();
}
// Commit to databse
db.SubmitChanges();
UpdateAttributeSort(getAttributeIDs(partID));
db.indexPart(partID);
UpdatePart(partID);
// Return PartAttribute
return pa;
}
public static void DeleteAttribute(int attrID = 0)
{
// Validate
if (attrID <= 0) { throw new Exception("Attribute ID is invalid."); }
// Variable Declaration
CurtDevDataContext db = new CurtDevDataContext();
PartAttribute pa = new PartAttribute();
pa = (from p in db.PartAttributes
where p.pAttrID.Equals(attrID)
select p).FirstOrDefault<PartAttribute>();
int pid = pa.partID;
db.PartAttributes.DeleteOnSubmit(pa);
db.SubmitChanges();
UpdateAttributeSort(getAttributeIDs(pid));
db.indexPart(pid);
UpdatePart(pid);
}
