public void InsertIntoBranch(ProductsInBranches pib)
{
rowsAffected = 0;
// Create SQL statement to submit
string sql = "INSERT INTO [Categories](Parent_Category,Category_Name )";
sql += $" VALUES( '{pib.Product_code}','{pib.Branch_name}', '{pib.Quantity}')";
try
{
using (SqlConnection cnn = new SqlConnection(AppSettings.ConnectionString))
{
// Create command object in using block for automatic disposal
using (SqlCommand cmd = new SqlCommand(sql, cnn))
{
// Set CommandType
cmd.CommandType = CommandType.Text;
// Open the connection
cnn.Open();
// Execute the INSERT statement
rowsAffected = cmd.ExecuteNonQuery();
ResultText = "Rows Affected: " + rowsAffected.ToString();
}
}
}
catch (Exception ex)
{
ResultText = ex.ToString();
}
}
public ActionResult DeleteProductInBranches([FromBody] ProductsInBranches products_In_Branches, string product_code)
{
try
{
DataAccessPIB da = new DataAccessPIB();
da.DeleteProductInBranches(product_code);
}
catch (Exception ex)
{
return(BadRequest(ex));
}
return(Ok());
}
public ActionResult PostProductInBranch(ProductsInBranches pib)
{
try
{
DataAccessPIB da = new DataAccessPIB();
da.InsertIntoBranch(pib);
}
catch (Exception ex)
{
return(BadRequest(ex));
}
return(Ok());
}
/// <summary>
/// Add or Update Product in Branch
/// </summary>
/// <param name="productInBranch"></param>
/// <returns></returns>
public Int32 AddUpdateProductInBranch(ProductsInBranches productInBranch)
{
#region Parameters
IParameter[] parameters = new Parameter[] {
new Parameter("@ProductID", productInBranch.ProductID),
new Parameter("@BranchID", productInBranch.BranchID),
new Parameter("@Enable", productInBranch.Enable),
new Parameter("@Price", productInBranch.Price)
};
#endregion
object result = DBHandler.ExecuteScalar(System.Data.CommandType.StoredProcedure, "[BranchProduct_AddUpdateProductInBranch]", parameters);
return(Convert.ToInt32(result));
}
protected void SaveBtn_Click(object sender, ImageClickEventArgs e)
{
try
{
if (!string.IsNullOrEmpty(txtBranch.SelectedValue) && !string.IsNullOrEmpty(txtProduct.SelectedValue) && txtPrice.Value != null)
{
ProductsInBranches productInBranch = new ProductsInBranches();
int result = 0;
productInBranch.BranchID = Int32.Parse(txtBranch.SelectedValue);
productInBranch.ProductID = Int32.Parse(txtProduct.SelectedValue);
productInBranch.Price = txtPrice.Value.Value;
productInBranch.Enable = txtActive.Checked;
result = _prodictInBranchManager.AddUpdateProductInBranch(productInBranch);
if (result > 0)
{
if (ViewStateID != null)
{
ShowMessage(txtProduct.SelectedItem.Text + " has been updated with default price of $" + txtPrice.Value, MessageType.Success);
}
else
{
ShowMessage(txtProduct.SelectedItem.Text + " added into branch(" + txtBranch.SelectedItem.Text + ") with default price of $" + txtPrice.Value, MessageType.Success);
BindProducts();
}
txtError.ForeColor = System.Drawing.Color.Green;
txtError.ViewStateMode = System.Web.UI.ViewStateMode.Disabled;
}
}
else
{
ShowMessage("There should be all values to make new entry.", MessageType.Error);
}
}
catch (Exception ex)
{
txtError.Text = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Int32 branchProductId = 0;
if (Int32.TryParse(QueryStringParamID, out branchProductId))
{
ProductInBranchObj = _prodictInBranchManager.GetProductInBranchById(branchProductId);
if (ProductInBranchObj != null)
{
BindBranches();
BindProducts();
txtPrice.Value = ProductInBranchObj.Price;
txtActive.Enabled = ProductInBranchObj.Enable;
ViewStateID = QueryStringParamID.ToString();
}
}
else
{
BindBranches();
BindProducts();
}
}
}
