public APIResponse GetAllItemCode() { try { Dictionary <string, Tuple <string, DbType, ParameterDirection> > parameters = new Dictionary <string, Tuple <string, DbType, ParameterDirection> > { }; var data = unitOfWork.Repository <ItemModel>().GetEntitiesBySP("[dbo].[GetAllItemCode]", parameters); return(APIResponseGenerator.GenerateResponseMessage("1", "Success", data)); } catch (Exception ex) { return(APIResponseGenerator.GenerateResponseMessage("Error", ex.ToString(), null)); } }
public APIResponse GetItemsDetailsByID(int Itemid) { try { Dictionary <string, Tuple <string, DbType, ParameterDirection> > parameters = new Dictionary <string, Tuple <string, DbType, ParameterDirection> > { { "@Id", Tuple.Create(Itemid.ToString(), DbType.Int32, ParameterDirection.Input) }, }; var data = unitOfWork.Repository <ItemModel>().GetEntitiesBySP("[dbo].[GetItemsDetailsByID]", parameters); return(APIResponseGenerator.GenerateResponseMessage("1", "Success", data)); } catch (Exception ex) { return(APIResponseGenerator.GenerateResponseMessage("Error", ex.ToString(), null)); } }
public APIResponse SaveOrder(OrderModel orderModel) { try { var statusCode = "-1"; var message = ""; Dictionary <string, Tuple <string, DbType, ParameterDirection> > parameters = new Dictionary <string, Tuple <string, DbType, ParameterDirection> > { { "@Note", Tuple.Create(orderModel.Note.ToString(), DbType.String, ParameterDirection.Input) }, { "@InvoiceNo", Tuple.Create(orderModel.InvoiceNo.ToString(), DbType.String, ParameterDirection.Input) }, { "@InvoiceDate", Tuple.Create(orderModel.InvoiceDate.ToString(), DbType.DateTime, ParameterDirection.Input) }, { "@ReferenceNo", Tuple.Create(orderModel.ReferenceNo.ToString(), DbType.String, ParameterDirection.Input) }, { "@Status", Tuple.Create(0.ToString(), DbType.Int32, ParameterDirection.Output) }, }; var orderId = unitOfWork.Repository <string>().ExecuteSPWithInputOutput("[dbo].[SaveOrder]", parameters); if (orderId > 0) { int result = InsertItemsByOrder(orderModel, orderId); if (result > 0) { statusCode = "1"; message = "Successfully Saved"; } } else { statusCode = "-1"; message = "Error, Not Saved"; } return(APIResponseGenerator.GenerateResponseMessage(statusCode, message, "")); } catch (Exception ex) { return(APIResponseGenerator.GenerateResponseMessage("Error", ex.ToString(), null)); } }