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