public static void Add(Log log)
{
var db = new SoftwareStudioContext();
if (log != null)
{
db.logs.Add(log);
db.SaveChanges();
}
}
public static void AddWithTransaction(Transaction transaction)
{
var db = new SoftwareStudioContext();
if (transaction != null)
{
db.logs.Add(new Log(transaction));
db.SaveChanges();
}
}
public static void Remove(Item item)
{
var db = new SoftwareStudioContext();
if (item != null)
{
db.Remove(item);
db.SaveChanges();
}
}
public static async void RemoveItem(int itemID)
{
var db = new SoftwareStudioContext();
Laboratory_item labItem = await db.laboratory_items.FirstOrDefaultAsync(labItem => labItem.item_id == itemID);
if (labItem != null)
{
db.Remove(labItem);
db.SaveChanges();
}
}
public static void AddItem(int labID, int itemID)
{
var db = new SoftwareStudioContext();
Laboratory_item labItem = new Laboratory_item(labID, itemID);
if (labItem != null)
{
db.laboratory_items.Add(labItem);
db.SaveChanges();
}
}
public static void Cancel(Transaction transaction)
{
var db = new SoftwareStudioContext();
if (transaction != null)
{
var temp = db.transactions.Remove(transaction);;
transaction.transaction_type = (int)Transaction_type.cancel;
db.logs.Add(new Log(transaction));
db.SaveChanges();
}
}
public static void Delete(Transaction transaction)
{
var db = new SoftwareStudioContext();
if (transaction != null)
{
db.transactions.Remove(transaction);
transaction.transaction_type = (int)Transaction_type.give;
db.logs.Add(new Log(transaction));
db.SaveChanges();
}
}
public static int Register(User user)
{
Console.WriteLine("user {0}", user);
var db = new SoftwareStudioContext();
/// hash password.
string hashedPassword = BCrypt.Net.BCrypt.HashPassword(user.password);
user.password = hashedPassword;
db.users.Add(user);
db.SaveChanges();
return(0);
}
public static int Add(Item item)
{
var db = new SoftwareStudioContext();
if (item != null)
{
var change = db.items.Add(item);
db.SaveChanges();
return(change.Entity.uuid);
}
else
{
return(-1);
}
}
public static async Task <int> Add(Transaction transaction)
{
var db = new SoftwareStudioContext();
DateTime datetime_now = DateTime.Now;
int hour;
if (transaction.time_id == (int)Time_id_type.PM)
{
hour = 12;
}
else
{
hour = 8;
}
DateTime book_date = new DateTime(transaction.book_date.Year,
transaction.book_date.Month,
transaction.book_date.Day,
hour, 0, 0);
string query_string = $@"SELECT * FROM transactions
WHERE book_date = '{book_date.ToString("yyyy-MM-dd")}'
and (time_id = {transaction.time_id} or time_id={(int)Time_id_type.Day})
and (item_id = {transaction.item_id})";
List <Transaction> t = await db.transactions.FromSqlRaw(query_string).ToListAsync();
if (t.Count > 0)
{
return(1);
}
int result = DateTime.Compare(datetime_now, book_date);
if (result <= 0)
{
db.transactions.Add(transaction);
db.logs.Add(new Log(transaction));
db.SaveChanges();
return(0);
}
return(1);
}