public virtual int Add()
{
//first parameter is always the stored proceudure output
Param[0].Direction = ParameterDirection.Output;
int id = da.ExecSP(CommandType.StoredProcedure, SProcedureName, Param);
return(id);
}
public int Add()
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@BOM_id", Id),
new SqlParameter("@PRODUCT_id", ProductId),
new SqlParameter("@PART_id", PartID),
new SqlParameter("@BOM_partquantity", partQuantity),
};
param[0].Direction = ParameterDirection.Output;
return(da.ExecSP(CommandType.StoredProcedure, "usp_InsertBOM", param));
}
public int Add()
{
SqlParameter[] param2 = new SqlParameter[] {
new SqlParameter("@PARTSUPPLIER_id", Id),
new SqlParameter("@PART_id", PartId),
new SqlParameter("@SUPPLIER_id", SupplierId),
new SqlParameter("@PARTSUPPLIER_cost", Price),
};
param2[0].Direction = ParameterDirection.Output;
return(da.ExecSP(CommandType.StoredProcedure, "usp_InsertPARTSUPPLIER", param2));
}
public int Add()
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@PART_id", Id),
new SqlParameter("@PART_name", Name),
new SqlParameter("@PART_color", Color)
};
param[0].Direction = ParameterDirection.Output;
int i = da.ExecSP(CommandType.StoredProcedure, "usp_InsertPART", param);
return(i);
}
public int Add()
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@CUSTOMER_id", Id),
new SqlParameter("@CUSTOMER_name", Name),
new SqlParameter("@CUSTOMER_phone", Phone),
new SqlParameter("@CUSTOMER_email", Email),
new SqlParameter("@CUSTOMER_address", Address)
};
param[0].Direction = ParameterDirection.Output;
return(da.ExecSP(CommandType.StoredProcedure, "usp_InsertCUSTOMER", param));
}
public int Add()
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@SORDER_id", Id),
new SqlParameter("@SORDER_date", OrderDate),
new SqlParameter("@SORDER_totalprice", TotalPrice),
new SqlParameter("@SORDER_status", Status),
new SqlParameter("@ORDER_id", OrderId),
};
param[0].Direction = ParameterDirection.Output;
return(da.ExecSP(CommandType.StoredProcedure, "usp_InsertSORDER", param));
}
public int AddOrderDetails()
{
SqlParameter[] param2 = new SqlParameter[] {
new SqlParameter("@ORDERDETAIL_id", Id),
new SqlParameter("@PRODUCT_id", ProductId),
new SqlParameter("@ORDER_id", OrderId),
new SqlParameter("@ORDERDETAIL_quantity", Quantity),
new SqlParameter("@ORDERDETAIL_deliverytime", DBNull.Value),
new SqlParameter("@ORDERDETAIL_price", Price),
};
param2[0].Direction = ParameterDirection.Output;
return(da.ExecSP(CommandType.StoredProcedure, "usp_InsertORDERDETAIL", param2));
}
public int Add()
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@PRODUCT_id", Id),
new SqlParameter("@PRODUCT_name", name),
new SqlParameter("@PRODUCT_cost", cost),
new SqlParameter("@PRODUCT_price", price),
new SqlParameter("@PRODUCT_color", color),
new SqlParameter("@PRODUCT_description", description),
new SqlParameter("@PRODUCT_picture", pic),
};
param[0].Direction = ParameterDirection.Output;
int i = da.ExecSP(CommandType.StoredProcedure, "usp_InsertPRODUCT", param);
return(i);
}
public int Add()
{
Id = 0;
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@SUPPLIER_id", SupId),
new SqlParameter("@SUPPLIER_name", name),
new SqlParameter("@SUPPLIER_phone", phone),
new SqlParameter("@SUPPLIER_email", email),
new SqlParameter("@SUPPLIER_address", address),
new SqlParameter("@SUPPLIER_postalcode", PostalCode),
new SqlParameter("@SUPPLIER_province", Province),
new SqlParameter("@SUPPLIER_timesfailed", TimesFailed),
};
param[0].Direction = ParameterDirection.Output;
return(da.ExecSP(CommandType.StoredProcedure, "usp_InsertSUPPLIER", param));
}
public int Add()
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@SORDERDETAIL_id", Id),
new SqlParameter("@SORDER_id", SorderId),
new SqlParameter("@PART_id", PartId),
new SqlParameter("@SUPPLIER_id", SupplierId),
new SqlParameter("@ORDERDETAIL_quantity", Quantity),
new SqlParameter("@SORDERDETAIL_deliverytime", DBNull.Value),
new SqlParameter("@ORDERDETAIL_price", Price),
};
param[0].Direction = ParameterDirection.Output;
return(da.ExecSP(CommandType.StoredProcedure, "usp_InsertSORDERDETAIL", param));
}
