public async Task InsertProduct(ProductEntity product, string createdBy)
{
try
{
await dapperHelper.ExecuteSP_Single <ProductEntity>(Product.INSERT, new
{
@ProductCode = product.ProductCode,
@ProductName = product.ProductName,
@ProductDescription = product.ProductDescription,
@ProductType = product.ProductType,
@MeasuranceUnit = product.MeasuranceUnit,
@StandardPartNumber = product.StandardPartNumber,
@PartNumberOther = product.PartNumberOther,
@AdditionalPartNumber = product.AdditionalPartNumber,
@RiskCode = product.RiskCode,
@RiskNote = product.RiskNote,
@ItemNote = product.ItemNote,
@ProductCategoryId = product.ProductCategoryId,
@ProductParentId = product.ProductParentId,
@CreatedBy = createdBy
});
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
throw ex;
}
}
public async Task InsertCompany(CompanyEntity company, string userUniqueName)
{
try
{
await dapperHelper.ExecuteSP_Single <string>(SpCompany.INSERT, new
{
@CompanyCode = company.CompanyCode,
@CompanyName = company.CompanyName,
@CompanyType = company.CompanyType,
@CompanyPhone = company.CompanyPhone,
@CompanyEmail = company.CompanyEmail,
@CompanyWebsite = company.CompanyWebsite,
@CompanyAddress = company.CompanyAddress,
@CompanyRegion = company.CompanyRegion,
@CompanyLegalId = company.CompanyLegalId,
@CompanyContactName = company.CompanyContactName,
@CompanyContactPhone = company.CompanyContactPhone,
@CreatedBy = userUniqueName
});
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
}
}
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 DeleteMeasuranceUnit(MeasuranceUnitEntity unit, string modifiedBy)
{
try
{
await dapperHelper.ExecuteSP_Single <string>(MeasuranceUnit.DELETE, new
{
@Id = unit.MeasuranceUnitId,
@ModifiedBy = modifiedBy
});
}
catch (Exception ex)
{
throw ex;
}
}
public async Task InsertCharacteristic(CharacteristicEntity characteristic, string userUniqueName)
{
try
{
await dapperHelper.ExecuteSP_Single <string>(SpCharacteristic.INSERT, new
{
@CharacteristicCode = characteristic.CharacteristicCode,
@CharacteristicDescription = characteristic.CharacteristicDescription,
@CreatedBy = userUniqueName
});
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
}
}
public async Task InsertCategory(CategoryEntity category)
{
try
{
await dapperHelper.ExecuteSP_Single <string>(SpCategory.INSERT, new
{
@CategoryName = category.CategoryName,
@CategoryCode = category.CategoryCode,
@CompanyId = category.CompanyId
});
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
}
}
public async Task InsertCarrier(CarrierEntity carrier)
{
try
{
await dapperHelper.ExecuteSP_Single <string>(SpCarrier.florida_Carrier_insert, new
{
@Driver = carrier.CarrierDriver,
@Licence = carrier.CarrierLicense,
@CarPlane = carrier.CarrierCarPlate,
@CarModel = carrier.CarrierCarModel,
@Company = carrier.CarrierCompany
//@CompanyId = carrier.CompanyId
});
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
}
}
public async Task Insert(UserEntity entity)
{
int userExist;
string uservalidado = await dapperHelper.ExecuteSP_Single <string>(User.VALIDATE, new
{
@UserFirstName = entity.UserFirstName,
@UserLastName = entity.UserLastName,
@UserEmail = entity.UserEmail,
@UserLogin = entity.UserLogin,
@UserPassword = entity.UserPassword
});
userExist = Convert.ToInt32(uservalidado);
if (userExist != 0)
{
var ex = new ArgumentException("Hey, soy una excepción guardada en una variable");
throw ex;
}
else
{
try
{
await dapperHelper.ExecuteSP_Single <string>(User.INSERT, new
{
@UserFirstName = entity.UserFirstName,
@UserLastName = entity.UserLastName,
@UserEmail = entity.UserEmail,
@UserLogin = entity.UserLogin,
@UserPassword = entity.UserPassword,
@CompanyId = entity.CompanyId,
@UserRoles = entity.Roles.AsTableValuedParameter("udtt_RoleUserType", new[] { "RoleId" })
});
}
catch (Exception e)
{
throw e;
}
}
}
public async Task InsertBid(List <BidEntity> bid, int companyId, string userUniqueName)
{
try
{
await dapperHelper.ExecuteSP_Single <BidEntity>(SpBid.INSERT, new
{
@BuyerId = companyId,
@BidArray = bid.AsTableValuedParameter("udtt_BidArrayType", new[] {
"BidId",
"VendorId",
"HeaderId",
"Status",
}),
@CreatedBy = userUniqueName
});
}
catch (Exception e)
{
throw e;
}
}
public async Task InsertWarehouse(WarehouseEntity warehouse, string userUniqueName, int companyId)
{
try
{
await dapperHelper.ExecuteSP_Single <string>(SpWarehouse.INSERT, new
{
@WarehouseName = warehouse.WarehouseName,
@WarehouseAddress = warehouse.WarehouseAddress,
@WarehouseCity = warehouse.WarehouseCity,
@WarehouseState = warehouse.WarehouseState,
@WarehouseCountry = warehouse.WarehouseCountry,
@WarehousePhone = warehouse.WarehousePhone,
@CompanyId = companyId,
@CreatedBy = userUniqueName
});
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace);
}
}
public async Task InsertAttachment(List <AttachmentEntity> attachments, string createdBy, int headerId)
{
try
{
await dapperHelper.ExecuteSP_Single <AttachmentEntity>(SpAttachment.INSERT, new
{
@AttachmentArray = attachments.AsTableValuedParameter("udtt_AttachmentArrayType", new[] {
"AttachmentId",
"AttachmentDescription",
"AttachmentPath",
"Deleted",
"HeaderId",
"isNew"
}),
@CreatedBy = createdBy,
@ModifiedBy = createdBy,
@HeaderId = headerId
});
}
catch (Exception e)
{
throw e;
}
}
//Rfx
public async Task <int> Insert_Rfx(HeaderEntity header, string createdBy, int userId, int companyId)
{
try
{
string idHeader = await dapperHelper.ExecuteSP_Single <string>(Header.INSERT_RFX, new
{
@BuyerCompanyId = companyId,
@DocumentNumber = header.DocumentNumber,
@Description = header.Description,
@Budget = header.Budget,
@Status = header.Status,
@DecisionDate = header.DecisionDate,
@RequestDeliveryDate = header.RequestDeliveryDate,
@LeadDays = header.LeadDays,
@OpenDate = header.OpenDate,
@CloseDate = header.CloseDate,
@ValidityStartDate = header.ValidityStartDate,
@ValidityEndDate = header.ValidityEndDate,
@RealDeliveryDate = header.RealDeliveryDate,
@TotalGrossValue = header.TotalGrossValue,
@TotalTaxValue = header.TotalTaxValue,
@TotalAllowances = header.TotalAllowances,
@TotalCharges = header.TotalCharges,
@PaymentType = header.PaymentType,
@CreditDetail = header.CreditDetail,
@DepartureDate = header.DepartureDate,
@ArrivalDate = header.ArrivalDate,
@DocCancelBy = header.DocCancelBy,
@DocCancelOn = header.DocCancelOn,
@CancelReason = header.CancelReason,
@DocPartLocation = header.DocPartLocation,
@PaymentTypeDocument = header.PaymentTypeDocument,
@PaymentTypeDocumentNumber = header.PaymentTypeDocumentNumber,
@LastModifiedOn = header.LastModifiedOn,
@LastModifiedBy = header.LastModifiedBy,
@CargoValue = header.CargoValue,
@HeaderNote = header.HeaderNote,
@AwardingNote = header.AwardingNote,
@SummaryNote = header.SummaryNote,
@CurrencyId = header.CurrencyId,
@UserId = userId,
@CreatedBy = createdBy
});
return(Convert.ToInt32(idHeader));
}
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 <JsonResult> UploadFile(IFormCollection collection, int headerId)
{
try
{
string companyCode = HttpContext.User.Claims.First(c => c.Type == "CompanyCode").Value;
HeaderEntity header = dapperHelper.ExecuteSP_Single <HeaderEntity>(Header.GET_BY_ID, new { @headerId = headerId, @companyId = 0 }).Result;
CompanyEntity buyer = dapperHelper.ExecuteSP_Single <CompanyEntity>(SpCompany.GET_BY_ID, new { @companyId = header.BuyerCompanyId }).Result;
string buyerCode = buyer.CompanyCode;
//Azure
// Retrieve storage account from connection string.
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(storageConnectionString);
// Create the blob client.
CloudBlobClient serviceClient = storageAccount.CreateCloudBlobClient();
// Create container. Name must be lower case.
Console.WriteLine("Creating container...");
CloudBlobContainer container = serviceClient.GetContainerReference(buyerCode.ToLower());
container.CreateIfNotExistsAsync().Wait();
List <AttachmentEntity> attachments = new List <AttachmentEntity>();
string rootPath = Directory.GetCurrentDirectory();
rootPath = Path.GetFullPath(Path.Combine(rootPath, @"..\..\"));
string savePath = rootPath + "Attachments";//Ftp
if (!System.IO.Directory.Exists(Path.Combine(savePath)))
{
Directory.CreateDirectory(Path.Combine(savePath));
}
string savePathAzure = "attachments";//Azure
var f = collection.Files;
foreach (var file in f)
{
AttachmentEntity attachment = new AttachmentEntity();
string filePath = savePath + "\\" + companyCode + "_" + headerId; //Ftp
string filePathAzure = savePathAzure + "\\" + companyCode + "_" + headerId; //Azure
// Get the name of the file to upload.
string fileName = file.FileName; //Ftp
string fileNameAzure = file.FileName; //Azure
//// Create the path and file name to check for duplicates.
//string pathToCheck = filePath + "_" + fileName;
//// Create a temporary file name to use for checking duplicates.
//string tempfileName = "";
//// Check to see if a file already exists with the
//// same name as the file to upload.
//if (System.IO.File.Exists(pathToCheck))
//{
// int counter = 2;
// while (System.IO.File.Exists(pathToCheck))
// {
// // if a file with this name already exists,
// // prefix the filename with a number.
// tempfileName = Path.GetFileNameWithoutExtension(fileName) + '(' + counter.ToString() + ')' + Path.GetExtension(fileName);
// pathToCheck = filePath + '_' + tempfileName;
// counter++;
// }
// fileName = tempfileName;
//}
// Append the name of the file to upload to the path.
filePath += "_" + fileName; //Ftp
filePathAzure += "_" + fileNameAzure; //Azure
// Retrieve reference to a blob named "myblob".
CloudBlockBlob blockBlob = container.GetBlockBlobReference(filePathAzure.ToLower());
////Upload file to API
//using (var stream = new FileStream(filePath, FileMode.Create))
//{
// await file.CopyToAsync(stream);
//}
////Upload file from API to Azure Storage
//using (var fileStream = System.IO.File.OpenRead(filePath))
//{
// await blockBlob.UploadFromStreamAsync(fileStream);
//}
////Delete file from API
//System.IO.File.Delete(filePath);
Stream temp;
temp = file.OpenReadStream();
await blockBlob.UploadFromStreamAsync(temp);
attachment.AttachmentDescription = fileName;
//attachment.AttachmentPath = filePath;
attachments.Add(attachment);
}
return(Json(attachments));
}
catch (Exception ex)
{
await errorServices.ErrorNotification(ex, HttpContext.User.Identity.Name, "", "");
return(Json(ex));
}
}
public async Task Insert(List <DetailEntity> details, string userUniqueName)
{
try
{
try
{
string sinCodigoId;
sinCodigoId = await dapperHelper.ExecuteSP_Single <string>(Product.SIN_CODIGO);
foreach (var item in details)
{
if (item.ProductId == 0)
{
item.ProductId = Int32.Parse(sinCodigoId);
}
}
}
catch (Exception)
{
}
foreach (var item in details)
{
if (item.ProductionDate < new DateTime(1900, 1, 1))
{
item.ProductionDate = new DateTime(1900, 1, 1);
}
if (item.ExpirationDate < new DateTime(1900, 1, 1))
{
item.ExpirationDate = new DateTime(1900, 1, 1);
}
}
await dapperHelper.ExecuteSP_Single <DetailEntity>(SpDetail.INSERT, new
{
@DetailArray = details.AsTableValuedParameter("udtt_DetailArrayType", new[] {
"DetailId",
"HeaderId",
"ProductId",
"SellerProductCode",
"SellerProductPartNumber",
"ProductionDate",
"ExpirationDate",
"LeadDays",
"CharacteristicId",
"Description",
"MeasuranceUnit",
"StandardPartNumber",
"PartNumberOther",
"AdditionalPartNumber",
"ItemQuantity",
"EnforceQuantity",
"QuantityAwarded",
"OrderQuantity",
"ShippedQuantity",
"ReferalPrice",
"UnitPrice",
"Subtotal",
"Weight",
"TradeDiscount",
"DetailNote",
"CountryProductOrigin",
"Status",
"isNew"
}),
@CreatedBy = userUniqueName,
@ModifiedBy = userUniqueName
});
}
catch (Exception e)
{
throw e;
}
}