// Adds record to the table orders public static bool AddOrder(string dates, string amounts, string mats, string dests, string fashions, string types) { BufferData bufferData = BufferData.GetInstance(); int id = bufferData.OrdersViewTable.Data.Max(x => x.IdOrder) + 1; string date = ValidateField.ValidateDate(dates); int amount = ValidateField.ValidateNumber(amounts); mats = ValidateField.ValidateString(mats); dests = ValidateField.ValidateString(dests); fashions = ValidateField.ValidateString(fashions); types = ValidateField.ValidateString(types); int idDest = bufferData.DestinationTable.Data.First(x => x.Type == dests).IdDestination; int idState; int idFashion = bufferData.FashionTable.Data.First(x => x.Name == fashions).IdFashion; int idType = bufferData.MaterialTypeTable.Data.First(x => x.Name == types).IdMaterialType; int idMat = bufferData.MaterialTable.Data.First( x => x.Name == mats && x.IdFashion == idFashion && x.IdMaterialType == idType).IdMaterial; if ((StockCalculate.GetTotalExistMaterial(idMat) - amount) >= 0) { idState = 1; } else { idState = 2; } string query; query = "Insert into orders (id_order, date, amount_material, id_material, id_destination, id_state) values (" + id + ", '" + date + "', '" + amount + "', '" + idMat + "', '" + idDest + "', '" + idState + "');"; DepotDbConnector.GetInstance().InsertQuerry(query); return((idState == 1) ? true : false); }
public static void UpdateOrders(int oldId, string ids, string dates, string amounts, string idMats, string idDests, string idStates) { BufferData bufferData = BufferData.GetInstance(); int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList()); string date = ValidateField.ValidateDate(dates); int amount = ValidateField.ValidateNumber(amounts); int idMat = ValidateField.ValidateNumber(idMats); int idDest = ValidateField.ValidateNumber(idDests); int idState = ValidateField.ValidateNumber(idStates); if ((StockCalculate.GetTotalExistMaterial(idMat) - amount) >= 0) { idState = 1; } else { idState = 2; } string query; if (bufferData.EditMode == BufferData.EditModes.Update) { query = "Update orders set id_order = " + id + ", date = '" + date + "', amount_material = '" + amount + "', id_material = '" + idMat + "', id_destination = '" + idDest + "', id_state = '" + idState + "' where id_order = " + oldId + ";"; DepotDbConnector.GetInstance().UpdateQuerry(query); } if (bufferData.EditMode == BufferData.EditModes.Insert) { query = "Insert into orders (id_order, date, amount_material, id_material, id_destination, id_state) values (" + id + ", '" + date + "', '" + amount + "', '" + idMat + "', '" + idDest + "', '" + idState + "');"; DepotDbConnector.GetInstance().InsertQuerry(query); } }