public async Task AddCompanyProductAsync(CompanyProductModel model)
{
try
{
var company = await _context.Companies.FindAsync(model.Company);
if (company == null)
{
throw new Exception("Company not found");
}
var medicine = await _context.Medicines.FindAsync(model.Medicine);
if (medicine == null)
{
throw new Exception("Medicine not found");
}
Product product = new Product();
product.Company = company;
product.Medicine = medicine;
product.Quantity = model.Quantity;
product.Price = model.Price;
product.CreateDate = model.CreateDate;
product.ExpireDate = model.ExpireDate;
await _context.Products.AddAsync(product);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ActionResult> AddCompanyProduct(int Id)
{
var company = await _context.Companies.FindAsync(Id);
if (company == null)
{
ViewBag.CompanyName = "NULL";
}
else
{
ViewBag.CompanyName = company.Name;
}
CompanyProductModel model = new CompanyProductModel();
model.Company = company.Id;
return(View(model));
}
public async Task <ActionResult> AddCompanyProduct(CompanyProductModel model)
{
try
{
if (ModelState.IsValid)
{
await _productService.AddCompanyProductAsync(model);
}
else
{
TempData["message"] = ModelState.ErrorGathering();
}
return(RedirectToAction("Index", "Company"));
}
catch (Exception ex)
{
TempData["message"] = ex.Message;
return(RedirectToAction("Index", "Company"));
}
}
private CompanyProductModel ProductCompanyDetailList(string id)
{
var conpanyProduct = new CompanyProductModel();
try
{
if (!string.IsNullOrEmpty(id))
{
var currentuser = UserManager.Current();
if (currentuser != null && currentuser.OrgId != null)
{
conpanyProduct = EditCompanyProduct(int.Parse(id), currentuser.OrgId.Value);
var companylist = _companyRepository.SelectAll().Where(c => c.Org_Id == currentuser.OrgId && c.Active == true).ToList();
var compmodel = Mapper.Map<IEnumerable<Company>, List<CompanyModel>>(companylist);
var productcopmlist = _productCompanyRepo.GetAllProductCompanylist().Where(p => p.ProductId == int.Parse(id)).ToList();
if (productcopmlist.Count > 0 && companylist.Count > 0)
{
var prodlist =
productcopmlist.Where(
x => companylist.Select(y => y.Row_Id.ToString()).Contains(x.CompanyId.ToString()))
.ToList();
if (prodlist.Count > 0)
{
var finallist = CheckforCompanyEnable(prodlist, compmodel);
conpanyProduct.ProductCompanylist = finallist;
}
else
{
conpanyProduct.ProductCompanylist = compmodel;
}
}
else
{
conpanyProduct.ProductCompanylist = new List<CompanyModel>();
}
}
}
}
catch (Exception ex)
{
var error = ex.Message;
}
return conpanyProduct;
}
//..................Helper Mehods........................
private CompanyProductModel EditCompanyProduct(int id, int orgId)
{
var companyProduct = new CompanyProductModel();
try
{
var product = _repository.SelectById(id);
var productModel = Mapper.Map<Product, ProductModel>(product);
// .ForMember(dest => dest.FullName, opt => opt.MapFrom(src => src.Name));
productModel.ProductGroupslist = _repository.GetProductgroupBySp(orgId, null).ToList();
productModel.ProductSubGrouplist = _repository.GetProductgroupBySp(orgId, product.ProductGroupId).ToList();
// _productService.GetProductgroupBySp(currentuser.OrgId.Value, int.Parse(id)).ToList();
// var group = _productgroupRepo.GetAllProductgroup().FirstOrDefault(pg => pg.ProductId == product.ProductGroupId);
if (product != null && product.ProductGroupId != null)
{
var group = _productgroupRepo.GetProductGroupById(product.ProductGroupId.Value);
if (group != null)
{
// productModel.Group = group.ProductId.ToString();
productModel.Group = group.Row_Id.ToString();
}
}
companyProduct.ProductModel = productModel;
}
catch (Exception ex)
{
var error = ex.Message;
}
return companyProduct;
}
public CompanyProductModel Update(ProductModel model)
{
var compProdObj = new CompanyProductModel();
try
{
if (model != null)
{
// var productgroup = _productgroupRepo.GetAllProductgroup().FirstOrDefault(m => m.Row_Id == int.Parse(model.Group));
var productgroup = _productgroupRepo.GetProductGroupById(int.Parse(model.Group));
// using (var transaction = new TransactionScope())
// {
var prodObject = _repository.SelectById(model.Row_Id);
if (prodObject != null)
{
prodObject.SalesUnitPrice = model.SalesUnitPrice;
prodObject.XeroItemDescription = model.XeroItemDescription;
prodObject.ProductDescription = model.ProductDescription;
if (productgroup != null)
prodObject.ProductGroupId = productgroup.Row_Id;
_repository.Update(prodObject);
}
//if (!string.IsNullOrEmpty(model.CompanyIds))
//{
// var productcompanies = model.CompanyIds;
// var productcompaniesId = productcompanies.Split(',');
// DeleteCompamiesByProduct(model.Row_Id);
// AddCompamiesByProduct(model.Row_Id, productcompaniesId);
//}
//if (!string.IsNullOrEmpty(model.Group))
//{
// AddorUpdateProductGroup(model.Row_Id, model.Group);
//}
//if (model.ProductSchedule != null)
//{
// AddorUpdateProductSchedule(model.ProductSchedule, model.Row_Id);
//}
// transaction.Complete();
// }
compProdObj = ProductCompanyDetailList(model.Row_Id.ToString());
}
}
catch (Exception ex)
{
string error = ex.Message;
}
return compProdObj;
}
public CompanyProductModel GetProductCompanyList(string id)
{
var conpanyProduct = new CompanyProductModel();
try
{
if (!string.IsNullOrEmpty(id))
{
conpanyProduct = ProductCompanyDetailList(id);
}
}
catch (Exception ex)
{
var error = ex.Message;
}
return conpanyProduct;
}
