partial void UpdateCustomerPricing(CustomerPricing instance);
partial void DeleteCustomerPricing(CustomerPricing instance);
private void detach_CustomerPricings(CustomerPricing entity) { this.SendPropertyChanging(); entity.Customer = null; }
partial void InsertCustomerPricing(CustomerPricing instance);
public void SetPrice(string key = "") { try { int customerID = Convert.ToInt32(Request.Form["customerID"]); int partID = Convert.ToInt32(Request.Form["partID"]); decimal price = Convert.ToDecimal(Request.Form["price"]); int isSale = (Request.Form["isSale"] != null && Request.Form["isSale"] != "") ? Convert.ToInt32(Request.Form["isSale"]) : 0; string sale_start = (Request.Form["sale_start"] != null) ? Request.Form["sale_start"].Trim() : ""; string sale_end = (Request.Form["sale_end"] != null) ? Request.Form["sale_end"].Trim() : ""; CustomerPricing pricing = new CustomerPricing{ cust_id = customerID, partID = partID, price = price, isSale = isSale, sale_start = (sale_start.Length > 0) ? Convert.ToDateTime(sale_start) : (DateTime?)null, sale_end = (sale_end.Length > 0) ? Convert.ToDateTime(sale_end) : (DateTime?)null }; SimplePricing simpleprice = pricing.Set(key); Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject(simpleprice)); Response.End(); } catch (Exception e) { //Response.StatusCode = (int)System.Net.HttpStatusCode.InternalServerError; //Response.StatusDescription = e.Message; Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject(e.Message + " " + e.StackTrace,Formatting.Indented)); Response.End(); } }
/********* Customer Interaction *********/ public void GetPricing(int customerID = 0, string key = "") { try { CustomerPricing pricing = new CustomerPricing { cust_id = customerID }; Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject(pricing.GetAll(key))); Response.End(); } catch (Exception e) { Response.StatusCode = (int)System.Net.HttpStatusCode.InternalServerError; Response.StatusDescription = e.Message; Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject(e.Message, Formatting.Indented)); Response.End(); } }
public void SetCustomerPartAndPrice(int customerID = 0, string key = "", int partID = 0, int customerPartID = 0, decimal price = 0, int isSale = 0, string sale_start = "", string sale_end = "") { try { CartIntegration integration = new CartIntegration { custID = customerID, custPartID = customerPartID, partID = partID }; CartIntegration newintegration = integration.Set(key); CustomerPricing pricing = new CustomerPricing { cust_id = customerID, partID = partID, price = price, isSale = isSale, sale_start = (sale_start.Length > 0) ? Convert.ToDateTime(sale_start) : (DateTime?)null, sale_end = (sale_end.Length > 0) ? Convert.ToDateTime(sale_end) : (DateTime?)null }; SimplePricing newpricing = pricing.Set(key); List<object> results = new List<object>(); results.Add(newintegration); results.Add(newpricing); Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject(results)); Response.End(); } catch (Exception e) { //Response.StatusCode = (int)System.Net.HttpStatusCode.InternalServerError; //Response.StatusDescription = e.Message; Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject(e.Message, Formatting.Indented)); Response.End(); } }
public void ResetToMap(string key = "", int customerID = 0, int partID = 0) { try { CustomerPricing pricing = new CustomerPricing { cust_id = customerID, partID = partID }; Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject(pricing.SetToMap(key))); } catch (Exception e) { Response.StatusCode = (int)System.Net.HttpStatusCode.BadRequest; Response.StatusDescription = e.Message; Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject(e.Message + e.StackTrace, Formatting.Indented)); Response.End(); } }
public void RemoveSale(string key = "", int customerID = 0, int partID = 0, decimal price = 0) { try { CustomerPricing pricing = new CustomerPricing { cust_id = customerID, partID = partID, price = price, isSale = 1 }; pricing.RemoveSale(key); Response.ContentType = "application/json"; Response.Write(""); Response.End(); } catch (Exception e) { Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject(e.Message, Formatting.Indented)); Response.End(); } }
public void PriceUpload(string key = "", int customerID = 0) { try { if (key == "") { throw new Exception("Key is missing and is required"); } if (customerID == 0) { throw new Exception("Customer ID is missing and is required"); } StreamReader reader = new StreamReader(Request.InputStream); string pricedata = reader.ReadToEnd(); List<string> rows = pricedata.Split(new string[] { "\r\n", "\n" }, StringSplitOptions.None).ToList(); Parallel.ForEach(rows, currentRow => { try { List<string> fields = currentRow.Split(',').ToList(); int partID = Convert.ToInt32(fields[0]); int CustomerPartID = (fields[1].Trim() != "") ? Convert.ToInt32(fields[1]) : 0; decimal price = (fields[2].Trim() != "") ? Convert.ToDecimal(fields[2]) : 0; string sale_start = fields[3].Trim(); string sale_end = fields[4].Trim(); int isSale = (sale_start != "") ? 1 : 0; CustomerPricing pricing = new CustomerPricing { cust_id = customerID, partID = partID, price = price, isSale = isSale, sale_start = (sale_start.Length > 0) ? Convert.ToDateTime(sale_start) : (DateTime?)null, sale_end = (sale_end.Length > 0) ? Convert.ToDateTime(sale_end) : (DateTime?)null }; try { pricing.Set(key); } catch { } CartIntegration integration = new CartIntegration { custID = customerID, custPartID = CustomerPartID, partID = partID }; try { integration.Set(key); } catch { } } catch {} }); Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject("uploading", Formatting.Indented)); Response.End(); } catch (Exception e) { Response.StatusCode = (int)System.Net.HttpStatusCode.InternalServerError; Response.StatusDescription = e.Message; Response.ContentType = "application/json"; Response.Write(JsonConvert.SerializeObject(e.Message, Formatting.Indented)); Response.End(); } }
public SimplePricing Set(string key) { Authenticate(key); CurtDevDataContext db = new CurtDevDataContext(); // Validate required fields if (this.price == 0) { throw new Exception("Price failed to validate against null or zero."); } if (this.partID == 0) { throw new Exception("Part Number failed to validate against null or zero."); } if (this.isSale == 1) { if (this.sale_start == null || this.sale_start < DateTime.Today.AddDays(-1)) { throw new Exception("If record is going to marked as sale, sale start is required and cannot be in the past."); } if (this.sale_end == null || this.sale_end < DateTime.Now || this.sale_end <= this.sale_start) { throw new Exception("If record is going to marked as sale, sale end is required, cannot be in the past, and cannot be sooner or equal to the sale start."); } } else { this.sale_start = null; this.sale_end = null; } // Make sure the price point isn't set lower than map if (!checkMap()) { throw new Exception("You may not set the price point lower than map price."); } CustomerPricing newpricing = new CustomerPricing { cust_id = this.cust_id, partID = this.partID, price = this.price, isSale = this.isSale, sale_start = this.sale_start, sale_end = this.sale_end }; // Attempt to get a CustomerPricing record for this customerID and partID List<CustomerPricing> tmpPoints = db.CustomerPricings.Where(x => x.cust_id.Equals(this.cust_id) && x.partID.Equals(this.partID)).ToList<CustomerPricing>(); bool updated = false; List<CustomerPricing> deletables = new List<CustomerPricing>(); foreach (CustomerPricing tmpPoint in tmpPoints) { bool deleted = false; if (tmpPoint.sale_end != null && tmpPoint.sale_end < DateTime.Now) { // expired sale - delete deletables.Add(tmpPoint); deleted = true; } if (!deleted && this.isSale == tmpPoint.isSale) { if (!updated) { tmpPoint.price = this.price; tmpPoint.isSale = this.isSale; tmpPoint.sale_start = this.sale_start; tmpPoint.sale_end = this.sale_end; newpricing.cust_price_id = tmpPoint.cust_price_id; updated = true; } else { deletables.Add(tmpPoint); } } } if (!updated) { db.CustomerPricings.InsertOnSubmit(newpricing); } if (deletables.Count > 0) { db.CustomerPricings.DeleteAllOnSubmit(deletables); } db.SubmitChanges(); CustomerPricing currentPrice = db.CustomerPricings.Where(x => x.cust_price_id.Equals(newpricing.cust_price_id)).FirstOrDefault<CustomerPricing>(); SimplePricing pricePoint = new SimplePricing { cust_id = currentPrice.cust_id, partID = currentPrice.partID, price = currentPrice.price, isSale = currentPrice.isSale, sale_start = currentPrice.sale_start.ToString(), sale_end = currentPrice.sale_end.ToString() }; return pricePoint; }