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 string DeleteVehiclePartAttribute(int attrID = 0) { try { // Validate if (attrID <= 0) { throw new Exception("Attribute ID is invalid."); } // Variable Declaration CurtDevDataContext db = new CurtDevDataContext(); VehiclePartAttribute vpa = new VehiclePartAttribute(); vpa = (from p in db.VehiclePartAttributes where p.vpAttrID.Equals(attrID) select p).FirstOrDefault<VehiclePartAttribute>(); int pid = vpa.vPartID; db.VehiclePartAttributes.DeleteOnSubmit(vpa); db.SubmitChanges(); updateVehicleAttributeSort(getVehiclePartAttributeIDs(pid)); db.indexPart(vpa.VehiclePart.partID); UpdatePart(vpa.VehiclePart.partID); return ""; } catch (Exception e) { return e.Message; } }
public static VehiclePartAttribute AddVehiclePartAttribute(int vPartID = 0, string field = "", string value = "") { // Validate fields if (vPartID <= 0) { throw new Exception("Vehicle Part ID is invalid."); } if (field.Length <= 0) { throw new Exception("Field is invalid."); } if (value.Length <= 0) { throw new Exception("Value is invalid."); } // Declare objects CurtDevDataContext db = new CurtDevDataContext(); VehiclePartAttribute vpa = new VehiclePartAttribute { vPartID = vPartID, field = field, value = value, sort = (db.VehiclePartAttributes.Where(x => x.vPartID.Equals(vPartID)).OrderByDescending(x => x.sort).Select(x => x.sort).FirstOrDefault() + 1) }; VehiclePart v = (from vp in db.VehicleParts where vp.vPartID == vPartID select vp).FirstOrDefault<VehiclePart>(); if (field.ToLower().Contains("install")) { Match match = Regex.Match(value, @"\d+"); if (match.Success) { string result = match.Groups[0].Value; int duration = Convert.ToInt32(result); v.installTime = duration; } } if (field.ToLower().Contains("visibility")) { v.exposed = value; }; if (field.ToLower().Contains("drill")) { if (value.ToLower() == "no") { v.drilling = "No drilling required"; } else { v.drilling = "Drilling required"; } }; // Commit to database db.VehiclePartAttributes.InsertOnSubmit(vpa); db.SubmitChanges(); updateVehicleAttributeSort(getVehiclePartAttributeIDs(vPartID)); UpdatePart(vpa.VehiclePart.partID); //db.indexPart(partID); // Return PartAttribute return vpa; }
public static FullVehicle CarryOverPart(int vehicleID = 0, int partID = 0) { try { CurtDevDataContext db = new CurtDevDataContext(); CarryOverInfo latest = GetLatestVehiclePart(vehicleID, partID); VehiclePart latestvp = db.VehicleParts.Where(x => x.vehicleID == vehicleID).Where(x => x.partID == partID).First<VehiclePart>(); List<VehiclePartAttribute> vpas = db.VehiclePartAttributes.Where(x => x.vPartID == latestvp.vPartID).ToList<VehiclePartAttribute>(); List<VehiclePartAttribute> newvpas = new List<VehiclePartAttribute>(); double year = latest.year + 1; int yearID = 0; try { yearID = db.Years.Where(x => x.year1 == year).Select(x => x.yearID).First(); } catch { Year y = new Year { year1 = year }; db.Years.InsertOnSubmit(y); db.SubmitChanges(); yearID = y.yearID; }; try { YearMake ym = db.YearMakes.Where(x => x.yearID.Equals(yearID)).Where(x => x.makeID.Equals(latest.makeID)).First<YearMake>(); } catch { YearMake ym = new YearMake { yearID = yearID, makeID = latest.makeID }; db.YearMakes.InsertOnSubmit(ym); db.SubmitChanges(); } int vID = Vehicle.GetVehicleID(yearID, latest.makeID, latest.modelID, latest.styleID); if (vID == 0) { Vehicles v = new Vehicles { yearID = yearID, makeID = latest.makeID, modelID = latest.modelID, styleID = latest.styleID, dateAdded = DateTime.Now }; db.Vehicles.InsertOnSubmit(v); db.SubmitChanges(); vID = v.vehicleID; } List<VehiclePart> parts = new List<VehiclePart>(); foreach (int partnum in latest.partids) { if (db.VehicleParts.Where(x => x.partID.Equals(partnum)).Where(x => x.vehicleID.Equals(vID)).Count() == 0) { VehiclePart vp = new VehiclePart { vehicleID = vID, partID = partnum, drilling = latestvp.drilling, exposed = latestvp.exposed, installTime = latestvp.installTime }; parts.Add(vp); } } db.VehicleParts.InsertAllOnSubmit(parts); db.SubmitChanges(); foreach (VehiclePart part in parts) { newvpas = new List<VehiclePartAttribute>(); foreach (VehiclePartAttribute vpa in vpas) { VehiclePartAttribute newvpa = new VehiclePartAttribute { vPartID = part.vPartID, field = vpa.field, value = vpa.value }; newvpas.Add(newvpa); }; db.VehiclePartAttributes.InsertAllOnSubmit(newvpas); db.SubmitChanges(); }; UpdatePart(partID); return Vehicle.GetFullVehicle(vID); } catch (Exception e) { throw new Exception(e.Message); } }
internal static VehiclePartAttribute GetVehiclePartAttribute(int vpAttrID = 0) { CurtDevDataContext db = new CurtDevDataContext(); VehiclePartAttribute attribute = new VehiclePartAttribute(); attribute = (from a in db.VehiclePartAttributes where a.vpAttrID.Equals(vpAttrID) select a).FirstOrDefault<VehiclePartAttribute>(); return attribute; }