public JsonResult CreateProductFormat(int ProductID, string Size, string Color, string StockQuantity, string Image) { if (string.IsNullOrWhiteSpace(Size) || string.IsNullOrWhiteSpace(Color) || string.IsNullOrWhiteSpace(StockQuantity) || string.IsNullOrWhiteSpace(Image)) { return(Json("填空區不可為空白")); } else { if (Regex.Match(StockQuantity, @"^\+?[1-9][0-9]*$").Success) { ProductFormatRepository repository = new ProductFormatRepository(); ProductFormat productFormat = new ProductFormat() { ProductID = ProductID, Size = Size, Color = Color, StockQuantity = int.Parse(StockQuantity), Image = Image }; repository.Create(productFormat); return(Json("")); } else { return(Json("庫存填寫無效")); } } }
public void Delete(ProductFormat model, IDbConnection connection) { connection.Execute("DELETE FROM ProductFormat WHERE ProductFormatID = @ProductFormatID", new { model.ProductFormatID }); }
public void Update(ProductFormat model, IDbConnection connection) { connection.Execute("UPDATE ProductFormat SET Size = @Size, Color = @Color, StockQuantity = @StockQuantity, Image=@Image WHERE ProductFormatID = @ProductFormatID", new { model.Size, model.Color, model.StockQuantity, model.Image, model.ProductFormatID }); }
public void Create(ProductFormat model, IDbConnection connection) { connection.Execute("INSERT INTO ProductFormat VALUES ( @ProductID, @Size, @Color, @StockQuantity, @Image)", new { model.ProductID, model.Size, model.Color, model.StockQuantity, model.Image }); }
public ProductFormat FindById(int ProductFormatID) { IDbConnection connection = new SqlConnection("data source=.; database=Commerce; integrated security=true"); var result = connection.Query <ProductFormat>("SELECT * FROM ProductFormat WHERE ProductFormatID = @ProductFormatID", new { ProductFormatID }); ProductFormat productFormat = null; foreach (var item in result) { productFormat = item; } return(productFormat); }
public void Delete(ProductFormat model) { SqlConnection connection = new SqlConnection( "data source=.; database=Commerce; integrated security=true"); var sql = "DELETE FROM ProductFormat WHERE ProductFormatID = @ProductFormatID "; SqlCommand command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@ProductFormatID", model.ProductFormatID); connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
public void Delete(ProductFormat model) //刪除 { SqlConnection connection = new SqlConnection( SqlConnectionString.ConnectionString()); var sql = "DELETE FROM ProductFormat WHERE ProductFormatID = @ProductFormatID"; SqlCommand command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@ProductFormatID", model.ProductFormatID); connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
public ProductFormat FindById(int ProductFormatID, IDbConnection connection) { var result = connection.Query <ProductFormat>("SELECT * FROM ProductFormat WHERE ProductFormatID = @ProductFormatID", new { ProductFormatID }); ProductFormat productFormat = null; foreach (var item in result) { productFormat = item; } return(productFormat); }
public void ProductFormat_Update() { var repository = new ProductFormatRepository(); ProductFormat productFormat = new ProductFormat() { ProductFormatID = 1, ProductID = 1, Color = "紅色", Size = "2L", StockQuantity = 40 }; repository.Update(productFormat); var productFormats = repository.FindById(1); Assert.IsTrue(productFormats.Size == "2L"); }
public void Create(ProductFormat model) //新增 { SqlConnection connection = new SqlConnection( SqlConnectionString.ConnectionString()); var sql = "INSERT INTO ProductFormat VALUES (@ProductID, @Size, @Color,@StockQuantity,@image)"; SqlCommand command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@ProductID", model.ProductID); command.Parameters.AddWithValue("@Size", model.Size); command.Parameters.AddWithValue("@Color", model.Color); command.Parameters.AddWithValue("@StockQuantity", model.StockQuantity); command.Parameters.AddWithValue("@image", model.Image); connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
public void Update(ProductFormat model) { SqlConnection connection = new SqlConnection( "data source=.; database=Commerce; integrated security=true"); var sql = "UPDATE ProductFormat SET Size = @Size, Color = @Color, StockQuantity = @StockQuantity WHERE ProductFormatID = @ProductFormatID"; SqlCommand command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@ProductFormatID", model.ProductFormatID); command.Parameters.AddWithValue("@ProductID", model.ProductID); command.Parameters.AddWithValue("@Size", model.Size); command.Parameters.AddWithValue("@Color", model.Color); command.Parameters.AddWithValue("@StockQuantity", model.StockQuantity); connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
public void Create(ProductFormat model) { SqlConnection connection = new SqlConnection( "data source=.; database=Commerce; integrated security=true"); var sql = "INSERT INTO ProductFormat VALUES ( @ProductID, @Size, @Color, @StockQuantity)"; SqlCommand command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@ProductID", model.ProductID); command.Parameters.AddWithValue("@Size", model.Size); command.Parameters.AddWithValue("@Color", model.Color); command.Parameters.AddWithValue("@StockQuantity", model.StockQuantity); connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
public void Update(ProductFormat model) //修改 { SqlConnection connection = new SqlConnection( SqlConnectionString.ConnectionString()); var sql = "UPDATE ProductFormat SET ProductID=@ProductID, Size=@Size, Color=@Color,StockQuantity =@StockQuantity ,image=@image WHERE ProductFormatID = @ProductFormatID"; SqlCommand command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@ProductFormatID", model.ProductFormatID); command.Parameters.AddWithValue("@ProductID", model.ProductID); command.Parameters.AddWithValue("@Size", model.Size); command.Parameters.AddWithValue("@Color", model.Color); command.Parameters.AddWithValue("@StockQuantity", model.StockQuantity); command.Parameters.AddWithValue("@image", model.Image); connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
public ProductFormat FindById(int ProductFormatID) { IDbConnection connection = new SqlConnection(SqlConnectionString.ConnectionString()); var result = connection.Query <ProductFormat>("SELECT * FROM ProductFormat WHERE ProductFormatID = @ProductFormatID", new { ProductFormatID }); ProductFormat productFormat = null; foreach (var item in result) { productFormat = item; } return(productFormat); //SqlConnection connection = new SqlConnection( // SqlConnectionString.ConnectionString()); //var sql = "SELECT * FROM ProductFormat WHERE ProductFormatID = @ProductFormatID"; //SqlCommand command = new SqlCommand(sql, connection); //command.Parameters.AddWithValue("@ProductFormatID", ProductFormatID); //connection.Open(); //var reader = command.ExecuteReader(CommandBehavior.CloseConnection); //ProductFormat productFormat = null; //while (reader.Read()) //{ // productFormat = new ProductFormat(); // productFormat.ProductFormatID = (int)reader.GetValue(reader.GetOrdinal("ProductFormatID")); // productFormat.ProductID = (int)reader.GetValue(reader.GetOrdinal("ProductID")); // productFormat.Size = reader.GetValue(reader.GetOrdinal("Size")).ToString(); // productFormat.Color = reader.GetValue(reader.GetOrdinal("Color")).ToString(); // productFormat.StockQuantity = (int)reader.GetValue(reader.GetOrdinal("StockQuantity")); //} //reader.Close(); //return productFormat; }