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
}
}
