//non-static user defeine method returning a value public bool loginAttempt(LoginAttempt loginDetails) { using (InventorydbEntities dbContext = new InventorydbEntities()) { IEnumerable <User> result; //try //{ //database access result = from login in dbContext.Users where login.User_username.Trim() == loginDetails.Username.Trim() && login.User_password.Trim() == loginDetails.Password.Trim() select login; if (result.Any()) { return(true); } else { return(false); } //} //catch //{ // MessageBox.Show("not working"); // return false; //} } }
//non-static user defeine method returning a value public bool createUser(User userDetails) { // using block assists with memory management for temporary objects using (InventorydbEntities dbContext = new InventorydbEntities()) { IEnumerable <User> result; try { //linq query-no sql required result = from user in dbContext.Users where user.User_username.Trim() == userDetails.User_username select user; if (!result.Any()) { dbContext.Users.Add(userDetails); dbContext.SaveChanges(); MessageBox.Show("Record Saved"); return(true); } else { //validation MessageBox.Show("A record with that username already exists"); return(false); } } catch { //validation MessageBox.Show("Unable to communicate with Database or Access is denied"); return(false); } } }
public static Asset GetAsset(string asset_id) { using (InventorydbEntities dbContext = new InventorydbEntities()) { IEnumerable <Asset> result; try { result = from asset in dbContext.Assets where asset.Asset_id == asset_id select asset; if (result.Any()) { return(result.First()); } else { return(null); } } catch { MessageBox.Show("Unable to communicate with Database or Access is denied"); return(null); } } }
public static Reservation GetReservation(int reservation_id) { using (InventorydbEntities dbContext = new InventorydbEntities()) { IEnumerable <Reservation> result; try { result = from reservation in dbContext.Reservations where reservation.Reservation_id == reservation_id select reservation; if (result.Any()) { return(result.First()); } else { return(null); } } catch { MessageBox.Show("Unable to communicate with Database or Access is denied"); return(null); } } }
public static DataTable getReservationDataSource() { DataTable dataTable = new DataTable(); dataTable.Columns.Add("Reservation ID", typeof(string)); dataTable.Columns.Add("Reservation Start", typeof(string)); dataTable.Columns.Add("Reservation End", typeof(string)); using (InventorydbEntities dbContext = new InventorydbEntities()) { try { IEnumerable <Reservation> reservationResult = from asset in dbContext.Reservations select asset; if (reservationResult.Any()) { foreach (Reservation item in reservationResult) { dataTable.Rows.Add(item.Reservation_id, item.Reservation_start, item.Reservation_end); } } } catch { } return(dataTable); } }
public static DataTable getAssetDataSource() { DataTable dataTable = new DataTable(); dataTable.Columns.Add("Asset ID", typeof(string)); dataTable.Columns.Add("Asset Name", typeof(string)); dataTable.Columns.Add("Asset Status", typeof(string)); using (InventorydbEntities dbContext = new InventorydbEntities()) { try { IEnumerable <Asset> assetResult = from asset in dbContext.Assets select asset; if (assetResult.Any()) { foreach (Asset item in assetResult) { dataTable.Rows.Add(item.Asset_id, item.Asset_name, item.asset_status); } } } catch { } return(dataTable); } }
//non-static user defeine method returning a value public bool newAsset(Asset newAsset) { using (InventorydbEntities dbContext = new InventorydbEntities()) { IEnumerable <Asset> result; try { result = from asset in dbContext.Assets where asset.Asset_id == newAsset.Asset_id select asset; if (!result.Any()) { dbContext.Assets.Add(newAsset); dbContext.SaveChanges(); MessageBox.Show("Record Saved"); return(true); } else { MessageBox.Show("A record with that ID already exists"); return(false); } } catch { MessageBox.Show("Unable to communicate with Database or Access is denied"); return(false); } } }
//static user defined method public static void getAssets(ComboBox list) { using (InventorydbEntities dbContext = new InventorydbEntities()) { try { //linq query-no sql required var result = from asset in dbContext.Assets select asset.Asset_id; foreach (string asset in result) { list.Items.Add(asset); } } catch { MessageBox.Show("not working"); } } }
public static void DeleteReservation(int reservationId) { using (InventorydbEntities dbContext = new InventorydbEntities()) { IEnumerable <Reservation> result; try { result = from reservation in dbContext.Reservations where reservation.Reservation_id == reservationId select reservation; if (result.Any()) { dbContext.Reservations.Remove(result.First()); dbContext.SaveChanges(); } } catch { MessageBox.Show("Unable to communicate with Database or Access is denied"); } } }
public static void DeleteAsset(string asset_id) { using (InventorydbEntities dbContext = new InventorydbEntities()) { IEnumerable <Asset> result; try { result = from asset in dbContext.Assets where asset.Asset_id == asset_id select asset; if (result.Any()) { dbContext.Assets.Remove(result.First()); dbContext.SaveChanges(); } } catch { MessageBox.Show("Unable to communicate with Database or Access is denied"); } } }
// public static bool newReservation(Reservation details) { using (InventorydbEntities dbContext = new InventorydbEntities()) { try { IEnumerable <Asset> assetResult = from asset in dbContext.Assets where asset.Asset_id == details.Asset_AssetId select asset; if (assetResult.Any()) { if (assetResult.First().Reservations.Any(r => ((r.Reservation_end.CompareTo(details.Reservation_start) > 0) && (r.Reservation_start.CompareTo(details.Reservation_end) < 0)))) { MessageBox.Show("Reservation Conflict"); return(false); } else { assetResult.First().Reservations.Add(details); dbContext.SaveChanges(); return(true); } } else { MessageBox.Show("Cannot add record, asset not found"); return(false); } } catch { return(false); } } }
public static void editReservation(Reservation changed_Reservation) { using (InventorydbEntities dbContext = new InventorydbEntities()) { IEnumerable <Reservation> result; try { result = from reservation in dbContext.Reservations where reservation.Reservation_id == changed_Reservation.Reservation_id select reservation; if (result.Any()) { result.First().Reservation_start = changed_Reservation.Reservation_start; result.First().Reservation_end = changed_Reservation.Reservation_end; dbContext.SaveChanges(); } } catch { MessageBox.Show("Unable to communicate with Database or Access is denied"); } } }
public static void editAsset(Asset changed_Asset) { using (InventorydbEntities dbContext = new InventorydbEntities()) { IEnumerable <Asset> result; try { result = from asset in dbContext.Assets where asset.Asset_id == changed_Asset.Asset_id select asset; if (result.Any()) { result.First().Asset_name = changed_Asset.Asset_name; result.First().Asset_description = changed_Asset.Asset_description; dbContext.SaveChanges(); } } catch { MessageBox.Show("Unable to communicate with Database or Access is denied"); } } }