/// <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();
}
}