public static FullContent SaveContent(int contentID = 0, int partID = 0, string content = "", int contentType = 0)
{
if (partID <= 0) { throw new Exception("Part ID invalid."); }
if (content.Length == 0) { throw new Exception("Content is blank."); }
if (contentType <= 0) { throw new Exception("Content type not defined."); }
CurtDevDataContext db = new CurtDevDataContext();
Content c = new Content();
if (contentID == 0) {
Content existing = (from co in db.Contents
join cob in db.ContentBridges on co.contentID equals cob.contentID
where cob.partID.Equals(partID) && co.ContentType.cTypeID.Equals(contentType) && co.text.Equals(content.Trim())
select co).FirstOrDefault<Content>();
if (existing != null && existing.contentID > 0) {
throw new Exception("This content already exists.");
} else {
c = new Content {
text = content,
cTypeID = contentType,
};
db.Contents.InsertOnSubmit(c);
}
db.SubmitChanges();
ContentBridge cb = new ContentBridge {
partID = partID,
contentID = c.contentID
};
db.ContentBridges.InsertOnSubmit(cb);
} else {
c = (from contents in db.Contents
where contents.contentID.Equals(contentID)
select contents).FirstOrDefault<Content>();
c.text = content;
c.cTypeID = contentType;
}
db.SubmitChanges();
UpdatePart(partID);
return GetFullContent(c.contentID);
}
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 string SaveContent(int catID = 0, int contentID = 0, int typeID = 0, string content = "")
{
CurtDevDataContext db = new CurtDevDataContext();
JavaScriptSerializer js = new JavaScriptSerializer();
FullContent newcontent = new FullContent();
try {
Content c = new Content();
ContentBridge cb = new ContentBridge();
if (contentID != 0) {
c = db.Contents.Where(x => x.contentID == contentID).First<Content>();
c.cTypeID = typeID;
c.text = content;
} else {
c = new Content {
cTypeID = typeID,
text = content
};
db.Contents.InsertOnSubmit(c);
db.SubmitChanges();
cb = new ContentBridge {
catID = catID,
contentID = c.contentID
};
db.ContentBridges.InsertOnSubmit(cb);
}
db.SubmitChanges();
newcontent = (from co in db.Contents
join ct in db.ContentTypes on co.cTypeID equals ct.cTypeID
where co.contentID == c.contentID
select new FullContent {
contentID = co.contentID,
content = co.text,
content_type = ct.type,
content_type_id = ct.cTypeID
}).FirstOrDefault<FullContent>();
} catch { };
return js.Serialize(newcontent);
}
