public int Add(Inventory obj)
{
try
{
var nowYear = DateTime.Now.ToString("yyyy");
var last = (from q in _db.Inventories
where q.InventoryCode.Substring(0, 4) == nowYear
orderby q.InventoryIndex descending
select q).FirstOrDefault();
if (last == null)
{
obj.InventoryIndex = 1;
}
else
{
obj.InventoryIndex = last.InventoryIndex + 1;
}
var siteLocation = new CSiteLocation().Get(obj.SiteLocationId);
var site = new CSite().Get(siteLocation.SiteId);
string siteName;
if (site?.SiteId == 1)
{
siteName = site.Abbreviation;
}
else
{
siteName = site?.Abbreviation?.Substring(0, 2) + siteLocation?.Name?.Substring(0, 1);
}
var inventoryCategoryItem = new CInventoryCategoryItem().Get(obj.InventoryCategoryItemId);
var inventoryCategory = new CInventoryCategory().Get(inventoryCategoryItem.InventoryCategoryId);
obj.InventoryCode = nowYear + siteName + inventoryCategory?.Abbreviation + obj.InventoryIndex.ToString("D6");
_db.Inventories.InsertOnSubmit(obj);
_db.SubmitChanges();
}
catch (Exception ex)
{
Debug.Print(ex.Message);
return(-1);
}
return(_db.Inventories.Max(x => x.InventoryId));
}
public string GetLogoImagePath(int siteLocationId, CConstValue.ImageType imageType)
{
// location
var siteLocation = new CSiteLocation().Get(siteLocationId);
var site = new CSite().Get(Convert.ToInt32(siteLocation.SiteId));
var fileSb = new StringBuilder();
fileSb.Append(site.Abbreviation);
switch (imageType)
{
case CConstValue.ImageType.Basic:
// nothing
break;
case CConstValue.ImageType.Small:
fileSb.Append("_small");
break;
case CConstValue.ImageType.Sign:
fileSb.Append("_sign");
break;
case CConstValue.ImageType.Logo:
fileSb.Append("_logo");
break;
case CConstValue.ImageType.LogoSide:
fileSb.Append("_side");
break;
}
fileSb.Append(".png");
return(HttpContext.Current.Server.MapPath("~/assets/img/" + fileSb));
}
