public async Task <ResponseBase <List <CustomerModel> > > GetCustomerbyProduct(string product)
{
var response = new ResponseBase <List <CustomerModel> >();
if (!string.IsNullOrWhiteSpace(product))
{
IRepository <OracleParameterCollection> repository = new OracleRepository(connString, "C_DATASET");
var luser = new List <CustomerModel>();
var user = new CustomerModel();
repository.Parameters.Add("P_PRODUCT", OracleDbType.Varchar2, 200).Value = product;
repository.Parameters.Add("C_DATASET", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
var result = repository.Get("PKG_B2C_CUSTOMER.B2C_CUSTOMER_SELECT_PRODUCT");
if (repository.Status.Code == Status.Ok)
{
foreach (var item in result)
{
user = new CustomerModel();
user.CustId = long.Parse(item["CUSTID"].ToString());
user.FName = item["FNAME"].ToString();
user.LName = item["LNAME"].ToString();
user.PhoneNumber = item["PHONENUMBER"].ToString();
user.Email = item["EMAIL"].ToString();
user.CreditCardType = item["CREDITCARDTYPE"].ToString();
user.CreditCardNumber = item["CREDITCARDNUMBER"].ToString();
user.Status = item["STATUS"].ToString();
user.DocNumber = item["DOCNUMBER"].ToString();
user.UserName = item["USERNAME"].ToString();
user.TipoCliente = item["TIPOCLIENTE"].ToString();
user.ORDID = item["ORDID"].ToString();
user.ITEMID = item["ITEMID"].ToString();
luser.Add(user);
}
response.Data = luser;
}
else
{
response.Message = repository.Status.Message;
}
response.Code = repository.Status.Code;
}
else
{
response.Code = Status.InvalidData;
response.Message = "The field Document is empty";
}
return(await Task.Run(() => response));
}
public async Task <ResponseBase <AuthenticateResponse> > Authenticate(AuthenticateModel data)
{
IRepository <OracleParameterCollection> repository = new OracleRepository(connString, "C_DATASET");
var response = new ResponseBase <AuthenticateResponse>();
var user = new AuthenticateResponse();
repository.Parameters.Add("P_USERNAME", OracleDbType.Varchar2).Value = data.UserName;
repository.Parameters.Add("P_CONTRASENA", OracleDbType.Varchar2, 200).Value = data.Password;
repository.Parameters.Add("C_DATASET", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
var result = repository.Get("PKG_B2C_CUSTOMER.B2C_CUSTOMER_SELECT_AUTENTICAR");
if (repository.Status.Code == Status.Ok)
{
if (result.Count > 0)
{
var r = result[0]["CUSTID"];
foreach (var item in result)
{
user.Id = long.Parse(item["CUSTID"].ToString());
user.Names = item["FNAME"].ToString();
user.Surnames = item["LNAME"].ToString();
user.Status = item["STATUS"].ToString();
user.TipoCliente = item["TIPOCLIENTE"].ToString();
//user.CUSTID = long.Parse(item["CUSTID"].ToString());
//user.FNAME = item["FNAME"].ToString();
//user.LNAME = item["LNAME"].ToString();
//user.PHONENUMBER = item["PHONENUMBER"].ToString();
//user.EMAIL = item["EMAIL"].ToString();
//user.PASSWORD = item["PASSWORD"].ToString();
//user.CREDITCARDTYPE = item["CREDITCARDTYPE"].ToString();
//user.CREDITCARDNUMBER = item["CREDITCARDNUMBER"].ToString();
//user.STATUS = item["STATUS"].ToString();
}
}
else
{
response.Code = Status.NotFound;
}
response.Data = user;
}
else
{
response.Message = repository.Status.Message;
}
response.Code = repository.Status.Code;
return(await Task.Run(() => response));
}
public async Task <ResponseBase <CustomerModel> > LoginCustomer(CustomerAuthModel data)
{
var response = new ResponseBase <CustomerModel>();
var validate = ValidateMiddle.Result(data);
if (validate.Status)
{
IRepository <OracleParameterCollection> repository = new OracleRepository(connString, "C_DATASET");
var user = new CustomerModel()
{
CustId = -1
};
repository.Parameters.Add("P_USERNAME", OracleDbType.Varchar2, 200).Value = data.Username;
repository.Parameters.Add("P_CONTRASENA", OracleDbType.Varchar2, 200).Value = data.Password;
repository.Parameters.Add("C_DATASET", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
var result = repository.Get("PKG_B2C_CUSTOMER.B2C_CUSTOMER_SELECT_AUTENTICAR");
if (repository.Status.Code == Status.Ok)
{
foreach (var item in result)
{
user.CustId = long.Parse(item["CUSTID"].ToString());
user.FName = item["FNAME"].ToString();
user.LName = item["LNAME"].ToString();
user.PhoneNumber = item["PHONENUMBER"].ToString();
user.Email = item["EMAIL"].ToString();
user.Password = item["PASSWORD"].ToString();
user.CreditCardType = item["CREDITCARDTYPE"].ToString();
user.CreditCardNumber = item["CREDITCARDNUMBER"].ToString();
user.Status = item["STATUS"].ToString();
user.DocNumber = item["DOCNUMBER"].ToString();
user.UserName = item["USERNAME"].ToString();
user.TipoCliente = item["TIPOCLIENTE"].ToString();
}
response.Data = user;
}
else
{
response.Message = repository.Status.Message;
}
response.Code = repository.Status.Code;
}
else
{
response.Code = Status.InvalidData;
response.Message = validate.Message;
}
return(await Task.Run(() => response));
}
public async Task <ResponseBase <List <OrderModel> > > GetOrders(long custId)
{
var response = new ResponseBase <List <OrderModel> >();
if (custId > 0)
{
IRepository <OracleParameterCollection> repository = new OracleRepository(connString, "C_DATASET");
var order = new OrderModel();
var lOrder = new List <OrderModel>();
repository.Parameters.Add("P_CUSTID", OracleDbType.Int64).Value = custId;
repository.Parameters.Add("C_DATASET", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
var result = repository.Get("PKG_B2C_ORDERS.B2C_ORDERS_SELECT_CLIENTE");
if (repository.Status.Code == Status.Ok)
{
foreach (var item in result)
{
order = new OrderModel();
order.Comments = item["COMMENTS"].ToString();
order.CustId = long.Parse(item["CUSTID"].ToString());
order.OrdenDate = DateTime.Parse(item["ORDENDATE"].ToString());
order.OrdId = long.Parse(item["ORDID"].ToString());
order.Price = decimal.Parse(item["PRICE"].ToString());
order.Status = item["IDESTADO"].ToString();
order.LItems = GetItemFromOrder(order.OrdId).Result.Data;
lOrder.Add(order);
}
response.Data = lOrder;
}
else
{
response.Message = repository.Status.Message;
}
response.Code = repository.Status.Code;
}
else
{
response.Code = Status.InvalidData;
response.Message = "The field CustId is zero(0)";
}
return(await Task.Run(() => response));
}
public async Task <ResponseBase <List <ItemModel> > > GetItemFromOrder(long IdOrder)
{
var response = new ResponseBase <List <ItemModel> >();
if (IdOrder > 0)
{
IRepository <OracleParameterCollection> repository = new OracleRepository(connString, "C_DATASET");
var ObjItem = new ItemModel();
var listItem = new List <ItemModel>();
repository.Parameters.Add("P_ORDID", OracleDbType.Int64).Value = IdOrder;
repository.Parameters.Add("C_DATASET", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
var result = repository.Get("PKG_B2C_ORDERS.B2C_ITEMS_SELECT_ORDEN");
if (repository.Status.Code == Status.Ok)
{
foreach (var item in result)
{
ObjItem = new ItemModel();
ObjItem.ItemId = long.Parse(item["ITEMID"].ToString());
ObjItem.OrdId = long.Parse(item["ORDID"].ToString());
ObjItem.PartNum = item["PARTNUM"].ToString();
ObjItem.Price = decimal.Parse(item["PRICE"].ToString());
ObjItem.ProdId = long.Parse(item["PRODID"].ToString());
ObjItem.ProductName = item["PRODUCTNAME"].ToString();
ObjItem.Quantity = int.Parse(item["QUANTITY"].ToString());
listItem.Add(ObjItem);
}
;
response.Data = listItem;
}
else
{
response.Message = repository.Status.Message;
}
response.Code = repository.Status.Code;
}
else
{
response.Code = Status.InvalidData;
response.Message = "The field IdOrder is zero(0)";
}
return(await Task.Run(() => response));
}
public async Task <ResponseBase <List <ReportOrdenModel> > > GetReportOrders(int tipobusqueda, string fecha1, string fecha2)
{
var response = new ResponseBase <List <ReportOrdenModel> >();
if (tipobusqueda > 0)
{
IRepository <OracleParameterCollection> repository = new OracleRepository(connString, "C_DATASET");
var order = new ReportOrdenModel();
var lOrder = new List <ReportOrdenModel>();
repository.Parameters.Add("P_TIPO_INFORME", OracleDbType.Int32).Value = tipobusqueda;
repository.Parameters.Add("P_FECHA1", OracleDbType.Date).Value = DateTime.Parse(fecha1);
repository.Parameters.Add("P_FECHA2", OracleDbType.Date).Value = DateTime.Parse(fecha2);
repository.Parameters.Add("C_DATASET", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
var result = repository.Get("PKG_B2C_REPORT.B2C_ORDERS_SELECT");
if (repository.Status.Code == Status.Ok)
{
foreach (var item in result)
{
order = new ReportOrdenModel();
order.ordid = long.Parse(item["ORDID"].ToString());
order.comments = item["COMMENTS"].ToString();
order.fname = item["FNAME"].ToString();
order.ordendate = DateTime.Parse(item["ORDENDATE"].ToString());
order.nombre_estado = item["NOMBRE_ESTADO"].ToString();
order.price = double.Parse(item["PRICE"].ToString());
lOrder.Add(order);
}
response.Data = lOrder;
}
else
{
response.Message = repository.Status.Message;
}
response.Code = repository.Status.Code;
}
else
{
response.Code = Status.InvalidData;
response.Message = "The field CustId is zero(0)";
}
return(await Task.Run(() => response));
}
public async Task <ResponseBase <List <ReportOrdenModel> > > GetReportOrderMonthDetail(string month)
{
var response = new ResponseBase <List <ReportOrdenModel> >();
if (month.Length > 0)
{
IRepository <OracleParameterCollection> repository = new OracleRepository(connString, "C_DATASET");
var order = new ReportOrdenModel();
var lOrder = new List <ReportOrdenModel>();
repository.Parameters.Add("P_MONTH", OracleDbType.Varchar2).Value = month;
repository.Parameters.Add("C_DATASET", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
var result = repository.Get("PKG_B2C_REPORT.B2C_MONTH_RANKING_SELECT");
if (repository.Status.Code == Status.Ok)
{
foreach (var item in result)
{
order = new ReportOrdenModel();
order.ordid = long.Parse(item["ORDID"].ToString());
order.comments = item["COMMENTS"].ToString();
order.fname = item["FNAME"].ToString();
order.ordendate = DateTime.Parse(item["ORDENDATE"].ToString());
order.nombre_estado = item["NOMBRE_ESTADO"].ToString();
order.price = double.Parse(item["PRICE"].ToString());
lOrder.Add(order);
}
response.Data = lOrder;
}
else
{
response.Message = repository.Status.Message;
}
response.Code = repository.Status.Code;
}
else
{
response.Code = Status.InvalidData;
response.Message = "The field CustId is zero(0)";
}
return(await Task.Run(() => response));
}
public async Task <ResponseBase <List <ReportProductModel> > > GetReportProducto(int tipobusqueda, string fecha1, string fecha2)
{
var response = new ResponseBase <List <ReportProductModel> >();
if (tipobusqueda > 0)
{
IRepository <OracleParameterCollection> repository = new OracleRepository(connString, "C_DATASET");
var order = new ReportProductModel();
var lOrder = new List <ReportProductModel>();
repository.Parameters.Add("P_TIPO_INFORME", OracleDbType.Int32).Value = tipobusqueda;
repository.Parameters.Add("P_FECHA1", OracleDbType.Date).Value = DateTime.Parse(fecha1);
repository.Parameters.Add("P_FECHA2", OracleDbType.Date).Value = DateTime.Parse(fecha2);
repository.Parameters.Add("C_DATASET", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
var result = repository.Get("PKG_B2C_REPORT.B2C_ORDERS_SELECT");
if (repository.Status.Code == Status.Ok)
{
foreach (var item in result)
{
order = new ReportProductModel();
order.productname = item["PRODUCTNAME"].ToString();
order.Cantidad = int.Parse(item["CANTIDAD"].ToString());
order.proid = int.Parse(item["PRODID"].ToString());
order.valor = double.Parse(item["VALOR"].ToString());
lOrder.Add(order);
}
response.Data = lOrder;
}
else
{
response.Message = repository.Status.Message;
}
response.Code = repository.Status.Code;
}
else
{
response.Code = Status.InvalidData;
response.Message = "The field CustId is zero(0)";
}
return(await Task.Run(() => response));
}
