public void placeOrder(Order order)
{
worker.run(context =>
{
//context.createCommand("INSERT INTO MARIADEMO.ORDERS (PRODUCT_ID, USER_ID, CREATED_AT, QUANTITY) VALUES (:PRODUCT_ID, :USER_ID, :CREATED_AT, :QUANTITY)")
//.addNumericInParam("PRODUCT_ID", order.product_id)
//.addNumericInParam("USER_ID", order.user_id)
//.addDateTimeInParam("CREATED_AT", order.creationDate)
//.addNumericInParam("QUANTITY", order.quantity)
//.execute();
try
{
var orderId = context.createSpCommand("MARIADEMO.MAIN.PLACE_ORDER")
.addNumericInParam("A_USER_ID", order.user_id)
.addDateTimeInParam("A_CREATED_AT", order.creationDate)
.addNumericOutParam("A_ORDER_ID")
.execute()
.paramValue <int>("A_ORDER_ID");
foreach (var orderDetail in order.orderDetails)
{
context.createSpCommand("MARIADEMO.MAIN.PLACE_ORDER_DETAILS")
.addNumericInParam("A_ORDER_ID", orderId)
.addNumericInParam("A_PRODUCT_ID", orderDetail.productId)
.addNumericInParam("A_QUANTITY", orderDetail.quantity)
.execute();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
});
}
public void createUser(User user)
{
worker.run(context =>
{
context.createCommand(@"INSERT INTO MARIADEMO.NOTEBOOK_USERS (NAME, PASSWORD)
VALUES(:NAME, :PASSWORD)")
.addStringInParam("NAME", user.name)
.addStringInParam("PASSWORD", user.password)
.execute();
});
}
public void createNews(News news)
{
worker.run(context =>
{
context
.createCommand("INSERT INTO MARIADEMO.NEWS (TITLE, DATE_UPLOADED, TEXT, SUBTEXT) VALUES (:TITLE, :DATE_UPLOADED, :TEXT, :SUBTEXT)")
.addStringInParam("TITLE", news.title)
.addStringInParam("TEXT", news.text)
.addStringInParam("SUBTEXT", news.subText)
.addDateTimeInParam("DATE_UPLOADED", news.dateUploaded)
.execute();
});
}
public void createNote(Note note, int userId)
{
worker.run(context =>
{
context
.createCommand("INSERT INTO MARIADEMO.NOTEBOOK (TEXT, DATE_UPLOADED, SUBTEXT, CATEGORY_ENUM, USER_ID) VALUES (:TEXT, :DATE_UPLOADED, :SUBTEXT, :CATEGORY_ENUM, :USER_ID)")
.addStringInParam("CATEGORY_ENUM", note.category)
.addStringInParam("TEXT", note.text)
.addStringInParam("SUBTEXT", note.subtext)
.addDateTimeInParam("DATE_UPLOADED", note.date)
.addNumericInParam("USER_ID", userId)
.execute();
});
}
public void createEvent(Events events)
{
worker.run(context =>
{
context
.createCommand("INSERT INTO MARIADEMO.EVENTS (TITLE, DESCRIPTION_OF_EVENT, COST_OF_EVENT, NUM_OF_PARTICIPANTS, DATE_PLACED, IMAGE_PATH) " +
"VALUES (:TITLE, :DESCRIPTION_OF_EVENT, :COST_OF_EVENT, :NUM_OF_PARTICIPANTS, :DATE_PLACED, :IMAGE_PATH)")
.addNumericInParam("COST_OF_EVENT", events.cost)
.addNumericInParam("NUM_OF_PARTICIPANTS", events.numOfParticipants)
.addStringInParam("TITLE", events.title)
.addStringInParam("DESCRIPTION_OF_EVENT", events.description)
.addStringInParam("IMAGE_PATH", events.imagePath)
.addDateTimeInParam("DATE_PLACED", events.date)
.execute();
});
}
public void insertPayment(UserCard userCard)
{
worker.run(context =>
{
context
.createCommand("INSERT INTO MARIADEMO.GNB_USER_PAYMENTS (USER_ID, CATEGORY_ID, DATE_OF_PAYMENT, PAYMENT, DATE_OF_SUBSCRIPTION, COMMENTS) " +
"VALUES (:USER_ID, :CATEGORY_ID, :DATE_OF_PAYMENT, :PAYMENT, :DATE_OF_SUBSCRIPTION, :COMMENTS)")
.addNumericInParam("USER_ID", userCard.userId)
.addNumericInParam("CATEGORY_ID", userCard.categoryId)
.addDateTimeInParam("DATE_OF_PAYMENT", userCard.dateOfPayment)
.addDateTimeInParam("DATE_OF_SUBSCRIPTION", userCard.dateOfPayment)
.addNumericInParam("PAYMENT", userCard.payment)
.addStringInParam("COMMENTS", userCard.comments)
.execute();
});
}
public void createSchedule(Scheduler scheduler)
{
worker.run(context =>
{
context
.createCommand("INSERT INTO MARIADEMO.SCHEDULER " +
"(TEXT, START_DATE, END_DATE, ALL_DAY, DESCRIPTION, RECURRENCE_RULE, HTML, DISABLED, END_DATE_TIME_ZONE, RECURRENCE_EXCEPTION, START_DATE_TIME_ZONE) " +
"VALUES" +
"(:TEXT, :START_DATE, :END_DATE, :ALL_DAY, :DESCRIPTION, :RECURRENCE_RULE, :HTML, :DISABLED, :END_DATE_TIME_ZONE, :RECURRENCE_EXCEPTION, :START_DATE_TIME_ZONE)")
.addStringInParam("TEXT", scheduler.text)
.addDateTimeInParam("START_DATE", scheduler.startDate)
.addDateTimeInParam("END_DATE", scheduler.endDate)
.addStringInParam("ALL_DAY", scheduler.allDay)
.addStringInParam("DESCRIPTION", scheduler.description)
.addStringInParam("RECURRENCE_RULE", scheduler.recurrenceRule)
.addStringInParam("HTML", scheduler.html)
.addStringInParam("DISABLED", scheduler.disabled)
.addStringInParam("END_DATE_TIME_ZONE", scheduler.endDateTimeZone)
.addStringInParam("RECURRENCE_EXCEPTION", scheduler.recurrenceException)
.addStringInParam("START_DATE_TIME_ZONE", scheduler.startDateTimeZone)
.execute();
});
}
//public UserRepository()
//{
// var user1 = new User { username = "******", password = "******", firstName = "Maria", lastName = "Kritou", age = 23, isAdmin = true };
// var user2 = new User { username = "******", password = "******", firstName = "Dimitris", lastName = "Maragkos", age = 25, isAdmin = true };
// var user3 = new User { username = "******", password = "******", firstName = "Vasilis", lastName = "Papoglou", age = 26, isAdmin = false };
// users.Add(user1);
// users.Add(user2);
// users.Add(user3);
//}
//public User login(string username, string password)
//{
// foreach (var user in users)
// {
// if (user.username == username && user.password == password)
// {
// return user;
// }
// }
// return null;
//}
public User login(string username, string password)
{
//var user = users.FirstOrDefault(p => p.username == username && p.password == password);
User user = null;
try
{
worker.run(context =>
{
user = context.createSpCommand("MARIADEMO.MAIN.LOGIN")
.addCursorOutParam("RET_VAL")
.addStringInParam("A_USERNAME", username)
.addStringInParam("A_PASSWORD", password)
.first <User>();
});
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(user);
}
public void createProduct(Product product)
{
worker.run(context =>
{
context
.createSpCommand("MARIADEMO.MAIN.CREATE_PRODUCT")
.addStringInParam("A_DESCRIPTION", product.description)
.addNumericInParam("A_PRICE", product.price)
.addNumericInParam("A_QUANTITY", product.quantity)
.addDateTimeInParam("A_ARRIVAL_DATE", product.arrivalDate)
.execute();
});
}
public void createUser(Users user)
{
worker.run(context =>
{
context.createCommand(@"INSERT INTO MARIADEMO.GNB_USERS (USERNAME, PASSWORD, NAME, SURNAME, ADDRESS, AGE, DAY_REGISTERED, IMAGE_PATH, MOBILE)
VALUES(:USERNAME, :PASSWORD, :NAME, :SURNAME, :ADDRESS, :AGE, :DAY_REGISTERED, :IMAGE_PATH, :MOBILE)")
.addStringInParam("USERNAME", user.username)
.addStringInParam("PASSWORD", PasswordHasher.hashPassword(user.password))
.addStringInParam("NAME", user.name)
.addStringInParam("SURNAME", user.surname)
.addNumericInParam("AGE", user.age)
.addStringInParam("IMAGE_PATH", user.imagePath)
.addDateTimeInParam("DAY_REGISTERED", user.dateRegistered)
.addStringInParam("ADDRESS", user.address)
.addStringInParam("MOBILE", user.mobile)
.execute();
});
}