partial void DeleteCartIntegration(CartIntegration instance);
partial void InsertCartIntegration(CartIntegration instance);
partial void UpdateCartIntegration(CartIntegration instance);
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 SetCustomerPart(int customerID = 0, string key = "", int partID = 0, int customerPartID = 0)
{
try {
CartIntegration integration = new CartIntegration {
custID = customerID,
custPartID = customerPartID,
partID = partID
};
Response.ContentType = "application/json";
Response.Write(JsonConvert.SerializeObject(integration.Set(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 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 void GetUnintegratedParts(int customerID = 0, string dataType = "", string callback = "")
{
// Validate the customerID
if (customerID == 0) {
Response.ContentType = "application/json";
Response.Write("You must provide your customer ID");
Response.End();
} else {
CartIntegration integration = new CartIntegration {
custID = customerID
};
if (dataType.ToUpper() == "JSON" || dataType.ToUpper() == "JSONP") { // Display JSON
string gridJSON = integration.GetUnintegratedPartsJSON();
if (dataType.ToUpper() == "JSONP") {
Response.ContentType = "application/x-javascript";
Response.Write(callback + "(" + gridJSON + ")");
} else {
Response.ContentType = "application/json";
Response.Write(gridJSON);
}
Response.End();
} else { // Display XML
Response.ContentType = "text/xml";
Response.Write(integration.GetUnintegratedPartsXML());
Response.End();
}
}
}
public CartIntegration Set(string key)
{
Authenticate(key);
CurtDevDataContext db = new CurtDevDataContext();
// Validate required fields
// This isn't working because the customer needs to be able to unlink
// if (this.custPartID == 0) { throw new Exception("Customer Part ID failed to validate against null or zero."); }
// - ajn
if (this.partID == 0) { throw new Exception("Part Number failed to validate against null or zero."); }
// Attempt to get a CustomerPricing record for this customerID and partID
List<CartIntegration> tmpIntegrations = db.CartIntegrations.Where(x => x.custID.Equals(this.custID) && x.partID.Equals(this.partID)).ToList<CartIntegration>();
CartIntegration newintegration = new CartIntegration();
List<CartIntegration> deleteables = new List<CartIntegration>();
bool updated = false;
foreach (CartIntegration tmpIntegration in tmpIntegrations) {
if (tmpIntegration.custPartID == 0) {
deleteables.Add(tmpIntegration);
} else {
if (!updated && this.custPartID > 0) {
tmpIntegration.custPartID = this.custPartID;
updated = true;
} else {
deleteables.Add(tmpIntegration);
}
}
}
if (!updated && this.custPartID > 0) {
newintegration = this;
newintegration.custID = this.custID;
db.CartIntegrations.InsertOnSubmit(newintegration);
}
if (deleteables.Count > 0) {
db.CartIntegrations.DeleteAllOnSubmit(deleteables);
}
db.SubmitChanges();
CartIntegration cartIntegration = new CartIntegration {
custID = this.custID,
partID = newintegration.partID,
custPartID = newintegration.custPartID,
referenceID = newintegration.referenceID
};
return cartIntegration;
}