static public List <CheckLog> GetData(string from, string to) { CheckLogConnector sc = new CheckLogConnector(); string dbFromDateTime = SQLDBConnector.CovertDateToDB(SQLDBConnector.ConvertStringToDate(from)); string dbToDateTime = SQLDBConnector.CovertDateToDB(SQLDBConnector.ConvertStringToDate(to)); List <CheckLog> result = sc.SelectAllData(dbFromDateTime, dbToDateTime); return(result); }
public void MakeTransaction(bool status) { DateTime now = DateTime.Now; DateTime expiryDate = now.AddDays(this.ItemCategory.Duration); this.CheckoutDate = SQLDBConnector.CovertDateToDB(now); this.ExpiryDate = SQLDBConnector.CovertDateToDB(expiryDate); ItemConnector sc = new ItemConnector(); if (status) { sc.UpdateItem(this.Barcode, this.Barcode, this.ItemDescription, status, this.ItemCategory.CategoryName, "NULL", "NULL", "NULL", this.Initial); CheckLog.TransactionItem(this.StudentNo, this.Barcode, this.ItemDescription, this.Initial, status, "NULL"); } else { sc.UpdateItem(this.Barcode, this.Barcode, this.ItemDescription, status, this.ItemCategory.CategoryName, this.StudentNo, this.CheckoutDate, this.ExpiryDate, this.Initial); CheckLog.TransactionItem(this.StudentNo, this.Barcode, this.ItemDescription, this.Initial, status, this.ExpiryDate); } //CheckLog cl = new CheckLog(); }