public async Task <List <BidEntity> > GetBidByHeaderId(int headerId) { try { return(await dapperHelper.ExecuteSP_Multiple <BidEntity>(SpBid.GET_BY_HEADER, new { @HeaderId = headerId })); } catch (Exception e) { throw e; } }
public async Task <List <DetailEntity> > GetDetailByHeaderId(int headerId) { try { return(await dapperHelper.ExecuteSP_Multiple <DetailEntity>(SpDetail.GET_BY_Header, new { @HeaderId = headerId })); } catch (Exception e) { throw e; } }
public async Task message_notification() { try { string rootPath = Directory.GetCurrentDirectory(); if (!System.IO.Directory.Exists(Path.Combine(rootPath, "\\HTMLMessages"))) { Directory.CreateDirectory("HTMLMessages"); } string htmlPath = Directory.GetCurrentDirectory() + "\\HTMLMessages\\"; string html = "InvitationMessage.html"; if (!System.IO.File.Exists(Path.Combine(htmlPath + html))) { File.WriteAllText(htmlPath + html, "<b>Estimado [SupplierName]</b>" + "\r\n<br />" + "\r\n<br />" + "Usted ha sido invitado a participar en la licitación N°[DocumentNumber], la cual estará disponible desde [OpenDate] hasta [CloseDate]." + "\r\n<br />" + "\r\n<br />" + "Atentamente" + "\r\n<br />" + "\r\n<br />" + "[BuyerName]"); } List <MessageEntity> listPending = await dapperHelper.ExecuteSP_Multiple <MessageEntity>(spMessage.GET_ALL_BYPENDING); foreach (MessageEntity item in listPending) { string body = System.IO.File.ReadAllText(Path.Combine(htmlPath + html)); InvitationRfxEntity data = dapperHelper.ExecuteSP_Single <InvitationRfxEntity>(spMessage.GET_DATA_INVITATION_RFX, new { @messageId = item.MessageId }).Result; body = body.Replace("[BuyerName]", data.BuyerName); body = body.Replace("[SupplierName]", data.SupplierName); body = body.Replace("[DocumentNumber]", data.DocumentNumber); body = body.Replace("[OpenDate]", data.OpenDate.ToShortDateString()); body = body.Replace("[CloseDate]", data.CloseDate.ToShortDateString()); item.Subject = "Invitación a licitación " + data.DocumentNumber; item.MessageSent = body; SendMail(item.MessageId, item.MessageTo, item.MessageToBCC, item.MessageSent, item.Subject); } } catch (Exception e) { throw e; } }
public async Task <List <UserEntity> > GetAllUsers_ByCompanyId(int UserId, int CompanyId) { try { return(await dapperHelper.ExecuteSP_Multiple <UserEntity>(User.GET_ALL_BY_COMPANY, new { @UserId = UserId, @CompanyId = CompanyId } )); } catch (Exception e) { throw e; } }
public async Task Update_status() { try { List <HeaderScheduler> headers = await dapperHelper.ExecuteSP_Multiple <HeaderScheduler>(Header.GET_ALL_BYSTATUS); DateTime Now = Convert.ToDateTime(DateTime.Now.ToShortDateString()); foreach (HeaderScheduler item in headers)//int i = 0; i < headers.Count; i++) { //la fecha de cierre es menor a la de apertura if (item.CloseDate < item.OpenDate) { await dapperHelper.ExecuteSP_Single <string>(Header.UPDATE_STATUS, new { @Status = "ERROR", @HeaderId = item.HeaderId }); } else { //fecha de apertura es menor o igual a la fecha actual if (item.OpenDate <= Now) { //Si la fecha de cierre es mayor o igual a la fecha actual y igual a la fecha de apertura el estado es "PROGRAMADO" if (item.CloseDate >= Now && item.Status == "PROGRAMADO") { await dapperHelper.ExecuteSP_Single <string>(Header.RFX_OPEN, new { @HeaderId = item.HeaderId }); //Add pending RFx invitations to message table await dapperHelper.ExecuteSP_Single <string>(spMessage.SET_DATA_INVITATION_RFX, new { @HeaderId = item.HeaderId }); //Send email to suppliers invited await messageRepository.message_notification(); } //si la fecha de cierre es menor a la fecha actual else if (item.CloseDate < Now && item.Status == "PUBLICADO") { await dapperHelper.ExecuteSP_Single <string>(Header.RFX_CLOSE, new { @HeaderId = item.HeaderId }); } } } } } catch (Exception e) { throw e; } }
public async Task <List <MeasuranceUnitEntity> > GetUnits() { try { return(await dapperHelper.ExecuteSP_Multiple <MeasuranceUnitEntity>(MeasuranceUnit.SELECT_ALL)); } catch (Exception ex) { throw ex; } }
public async Task <List <AttachmentEntity> > GetAttachmentByHeaderId(int headerId) { try { return(await dapperHelper.ExecuteSP_Multiple <AttachmentEntity>(SpAttachment.GET_BY_HEADER_ID, new { @HeaderId = headerId })); } catch (Exception e) { throw e; } }
public async Task <List <WarehouseEntity> > GetByCompanyId(int companyId) { try { return(await dapperHelper.ExecuteSP_Multiple <WarehouseEntity>(SpWarehouse.GET_BY_COMPANYID, new { @CompanyId = companyId })); } catch (Exception e) { throw e; } }
public async Task <List <CharacteristicEntity> > GetAllCharacteristics() { try { var dataCharacteristics = await dapperHelper.ExecuteSP_Multiple <CharacteristicEntity>(SpCharacteristic.GET_ALL); List <CharacteristicEntity> Characteristics = (List <CharacteristicEntity>)dataCharacteristics; return(Characteristics); } catch (Exception e) { throw e; } }
public async Task <List <CurrencyEntity> > GetAllCurrency() { try { var dataCurrency = await dapperHelper.ExecuteSP_Multiple <CurrencyEntity>(SpCurrency.GET_ALL); List <CurrencyEntity> currency = (List <CurrencyEntity>)dataCurrency; return(currency); } catch (Exception e) { throw e; } }
public async Task <List <CompanyEntity> > GetAllCompanySuppliers() { try { var dataCompanySuppliers = await dapperHelper.ExecuteSP_Multiple <CompanyEntity>(SpCompany.GET_ALL_SUPPLIERS); List <CompanyEntity> companySuppliers = (List <CompanyEntity>)dataCompanySuppliers; return(companySuppliers); } catch (Exception e) { throw e; } }
public async Task <List <CarrierEntity> > GetAllCarriers() { try { var dataCarriers = await dapperHelper.ExecuteSP_Multiple <CarrierEntity>(SpCarrier.florida_Carrier_all); List <CarrierEntity> carriers = (List <CarrierEntity>)dataCarriers; return(carriers); } catch (Exception e) { throw e; } }
public async Task <List <CategoryEntity> > GetAllCategories(int CompanyId) { try { var dataCategories = await dapperHelper.ExecuteSP_Multiple <CategoryEntity>(SpCategory.GET_ALL, new { @CompanyId = CompanyId }); List <CategoryEntity> categories = (List <CategoryEntity>)dataCategories; return(categories); } catch (Exception e) { throw e; } }
public async Task <List <RoleEntity> > GetAllRole_ByCompanyId(int userId, string companyType) { try { var dataRoleSuppliers = await dapperHelper.ExecuteSP_Multiple <RoleEntity>(SpRole.ALL, new { @UserId = userId, @CompanyType = companyType }); List <RoleEntity> roleSuppliers = (List <RoleEntity>)dataRoleSuppliers; return(roleSuppliers); } catch (Exception e) { throw e; } }
//Get Headers list for buyer _Widget public async Task <List <WidgetEntity> > GetByDocType_Widget(string docTypeCode, int companyId) { try { return(await dapperHelper.ExecuteSP_Multiple <WidgetEntity>(Header.GetAllRFXs_Widget, new { @DocTypeCode = docTypeCode, @CompanyId = companyId })); } catch (Exception e) { throw e; } }
public async Task <List <ProductEntity> > GetProducts() { return(await dapperHelper.ExecuteSP_Multiple <ProductEntity>(Product.SELECT)); }