/// <summary> /// This takes control of the input of new wares /// </summary> /// <param name="wares">Input a wares object</param> /// <returns>output a bool</returns> public bool NewWares(Wares ware1) { bool wareMade = false; Wares ware = new Wares(); List <Wares> wares = new List <Wares>(); int lastid = dBa.GetLastId("Wares"); ware1.waresID = lastid < 0 ? 1 : lastid + 1; /// <summary> /// Stored procedure InsertWare with parameters @wareName varchar(255), @volume float, @volumeType int /// </summary> if (dBa.NewOrUpdateDB("CALL InsertWare (Name = '" + ware1.wareName + "', Volume = ' " + ware1.volume + "' , VolumeType = '" + ware1.volumeType + "');") && /// <summary> /// Stored procedure InsertBoughtWare with parameters @boughtprice float, @volume int, @volumeType int, @waresID int /// </summary> dBa.NewOrUpdateDB("CALL InsertBoughtWare (Boughtprice = '" + ware1.buyPrice + "', Volume = ' " + ware1.volume + "' , VolumeType = '" + ware1.volumeTypeID + "', WaresID = '" + ware1.waresID + "',BoughtDate = '" + "" + "');")) { wareMade = true; } return(wareMade); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <param name="ware"></param> /// <returns></returns> public bool updateWares(int id, Wares ware) { bool updated = false; int volume = dBa.GetWareVolume(id); /// <summary> /// Stored procedure UpdateWare with parameters @id int, @volume int /// </summary> volume = volume + ware.volume; if (dBa.NewOrUpdateDB("CALL UpdateWare (Id = '" + id + "', Volume = '" + volume + "');")) { updated = true; } return(updated); }
/// <summary> /// Method to insert new wares than already exists in the database /// </summary> /// <param name="ware"></param> /// <returns></returns> public bool NewBoughtWare(Wares ware) { /// <summary> /// Stored procedure InsertBoughtWare with parameters @boughtprice float, @volume int, @volumeType int, @waresID int /// </summary> try { if (dBa.NewOrUpdateDB("CALL InsertBoughtWare (Boughtprice = '" + ware.buyPrice + "', Volume = ' " + ware.volume + "' , VolumeType = '" + ware.volumeTypeID + "', WaresID = '" + ware.waresID + "',BoughtDate = '" + "" + "');")) { return(true); } else { return(false); } } catch { return(false); throw new ArgumentException("Insert bought ware failed", "original"); } }