/// Delete Procedure Data Controller
public bool DeleteStock(stockModel removingStock)
{
DbCommand sp_deletect2Stock = db.GetStoredProcCommand("sp_deletect2Stock");
db.AddInParameter(sp_deletect2Stock, "@stockID", SqlDbType.Int, removingStock.stockID);
return(false);
}
///Update Procedure Data Controller
public bool UpdateStock(stockModel currentStock)
{
DbCommand sp_updatect2Stock = db.GetStoredProcCommand("sp_updatect2Stock");
db.AddInParameter(sp_updatect2Stock, "@stockID", SqlDbType.Int, currentStock.stockID);
db.AddInParameter(sp_updatect2Stock, "@categoryIDFK", SqlDbType.Int, currentStock.category);
db.AddInParameter(sp_updatect2Stock, "@stockQuantity", SqlDbType.Int, currentStock.stockQuantity);
db.AddInParameter(sp_updatect2Stock, "@locationCode", SqlDbType.VarChar, currentStock.locationCode);
return(false);
}
public bool placeOrderByStockId(int id)
{
bool success = false;
using (var context = new dbContext())
{
stockModel Stock = context.Stocks.SingleOrDefault(r => r.id == id);
driver.Navigate().GoToUrl(Stock.url);
//Thread.Sleep(10000);
//string css = "div.sort-list:first-child .view-all";
//IWebElement ViewAll = driver.FindElement(By.CssSelector(css));
//ViewAll.Click();
//css = ".products li:nth-child(" + Stock.countId + ") div";
//IWebElement product = driver.FindElement(By.CssSelector(css));
//product.Click();
string css = "ul li:first-child div";
IWebElement color = driver.FindElement(By.CssSelector(css));
color.Click();
((IJavaScriptExecutor)driver).ExecuteScript("$('.chosen :nth(1)').attr('selected', true)");
((IJavaScriptExecutor)driver).ExecuteScript(" $('.add-button button').click()");
Thread.Sleep(3000);
string returnMessage = (string)((IJavaScriptExecutor)driver).ExecuteScript("return $('.errors div:nth(2)').text()");
if (returnMessage == "We're sorry, the selected item does not have 1 item in stock. Please try again.")
{
success = false;
using (var contexts = new dbContext())
{
Stock.inStock = false;
contexts.Stocks.Attach(Stock);
var entry = contexts.Entry(Stock);
entry.Property(e => e.inStock).IsModified = true;
// other changed properties
contexts.SaveChanges();
}
}
if (returnMessage != "We're sorry, the selected item does not have 1 item in stock. Please try again.")
{
success = true;
}
}
return(success);
}
///Create Procedure Data Controller
public int createStock(stockModel currentStock)
{
int success;
DbCommand sp_createct2Stock = db.GetStoredProcCommand("sp_createct2Stock");
sp_createct2Stock.Connection = db.CreateConnection();
sp_createct2Stock.Connection.Open();
db.AddInParameter(sp_createct2Stock, "@categoryIDFK", SqlDbType.Int, currentStock.category);
db.AddInParameter(sp_createct2Stock, "@stockQuantity", SqlDbType.Int, currentStock.stockQuantity);
db.AddInParameter(sp_createct2Stock, "@locationCode", SqlDbType.VarChar, currentStock.locationCode);
success = sp_createct2Stock.ExecuteNonQuery();
return(success);
}
