/// <summary>
/// Gets the by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
public Product GetById(int id)
{
using (DataModelEntities model = new DataModelEntities())
{
var retVal = model.Product
.Include(p => p.ProductType)
.Include(p => p.Rating)
.Include(p => p.Item)
.Include(p => p.State)
.Include(p => p.CreateOperator)
.Include(p => p.Customer)
.Include(p => p.PaperReference)
.Include(p => p.City)
.Include(p => p.City.Country)
.Include(p => p.Customer.CustomerType)
.Include(p => p.SellingOperator)
.Include(p => p.Categories)
.Include(p => p.Brands)
.Include(p => p.Models)
.FirstOrDefault(p => p.Id.Equals(id));
return(retVal);
}
}
/// <summary>
/// Creates the specified file name.
/// </summary>
/// <param name="fileName">Name of the file.</param>
/// <param name="extension">The extension.</param>
/// <param name="mimeType">Type of the MIME.</param>
/// <param name="content">The content.</param>
/// <param name="productId">The product identifier.</param>
/// <returns></returns>
public Attachment Create(string fileName, string extension, string mimeType, byte[] content, int productId)
{
using (DataModelEntities model = new DataModelEntities())
{
Attachment retVal = null;
if (model.Product.Any(p => p.Equals(productId)))
{
retVal = new Attachment
{
FileName = fileName,
Extension = extension,
MimeType = mimeType,
Content = content,
ProductId = productId
};
model.Attachment.AddObject(retVal);
model.SaveChanges();
}
return(retVal);
}
}
public AppDataAccess(LoadDataGridViewAsync form)
{
this.callingForm = form;
db = new DataModelEntities();
}
/// <summary>
/// Saves the basic information.
/// </summary>
/// <param name="productId">The product identifier.</param>
/// <param name="name">The name.</param>
/// <param name="productTypeId">The category identifier.</param>
/// <param name="itemId">The item identifier.</param>
/// <param name="paperReferenceId">The paper reference identifier.</param>
/// <param name="locationId">The location identifier.</param>
/// <param name="customerId">The customer identifier.</param>
/// <param name="operatorId">The operator identifier.</param>
/// <param name="ratingId">The rating identifier.</param>
/// <param name="yearIds">The year ids.</param>
/// <param name="depositDate">The deposit date.</param>
/// <returns></returns>
public Product SaveBasicInfo(int productId, string name, int productTypeId, int itemId, int locationId, int customerId, int operatorId, int[] categoryIds, int[] brandIds, int[] modelIds,
int[] yearIds, int stateId, decimal buyinPrice, DateTime depositDate)
{
using (DataModelEntities dataModel = new DataModelEntities())
{
var product = dataModel.Product.FirstOrDefault(p => p.Id.Equals(productId));
if (product != null)
{
product.Name = name;
product.ProductTypeId = productTypeId;
product.ItemId = itemId;
product.LocationId = locationId;
product.CustomerId = customerId;
product.OperatorId = operatorId;
product.DepositBuyDate = depositDate;
product.BuyingPrice = buyinPrice;
product.StateId = stateId;
product.ProductYear.Clear();
product.StatusId = (int)Enums.ProductStatus.New;
dataModel.SaveChanges();
foreach (var yearId in yearIds)
{
product.ProductYear.Add(new ProductYear {
YearId = yearId
});
}
dataModel.SaveChanges();
}
else
{
product = new Product
{
Name = name,
ProductTypeId = productTypeId,
ItemId = itemId,
LocationId = locationId,
CustomerId = customerId,
OperatorId = operatorId,
DepositBuyDate = depositDate,
StateId = stateId,
BuyingPrice = buyinPrice,
StatusId = (int)Enums.ProductStatus.Sold
};
foreach (var yearId in yearIds)
{
product.ProductYear.Add(new ProductYear {
YearId = yearId
});
}
dataModel.Product.AddObject(product);
}
foreach (var categoryId in categoryIds)
{
product.Categories.Add(dataModel.Category.FirstOrDefault(c => c.Id.Equals(categoryId)));
}
foreach (var brandId in brandIds)
{
product.Brands.Add(dataModel.Brand.FirstOrDefault(b => b.Id.Equals(brandId)));
}
foreach (var modelId in modelIds)
{
product.Models.Add(dataModel.Model.FirstOrDefault(m => m.Id.Equals(modelId)));
}
dataModel.SaveChanges();
return(this.GetById(product.Id));
}
}
