public int Insertar(EOrderDetail ventadetalle)
{
string sql = " INSERT INTO SalesOrderDetails(SalesOrderId, ProductId, UnitPrice, Quantity) " +
" VALUES(@SalesOrderId, @ProductId, @UnitPrice, @Quantity) ";
int rowsInsert = 0;
try
{
using (SqlConnection con = new SqlConnection(cadenaconexion))
{
con.Open();
using (SqlCommand com = new SqlCommand(sql, con))
{
com.Parameters.Add(new SqlParameter("@SalesOrderId", ventadetalle.orderId));
com.Parameters.Add(new SqlParameter("@ProductId", ventadetalle.productId));
com.Parameters.Add(new SqlParameter("@UnitPrice", ventadetalle.unitPrice));
com.Parameters.Add(new SqlParameter("@Quantity", ventadetalle.quantity));
rowsInsert = com.ExecuteNonQuery();
}
}
return(rowsInsert);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertEOrderDetail(EOrderDetailModel model)
{
var entity = new EOrderDetail
{
OrderType = model.OrderType,
OrderID = model.OrderID,
Sn = model.Sn,
Sku = model.Sku,
Skudesc = model.Skudesc,
WareId = model.WareId,
Unit = model.Unit,
UnitCost = model.UnitCost,
UnitPrice = model.UnitPrice,
QtyonSales = model.QtyonSales,
Orderqty = model.Orderqty,
Bkoqty = model.Bkoqty,
Fullqty = model.Fullqty,
Discount = model.Discount,
Tax = model.Tax,
OrderStats = model.OrderStats,
CommText = model.CommText,
FullDate = model.FullDate,
CretDate = model.CretDate,
ModiDate = model.ModiDate,
CretID = model.CretID,
Class1 = model.Class1,
};
return(EOrderDetailRepository.Insert(entity));
}
public OperationResult Insert(EOrderDetailModel model)
{
var entity = new EOrderDetail
{
OrderType = model.OrderType,
OrderID = model.OrderID,
Sn = model.Sn,
Sku = model.Sku,
Skudesc = model.Skudesc,
WareId = model.WareId,
Unit = model.Unit,
UnitCost = model.UnitCost,
UnitPrice = model.UnitPrice,
QtyonSales = model.QtyonSales,
Orderqty = model.Orderqty,
Bkoqty = model.Bkoqty,
Fullqty = model.Fullqty,
Discount = model.Discount,
Tax = model.Tax,
OrderStats = model.OrderStats,
CommText = model.CommText,
FullDate = model.FullDate,
CretDate = model.CretDate,
ModiDate = model.ModiDate,
CretID = model.CretID,
Class1 = model.Class1,
};
EOrderDetailRepository.Insert(entity);
return(new OperationResult(OperationResultType.Success, "Added successfully"));
}
public int insertarDetallePedido(EOrderDetail beventadetalle)
{
try
{
if (beventadetalle == null)
{
return(0);
}
int iRows = -1;
iRows = daopedidoDetalle.Insertar(beventadetalle);
return(iRows);
}
catch (WebException ex)
{
throw new WebFaultException <string>(ex.ToString(), HttpStatusCode.InternalServerError);
}
}
public List <EOrderDetail> GetDetalleByOrderId(int id)
{
List <EOrderDetail> lista = new List <EOrderDetail>();;
string sql = " SELECT SOD.SalesOrderDetailId,SOD.SalesOrderId,SOD.ProductId,SOD.UnitPrice,SOD.Quantity " +
" FROM SalesOrderDetails SOD " +
" Where SOD.SalesOrderId = " + id.ToString();
try
{
using (SqlConnection con = new SqlConnection(cadenaconexion))
{
using (SqlCommand com = new SqlCommand(sql, con))
{
con.Open();
using (SqlDataReader dr = com.ExecuteReader())
{
while (dr.Read())
{
EOrderDetail detalle = new EOrderDetail();
detalle.id = Convert.ToInt32(dr[0]);
detalle.orderId = Convert.ToInt32(dr[1]);
detalle.productId = Convert.ToInt32(dr[2]);
detalle.unitPrice = Convert.ToDouble(dr[3]);
detalle.quantity = Convert.ToInt32(dr[4]);
lista.Add(detalle);
}
dr.Close();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lista);
}
public void InsertarUsuario()
{
//EUser usuario = new EUser()
//{
// lastName = "Carrasco",
// firstName = "Julia",
// email = "*****@*****.**",
// phoneNumber = "987654321",
// documentNumber = "45781266",
// type = "2",
// password = "******"
//};
//EOrder pedido = new EOrder() {
// userId = 3,
// pubId = 1,
// waitTime = "00:10:00"
//};
EOrderDetail pedido = new EOrderDetail()
{
orderId = 2,
productId = 1,
unitPrice = 20.00,
quantity = 2
};
JavaScriptSerializer serializer = new JavaScriptSerializer();
string postdata = serializer.Serialize(pedido);;
byte[] data = Encoding.UTF8.GetBytes(postdata);
HttpWebRequest req = (HttpWebRequest)WebRequest
.Create("http://localhost:15000/ServiceBares.svc/OrderDetail");
req.Method = "POST";
req.ContentLength = data.Length;
req.ContentType = "application/json";
var reqStream = req.GetRequestStream();
reqStream.Write(data, 0, data.Length);
HttpWebResponse res = null;
EOrder cat = null;
try
{
res = (HttpWebResponse)req.GetResponse();
StreamReader reader = new StreamReader(res.GetResponseStream());
string listaCATJson = reader.ReadToEnd();
JavaScriptSerializer js = new JavaScriptSerializer();
cat = js.Deserialize <EOrder>(listaCATJson);
Assert.IsNotNull(cat);
}
catch (WebException e)
{
HttpStatusCode code = ((HttpWebResponse)e.Response).StatusCode;
string message = ((HttpWebResponse)e.Response).StatusDescription;
StreamReader reader = new StreamReader(e.Response.GetResponseStream());
string error = reader.ReadToEnd();
JavaScriptSerializer js = new JavaScriptSerializer();
string mensaje = js.Deserialize <string>(error);
Assert.AreEqual("", mensaje);
}
}
