/// <summary> /// Adds a replacement to the database /// </summary> /// <param name="replacement">The <see cref="ReplacementVM"/> to add to the database</param> /// <param name="path">The path to the database</param> /// <returns></returns> public static short AddReplacementToDB(ReplacementVM replacement, string path = DEFAULTPATH) { try { // connect to the database using (SQLiteConnection con = new SQLiteConnection(path)) { // get the required tables of the database con.CreateTable <ReplacementVM>(); var existingReplacement = con.Find <ReplacementVM>(replacement.Original); if (existingReplacement == null) { con.Insert(replacement); } else { existingReplacement.Replaced = replacement.Replaced; con.RunInTransaction(() => { con.Update(existingReplacement); }); } } return(1); } catch (Exception ex) { Logger.Log("AddReplacementToDB : " + ex); return(-1); } }
public JsonResult CancelReplacement(ReplacementVM replacement) { var myContent = JsonConvert.SerializeObject(replacement); var buffer = System.Text.Encoding.UTF8.GetBytes(myContent); var byteContent = new ByteArrayContent(buffer); byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); var result = client.PutAsync("Replacement/CancelReplacement/" + replacement.Id, byteContent).Result; return(Json(result)); }