public ActionResult checkOutItem(string personString, string itemString) { IoTDatabaseDataContext db = new IoTDatabaseDataContext(); ItemIssue ii = new ItemIssue(); int pID = -1; int.TryParse(personString, out pID); int iID = -1; int.TryParse(itemString, out iID); try { ii.personID = pID; ii.itemID = iID; ii.dateTaken = DateTime.Now; db.ItemIssues.InsertOnSubmit(ii); db.SubmitChanges(); } catch (Exception e) { }; return(RedirectToAction("index")); }
public ActionResult returnItem(string id) { IoTDatabaseDataContext db = new IoTDatabaseDataContext(); int iID = -1; int.TryParse(id, out iID); string result; if (iID == -1) { ItemIssue select = (from item in db.ItemIssues where item.issueID == iID select item).First(); select.itemReturned = true; select.dateReturned = DateTime.Now; db.SubmitChanges(); result = "item returned"; } else { result = "No item"; } return(RedirectToAction("result", "Home", new { area = "", result = result })); }
// DELETE api/<controller>/5 public void Delete(int id) { IoTDatabaseDataContext db = new IoTDatabaseDataContext(); ItemIssue item = db.ItemIssues.Where(x => x.issueID == id).Single(); db.ItemIssues.DeleteOnSubmit(item); db.SubmitChanges(); }
public Boolean add() { string qryStringMember; qryStringMember = "Insert into tbl_defective_items (item_id, no_of_defective_item, item_issue, user_id, date_added) VALUES (@item_id, @no_of_defective_item, @item_issue, @user_id, NOW())"; try { Connect.CnSql = new MySqlConnection(Connect.ConnStr); Connect.CnSql.Open(); Connect.CmSql = new MySqlCommand(qryStringMember, Connect.CnSql); Connect.CmSql.Parameters.AddWithValue("@item_id", ItemId.Trim()); Connect.CmSql.Parameters.AddWithValue("@no_of_defective_item", NoOfDefectiveItem); Connect.CmSql.Parameters.AddWithValue("@item_issue", ItemIssue.Trim()); Connect.CmSql.Parameters.AddWithValue("@user_id", UserId); Trans = Connect.CnSql.BeginTransaction(); Connect.CmSql.Transaction = Trans; Connect.CmSql.ExecuteNonQuery(); Trans.Commit(); return(true); } catch (MySqlException e) { XtraMessageBox.Show(e.Message, "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); Trans.Rollback(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "General Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); Trans.Rollback(); } finally { Connect.CnSql.Close(); Connect.CnSql.Dispose(); Connect.CmSql.Dispose(); Connect.CmSql = null; Connect.DrSql = null; } return(false); }
public void Post([FromBody] newItemIssued json) { IoTDatabaseDataContext db = new IoTDatabaseDataContext(); ItemIssue newItemIssue = new ItemIssue(); newItemIssue.personID = json.personID; newItemIssue.itemID = json.itemID; newItemIssue.dateTaken = DateTime.Now; db.ItemIssues.InsertOnSubmit(newItemIssue); try { db.SubmitChanges(); } catch (Exception e) { //bad foreign keys } }