public ResultBM UpdateReleaseOrder(ReleaseOrderBM releaseOrderBm) { try { ReleaseOrderDetailBLL releaseOrderDetailBll = new ReleaseOrderDetailBLL(); ResultBM detailResult = null; ReleaseOrderDAL releaseOrderDal = new ReleaseOrderDAL(); ReleaseOrderDTO releaseOrderDto = null; ResultBM validResult = IsValid(releaseOrderBm); if (!validResult.IsValid()) { return(validResult); } releaseOrderDto = new ReleaseOrderDTO(releaseOrderBm.id, releaseOrderBm.beneficiary.beneficiaryId, releaseOrderBm.Comment, releaseOrderBm.released, releaseOrderBm.received, releaseOrderBm.OrderStatus); releaseOrderDal.UpdateReleaseOrder(releaseOrderDto); detailResult = releaseOrderDetailBll.UpdateReleaseOrderDetail(releaseOrderBm); if (!detailResult.IsValid()) { return(detailResult); } return(new ResultBM(ResultBM.Type.OK, "Orden de salida actualizada.", releaseOrderBm)); } catch (Exception exception) { return(new ResultBM(ResultBM.Type.EXCEPTION, SessionHelper.GetTranslation("UPDATING_ERROR") + " " + exception.Message, exception)); } }
public ReleaseOrderBM(ReleaseOrderDTO releaseorderDto, BeneficiaryBM beneficiaryBm = null, List<ReleaseOrderDetailBM> releaseOrderDetailBms = null) { this.id = releaseorderDto.id; this.beneficiary = beneficiaryBm; this.comment = releaseorderDto.comment; this.released = releaseorderDto.released; this.received = releaseorderDto.released; this.status = releaseorderDto.status; this.detail = releaseOrderDetailBms; }
public bool UpdateReleaseOrder(ReleaseOrderDTO releaseOrderDto) { DBSql dbsql = new DBSql(); String sql; sql = "UPDATE release_order SET "; sql += "beneficiaryId = " + releaseOrderDto.beneficiaryId + ", "; sql += "comment = '" + releaseOrderDto.comment + "', "; sql += "status = '" + releaseOrderDto.status + "' "; sql += "WHERE id = " + releaseOrderDto.id; dbsql.ExecuteNonQuery(sql); return(true); }
public bool SaveReleaseOrder(ReleaseOrderDTO releaseOrderDto) { DBSql dbsql = new DBSql(); String sql; sql = "INSERT INTO release_order (beneficiaryId, comment, released, received, status) VALUES ("; sql += releaseOrderDto.beneficiaryId + ", "; sql += "'" + releaseOrderDto.comment + "', "; sql += "null,"; sql += "null,"; sql += "'" + releaseOrderDto.status + "' "; sql += ");SELECT @@IDENTITY"; releaseOrderDto.id = dbsql.ExecuteNonQuery(sql); return(true); }
private ReleaseOrderDTO Resolve(List <String> item) { ReleaseOrderDTO result = new ReleaseOrderDTO(); result.id = int.Parse(item[0]); result.beneficiaryId = int.Parse(item[1]); result.comment = item[2]; if (item[3] != null && item[3].Length > 0) { result.released = DateTime.Parse(item[3]); } if (item[4] != null && item[4].Length > 0) { result.received = DateTime.Parse(item[4]); } result.status = item[5]; return(result); }
public ResultBM GetReleaseOrder(int releaseOrderId) { try { BeneficiaryBLL beneficiaryBll = new BeneficiaryBLL(); ResultBM beneficiaryResult = null; ReleaseOrderDAL releaseOrderDal = new ReleaseOrderDAL(); ReleaseOrderDTO releaseOrderDto = releaseOrderDal.GetReleaseOrder(releaseOrderId); ReleaseOrderBM releaseOrderBm = null; ReleaseOrderDetailBLL releaseOrderDetailBll = new ReleaseOrderDetailBLL(); ResultBM releaseOrderDetailResult = null; //Si la orden de salida existe, deben existir beneficiario y detalles if (releaseOrderDto != null) { beneficiaryResult = beneficiaryBll.GetBeneficiary(releaseOrderDto.beneficiaryId); if (!beneficiaryResult.IsValid()) { return(beneficiaryResult); } if (beneficiaryResult.GetValue() == null) { throw new Exception(SessionHelper.GetTranslation("RETRIEVING_ERROR") + " beneficiaryId " + releaseOrderDto.beneficiaryId); } releaseOrderDetailResult = releaseOrderDetailBll.GetReleaseOrderDetail(releaseOrderId); if (!releaseOrderDetailResult.IsValid()) { return(releaseOrderDetailResult); } if (releaseOrderDetailResult.GetValue() == null) { throw new Exception(SessionHelper.GetTranslation("RETRIEVING_ERROR") + " releaseOrderId " + releaseOrderId); } } releaseOrderBm = new ReleaseOrderBM(releaseOrderDto, beneficiaryResult.GetValue <BeneficiaryBM>(), releaseOrderDetailResult.GetValue <List <ReleaseOrderDetailBM> >()); return(new ResultBM(ResultBM.Type.OK, "Operación exitosa.", releaseOrderBm)); } catch (Exception exception) { return(new ResultBM(ResultBM.Type.EXCEPTION, SessionHelper.GetTranslation("RETRIEVING_ERROR") + " " + exception.Message, exception)); } }
private List <ReleaseOrderDetailBM> GetDetail(ReleaseOrderDTO releaseOrderDto) { ResultBM detailResult = new ReleaseOrderDetailBLL().GetReleaseOrderDetail(releaseOrderDto.id); return(detailResult.GetValue <List <ReleaseOrderDetailBM> >()); }
//No está bueno esto, pero me permite recuperar los beneficiarios. Poco performante... pero no hay tiempo. private BeneficiaryBM GetBeneficiary(ReleaseOrderDTO releaseOrderDto) { ResultBM beneficiaryResult = new BeneficiaryBLL().GetBeneficiary(releaseOrderDto.beneficiaryId); return(beneficiaryResult.GetValue <BeneficiaryBM>()); }