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)); }