/// <summary> /// Return Cellar ID To Specific Product ID and Cellar Area ID /// </summary> /// <param name="request">Product ID and Cellar Area ID</param> /// <returns>Cellar ID</returns> public static GetCellarResponse GetCellarIDByProductIDAndCellarArea(GetCellarRequest request) { GetCellarResponse response = new GetCellarResponse(); response.Error = new Handler.ErrorObject(); response.Cellar = new Cellars(); try { var bussines = CellarData.Select.GetCellarIDByProductIDAndCellarArea(request.ProductID, request.CellarAreaID); if (!bussines.Item1.Error) { response.Cellar = new Cellars() { amount = bussines.Item2 }; } else { response.Error.InfoError(bussines.Item1); } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
private static GetCellarResponse Cellars(GetCellarResponse request) { GetCellarResponse response = new GetCellarResponse(); try { tblCellar bussines = new tblCellar() { id = request.Cellar.id, amount = request.Cellar.amount, detail = request.Cellar.detail, idProduct = request.Cellar.idProduct, idcellarArea = request.Cellar.idcellarArea, createDate = request.Cellar.createDate, upDateDate = DateTime.Now, deleteDate = null, state = "Active" }; var result = CellarData.Update.Cellar(bussines); if (result.Item1.Error) { response.Error.InfoError(result.Item1); } else { response.Message = result.Item2; } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
public static GetCellarResponse Cellar(GetCellarResponse request) { GetCellarResponse response = new GetCellarResponse(); response.Error = new Handler.ErrorObject(); try { tblCellar bussines = new tblCellar() { id = request.Cellar.id, detail = request.Cellar.detail, min = request.Cellar.Min, max = request.Cellar.Max, idcellarArea = request.Cellar.idcellarArea, createDate = request.Cellar.createDate, state = "Active" }; var result = CellarData.Update.CellarUpdate(bussines); response.Message = result.Item2.ToString(); } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
public static GetCellarResponse Cellar(GetCellarResponse cellarInformation, GetCellarRequest request) { GetCellarResponse response = new GetCellarResponse(); response.Error = new Handler.ErrorObject(); try { CellarAmount(request); var result = Transaction.TransactionConfigurateBussines.Insert.TransactionConfigurate(request.CellarID, request.TransactionTypeID, cellarInformation.transaction); response.Message = result.Message.ToString(); } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
/// <summary> /// Return Cellar Information To Specific Cellar ID /// </summary> /// <param name="request">Cellar ID</param> /// <returns>Cellar Information</returns> public static GetCellarResponse GetCellarByProductID(GetCellarRequest request) { GetCellarResponse response = new GetCellarResponse(); response.CellarList = new List <Cellars>(); response.Error = new Handler.ErrorObject(); try { var bussines = CellarData.Select.GetCellarByProductID(request.ProductID); if (!bussines.Item1.Error) { foreach (var item in bussines.Item2) { response.CellarList.Add(new Cellars() { id = item.id, amount = item.amount, detail = item.detail, Min = item.min, Max = item.max, idProduct = item.idProduct, idcellarArea = item.idcellarArea, createDate = item.createDate, upDateDate = item.upDateDate, deleteDate = item.deleteDate, state = item.state }); } } else { response.Error.InfoError(bussines.Item1); } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
/// <summary> /// Return Affected Row Or Error If Exist /// </summary> /// <param name="request">Employee Information</param> /// <returns>Cellar ID</returns> private static GetCellarResponse Cellars(GetCellarResponse request) { GetCellarResponse response = new GetCellarResponse(); response.Error = new Handler.ErrorObject(); try { tblCellar bussines = new tblCellar() { id = request.Cellar.id, amount = request.Cellar.amount, detail = request.Cellar.detail, min = request.Cellar.Min, max = request.Cellar.Max, idProduct = request.Cellar.idProduct, idcellarArea = request.Cellar.idcellarArea, createDate = request.Cellar.createDate, upDateDate = null, deleteDate = null, state = "Active" }; var result = CellarData.Insert.Cellar(bussines); if (result.Item1.Error) { response.Error.InfoError(result.Item1); } else { response.Message = result.Item2.ToString(); } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
/// <summary> /// Return Affected Row Or Error If Exist /// </summary> /// <param name="CellarID">CellarID</param> /// <param name="state">State</param> /// <returns>Affected Row Or Error If Exist</returns> public static GetCellarResponse CellarDisable(int CellarID, string state) { GetCellarResponse response = new GetCellarResponse(); try { var result = CellarData.Delete.CellarDisable(CellarID, state); if (result.Item1.Error) { response.Error.InfoError(result.Item1); } else { response.Message = result.Item2; } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
/// <summary> /// Return Amount To Specific Product ID and Cellar Area ID /// </summary> /// <param name="request">Product ID and Cellar Area ID</param> /// <returns>Amount</returns> public static GetCellarResponse GetCellarByProductIDAndCellarArea(GetCellarRequest request) { GetCellarResponse response = new GetCellarResponse(); response.Error = new Handler.ErrorObject(); response.Cellar = new Cellars(); try { var bussines = CellarData.Select.GetCellarByProductIDAndCellarArea(request.ProductID, request.CellarAreaID, request.conditionID, request.TransactionTypeID); if (!bussines.Item1.Error) { response.Cellar = new Cellars() { id = bussines.Item2.id, amount = bussines.Item2.amount, detail = bussines.Item2.detail, idProduct = bussines.Item2.idProduct, Min = bussines.Item2.min, Max = bussines.Item2.max, idcellarArea = bussines.Item2.idcellarArea, createDate = bussines.Item2.createDate, upDateDate = bussines.Item2.upDateDate, deleteDate = bussines.Item2.deleteDate, state = bussines.Item2.state }; } else { response.Error.InfoError(bussines.Item1); } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
public static GetCellarResponse CellarAmount(GetCellarRequest request) { GetCellarResponse response = new GetCellarResponse(); response.Error = new Handler.ErrorObject(); try { var result = CellarData.Update.CellarAmoun(request.CellarID, request.amount); if (result.Item1.Error) { response.Error.InfoError(result.Item1); } else { response.Message = result.Item2; } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }