private List <RequestDetail> fillRequestDetailList() { RequestDetailBusiness _RequestDetailBusiness = new RequestDetailBusiness(); RequestDetailList _RequestDetailList = _RequestDetailBusiness.SelectRows(null, null, null, null); return(_RequestDetailList); }
private List <RequestDetail> fillRequestDetailListbyRequestStatus(List <Request> requestList) { List <RequestDetail> requestDetailsList = new List <RequestDetail>(); RequestDetailBusiness _RequestDetailBusiness = default(RequestDetailBusiness); RequestDetailList _RequestDetailList = default(RequestDetailList); foreach (Request request in requestList) { _RequestDetailBusiness = new RequestDetailBusiness(); _RequestDetailList = _RequestDetailBusiness.SelectRows(null, null, request.Id); if (_RequestDetailList != null && _RequestDetailList.Count > 0) { foreach (RequestDetail requestDetail in _RequestDetailList) { requestDetailsList.Add(Copier.copyRequestDetail(requestDetail)); } } } return(requestDetailsList); }
public RequestDTO UpdateRequestinDB(RequestDTO requestDTO) { BaseDataAccess _db = new BaseDataAccess(); using (DbTransaction dbTransaction = _db.CreateTransaction()) { try { // 1- Perform Mapping to Input (for Saving in DB) if (Mapper.MapRequestAsInput(requestDTO)) { // 2- Select Request to be updated RequestBusiness requestBusiness = new RequestBusiness(); RequestList requestList = requestBusiness.SelectRows(Mapper._Request.Id, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); if (requestList != null && requestList.Count > 0) { requestList[0].requestNumber = Mapper._Request.requestNumber; requestList[0].totalQuantity = Mapper._Request.totalQuantity; requestList[0].PDD = Mapper._Request.PDD; requestList[0].customerID = Mapper._Request.customerID; requestList[0].creationDate = Mapper._Request.creationDate; requestList[0].creationUserID = Mapper._Request.creationUserID; requestList[0].approvalDate = Mapper._Request.approvalDate; requestList[0].approvalUserID = Mapper._Request.approvalUserID; requestList[0].receiveDate = Mapper._Request.receiveDate; requestList[0].receiveUserID = Mapper._Request.receiveUserID; requestList[0].rejectionDate = Mapper._Request.rejectionDate; requestList[0].rejectionUserID = Mapper._Request.rejectionUserID; requestList[0].rejectionReasonID = Mapper._Request.rejectionReasonID; requestList[0].requestTypeID = Mapper._Request.requestTypeID; requestList[0].requestStatusID = Mapper._Request.requestStatusID; requestList[0].requestCalssID = Mapper._Request.requestCalssID; requestList[0].requestPriorityID = Mapper._Request.requestPriorityID; // 3- Update Request Data by Input Values requestBusiness = new RequestBusiness(); if (requestBusiness.UpdateRow(dbTransaction, requestList[0]) > 0) { // 4- Remove Request Details Already Saved for that Request in DB RequestDetailBusiness requestDetailBusiness = new RequestDetailBusiness(); RequestDetailList requestDetailList = requestDetailBusiness.SelectRows(null, null, Mapper._Request.Id); if (requestDetailList != null && requestDetailList.Count > 0) { foreach (RequestDetail requestDetail in requestDetailList) { requestDetailBusiness = new RequestDetailBusiness(); requestDetailBusiness.DeleteRow(dbTransaction, requestDetail); } } // 5- Add New Request Details from Input if (Mapper._RequestDetailListInput != null && Mapper._RequestDetailListInput.Count > 0) { foreach (RequestDetail requestDetail in Mapper._RequestDetailListInput) { requestDetailBusiness = new RequestDetailBusiness(); requestDetailBusiness.InsertRow(dbTransaction, requestDetail); } dbTransaction.Commit(); } } else { dbTransaction.Rollback(); throw new Exception("DataBase Operation Failure"); } } else { throw new Exception("Request Id Not Found in DB"); } } else { throw new ArgumentNullException("requestDTO"); } } catch (Exception ex) { dbTransaction.Rollback(); throw new Exception("DataBase Operation Failure"); } } return(requestDTO); }
public RequestDTO AddRequesttoDB(RequestDTO requestDTO) { BaseDataAccess _db = new BaseDataAccess(); using (DbTransaction dbTransaction = _db.CreateTransaction()) { try { // 1- Perform Mapping to Input (for Saving in DB) if (Mapper.MapRequestAsInput(requestDTO)) { ////User user = Mapper._User; ////List<UserGroup> userGroups = Mapper._UserGroupListInput; //Mapper._User.createDate = DateTime.Now; Mapper._Request.creationDate = DateTime.Now; // 2- Insert Request in DB RequestBusiness requestBusiness = new RequestBusiness(); if (requestBusiness.InsertRow(dbTransaction, Mapper._Request) > 0) { requestDTO.Id = Mapper._Request.Id; if (Mapper._RequestDetailListInput != null && Mapper._RequestDetailListInput.Count > 0) { RequestDetailBusiness requestDetailBusiness = new RequestDetailBusiness(); // 3- Insert Group Functions in DB foreach (RequestDetail requestDetail in Mapper._RequestDetailListInput) { requestDetail.requestID = Mapper._Request.Id; requestDetailBusiness = new RequestDetailBusiness(); requestDetailBusiness.InsertRow(dbTransaction, requestDetail); } dbTransaction.Commit(); } else { dbTransaction.Rollback(); } } else { throw new Exception("DataBase Operation Failure"); } } else { throw new ArgumentNullException("requestDTO"); } } catch (Exception ex) { dbTransaction.Rollback(); throw; } } return(requestDTO); }