/// <summary> /// Update verification in Verifications table /// </summary> /// <param name="verification"></param> public static void UpdateVerification2(Verification verification) { using (var context = new DatabaseEntities()) { Verification v = context.Verifications.FirstOrDefault(x => x.verificationID == verification.verificationID); v.expenceID = verification.expenceID; v.cost = verification.cost; v.path = verification.path; v.date = verification.date; v.note = verification.note; v.tripID = verification.tripID; context.SaveChanges(); } }
//Lägger till kommentaren som användaren(senderID) kommenteraren(comment) på personens(wallOwnerID) wall public static void AddWallComment(int wallOwnerID, int senderID, string comment, DateTime date) { using (var context = new DatabaseEntities()) { Wall w = new Wall { WallOwnerID = wallOwnerID, SenderID = senderID, Comment = comment, Date = date }; context.Walls.Add(w); context.SaveChanges(); } }
/// <summary> /// Update verification in Verifications table /// </summary> /// <param name="vID"></param> /// <param name="expenceID"></param> /// <param name="cost"></param> /// <param name="path"></param> /// <param name="date"></param> /// <param name="note"></param> /// <param name="id"></param> public static void UpdateVerification(int vID, int expenceID, int cost, string path, DateTime date, string note, int id) { using (var context = new DatabaseEntities()) { Verification v = context.Verifications.FirstOrDefault(x => x.verificationID == vID); v.expenceID = expenceID; v.cost = cost; v.path = path; v.date = date; v.note = note; v.tripID = id; context.SaveChanges(); } }