string INorthwindService.RegisterOfOrders(models.RegisterOfOrders.RegisterOfOrders obj)
{
var strMensaje = "";
//var strCodConfirm = "";
conexion = cn.ConectarDB();
SqlCommand cmd = new SqlCommand("SP_REGISTRAR_PEDIDOS", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DateConfirmation", obj.DateConfirmation);
cmd.Parameters.AddWithValue("@Confirmed", obj.Confirmed);
cmd.Parameters.AddWithValue("@Comments", obj.Comments);
//Abrir conexion
conexion.Open();
try
{
cmd.ExecuteNonQuery();
strMensaje = "0|Confirmación de pedido exitoso";
}
catch (Exception ex)
{
strMensaje = ex.Message;
}
finally
{
if (conexion.State == ConnectionState.Open)
{
conexion.Close();
}
conexion.Dispose();
cmd.Dispose();
}
return(strMensaje);
}
public System.Threading.Tasks.Task <string> RegisterOfOrdersAsync(Northwind.Entity.Service.Northwind.RegisterOfOrders.RegisterOfOrders obj)
{
return(base.Channel.RegisterOfOrdersAsync(obj));
}
public string RegisterOfOrders(Northwind.Entity.Service.Northwind.RegisterOfOrders.RegisterOfOrders obj)
{
return(base.Channel.RegisterOfOrders(obj));
}
//etodo que confirma el pedido
public JsonResult GetRegistertProductOrders(models.RegisterOfOrders.RegisterOfOrders obj)
{
var objResultData = serviceOrders.RegisterOfOrders(obj);
return(Json(new { data = objResultData }, JsonRequestBehavior.AllowGet));
}
