/// <summary>
/// Generates the notifications for bookings.
/// </summary>
/// <param name="userID">The user identifier.</param>
/// <param name="itemBriefId">The item brief identifier.</param>
/// <param name="itemId">The item identifier.</param>
/// <param name="projectId">The project identifier.</param>
/// <param name="action">The action.</param>
public void GenerateNotificationsForBookings(int userID, int itemBriefId, int itemId, int projectId, BookingAction action)
{
PersonalBL personalBL = new PersonalBL(DataContext);
User user = personalBL.GetUser(userID);
string userName = string.Concat(user.FirstName + " " + user.LastName).Trim();
InventoryBL inventoryBL = new InventoryBL(DataContext);
Data.Item item = inventoryBL.GetItem(itemId);
ItemBriefBL itemBriefBL = new ItemBriefBL(DataContext);
Data.ItemType itemType = itemBriefBL.GetItemBriefType(itemBriefId).ItemType;
if (itemType != null && item != null)
{
StageBitz.Data.Notification nf = new StageBitz.Data.Notification();
nf.CreatedByUserId = nf.LastUpdatedByUserId = userID;
nf.CreatedDate = nf.LastUpdatedDate = Utils.Now;
nf.RelatedId = itemBriefId;
nf.ProjectId = projectId;
nf.ModuleTypeCodeId = Utils.GetCodeIdByCodeValue("ModuleType", "ITEMBRIEFBOOKING");
string message = string.Empty;
switch (action)
{
case BookingAction.Pin:
message = "{0} pinned {1} from the Company Inventory to this {2} Brief.";
nf.OperationTypeCodeId = Utils.GetCodeIdByCodeValue("OperationType", "PIN");
break;
case BookingAction.Keep:
message = "{0} confirmed {1} from the Company Inventory to use for this {2} Brief.";
nf.OperationTypeCodeId = Utils.GetCodeIdByCodeValue("OperationType", "KEEP");
break;
case BookingAction.Remove:
message = "{0} returned {1} to the Company Inventory and removed it as an option for this {2} Brief.";
nf.OperationTypeCodeId = Utils.GetCodeIdByCodeValue("OperationType", "REMOVE");
break;
case BookingAction.RemoveWithSnapshot:
message = "{0} released {1} to the Company Inventory and kept a record for this {2} Brief.";
nf.OperationTypeCodeId = Utils.GetCodeIdByCodeValue("OperationType", "REMOVE");
break;
}
nf.Message = string.Format(message, userName, item.Name, itemType.Name);
this.AddNotification(nf);
}
}
/// <summary>
/// Initializes the ids.
/// </summary>
/// <param name="itemId">The item identifier.</param>
/// <param name="itemBriefId">The item brief identifier.</param>
/// <param name="isItemCreated">if set to <c>true</c> [is item created].</param>
public void InitializeIds(ref int itemId, ref int itemBriefId, ref bool isItemCreated)
{
InventoryBL inventoryBL = new InventoryBL(DataContext);
ItemBriefBL itemBriefBL = new ItemBriefBL(DataContext);
if (itemId > 0)
{
StageBitz.Data.Item item = inventoryBL.GetItem(itemId);
if (item != null)
{
isItemCreated = true;
}
}
else if (itemBriefId > 0)
{
StageBitz.Data.ItemBrief itemBrief = itemBriefBL.GetItemBrief(itemBriefId);
if (itemBrief != null)
{
ItemBooking itemBooking = itemBriefBL.GetInUseItemBooking(itemBriefId);
Data.Item item = null;
if (itemBooking != null)
{
item = itemBooking.Item;
}
if (item != null)
{
itemId = item.ItemId;
isItemCreated = true;
}
else
{
isItemCreated = false;
}
}
}
}
/// <summary>
/// Saves the item details.
/// </summary>
/// <param name="itemDetails">The item details.</param>
/// <param name="skipConcurrencyCheck">if set to <c>true</c> [skip concurrency check].</param>
/// <param name="shouldCommit">if set to <c>true</c> [should commit].</param>
/// <returns></returns>
public ItemResultObject SaveItemDetails(ItemDetails itemDetails, bool skipConcurrencyCheck = false, bool shouldCommit = false)
{
ItemResultObject itemResultObject = new ItemResultObject();
ItemBriefBL itemBriefBL = new ItemBriefBL(DataContext);
InventoryBL inventoryBL = new InventoryBL(DataContext);
ProjectBL projectBL = new ProjectBL(DataContext);
LocationBL locationBL = new LocationBL(DataContext);
CompanyBL companyBL = new CompanyBL(DataContext);
int itemId = itemDetails.ItemId;
int companyId = 0;
int projectId = 0;
Data.ItemBrief itemBrief = itemBriefBL.GetItemBrief(itemDetails.ItemBriefId);
Data.Item item = inventoryBL.GetItem(itemId);
if (itemDetails.ItemId > 0)
{
companyId = item.CompanyId.Value;
}
else if (itemBrief != null && item == null)
{
companyId = itemBrief.Project.CompanyId;
projectId = itemBrief.ProjectId;
item = new Item();
item.CompanyId = companyId;
}
bool isInventoryPage = itemDetails.RelatedTable == "Company";
string relatedTable = "Company";
int relatedId = companyId;
if (itemDetails.RelatedTable == "Project" && projectId > 0)
{
relatedTable = itemDetails.RelatedTable;
relatedId = projectId;
}
if (!projectBL.ShouldStopProcessing(relatedTable, relatedId, itemDetails.UserId))
{
ErrorCodes errorCode;
if (itemDetails.ItemBriefId > 0 && !inventoryBL.CanEditIteminItemBrief(itemDetails.ItemBriefId, itemDetails.ItemId))
{
itemResultObject.Status = "CONCURRENCY";
itemResultObject.ErrorCode = (int)ErrorCodes.NoEditPermissionForItemInItemBrief;
itemResultObject.Message = "No Write Permission";
return(itemResultObject);
}
else if (relatedTable == "Company" && itemId > 0 && inventoryBL.CheckPermissionsForItemDetailsPage(itemDetails.UserId, itemId, companyId, out errorCode, false) == null)
{
itemResultObject.Status = "CONCURRENCY";
itemResultObject.ErrorCode = (int)errorCode;
itemResultObject.Message = "No Write Permission";
return(itemResultObject);
}
else if (!skipConcurrencyCheck && itemId > 0 && itemDetails.LastUpdatedDate != item.LastUpdatedDate)
{
itemResultObject.Status = "NOTOK";
itemResultObject.Message = "Can not update";
return(itemResultObject);
}
item.Name = itemDetails.Name;
item.Description = itemDetails.Description;
if (itemDetails.IsEditableToAdminOnly && item.Quantity != itemDetails.Quantity)//Commit if changes exist
{
bool canSaveQty = true;
if (item.Quantity > itemDetails.Quantity)//Only when reduces Units
{
int maxBookedQty = inventoryBL.GetMaxBookedQuantityForAllDuration(itemDetails.ItemId);
if (maxBookedQty > itemDetails.Quantity)
{
canSaveQty = false;
}
}
if (canSaveQty)
{
item.Quantity = itemDetails.Quantity;
}
else
{
itemResultObject.Status = "CONCURRENCY";
itemResultObject.ErrorCode = (int)ErrorCodes.QuantityUpdateFailed;
itemResultObject.Message = "Can not reduce quantity";
return(itemResultObject);
}
}
item.LastUpdatedByUserId = itemDetails.UserId;
item.LastUpdatedDate = Utils.Now;
if (isInventoryPage)
{
if (companyBL.HasEditPermissionForInventoryStaff(companyId, itemDetails.UserId, itemDetails.LocationId))
{
item.CreatedFor = itemDetails.CreatedFor;
if (itemDetails.LocationId.HasValue)
{
Data.Location location = locationBL.GetLocation(itemDetails.LocationId.Value);
if (location == null)
{
itemResultObject.Status = "CONCURRENCY";
itemResultObject.ErrorCode = (int)ErrorCodes.InventoryLocationDeleted;
itemResultObject.Message = "Item Location not available";
return(itemResultObject);
}
}
item.LocationId = itemDetails.LocationId;
}
else
{
itemResultObject.Status = "CONCURRENCY";
itemResultObject.ErrorCode = (int)ErrorCodes.NoEditPermissionForInventory;
itemResultObject.Message = "No Edit Permission For Item In Inventory";
return(itemResultObject);
}
}
if (itemDetails.ItemTypeId.HasValue)
{
item.ItemTypeId = itemDetails.ItemTypeId;
}
//Update ItemBooking
if (itemBrief != null)
{
ItemBooking itemBooking = inventoryBL.GetItemBookingByItemID(itemId, itemBrief.ItemBriefId, "ItemBrief");
itemBooking.Quantity = itemDetails.Quantity.Value;
itemBooking.LastUpdateDate = Utils.Now;
itemBooking.LastUpdatedBy = itemDetails.UserId;
}
if (itemDetails.ItemValues != null)
{
foreach (ValuesInfo iValue in itemDetails.ItemValues)
{
if (iValue.Id == 0)
{
//It is an Insert
ItemValue iValueNew = new ItemValue();
iValueNew.ItemId = item.ItemId;
iValueNew.FieldId = iValue.FieldId;
iValueNew.Value = iValue.Value;
iValueNew.FieldOptionId = iValue.FieldOptionId;
DataContext.ItemValues.AddObject(iValueNew);
}
else
{
//Update
ItemValue itemValue = GetItemFieldValueById(iValue.Id);
if (itemValue != null)
{
if (iValue.Value == string.Empty && iValue.FieldOptionId == null)
{
DataContext.ItemValues.DeleteObject(itemValue);
}
else
{
itemValue.FieldOptionId = iValue.FieldOptionId;
itemValue.Value = iValue.Value;
}
}
}
}
}
if (shouldCommit)
{
DataContext.SaveChanges();
}
itemResultObject.Status = "OK";
return(itemResultObject);
}
else
{
itemResultObject.Status = "STOPPROCESS";
return(itemResultObject);
}
}
/// <summary>
/// Gets the item details.
/// </summary>
/// <param name="itemId">The item identifier.</param>
/// <param name="itemBriefId">The item brief identifier.</param>
/// <param name="userId">The user identifier.</param>
/// <param name="itemTypeIdToBeLoad">The item type identifier to be load.</param>
/// <param name="fromDate">From date.</param>
/// <param name="toDate">To date.</param>
/// <returns></returns>
public ItemDetails GetItemDetails(int itemId, int itemBriefId, int userId, int?itemTypeIdToBeLoad, DateTime?fromDate = null, DateTime?toDate = null)
{
bool isItemCreated = false;
bool isReadOnly = false;
int itemTypeId = 0;
InventoryBL inventoryBL = new InventoryBL(DataContext);
ItemBriefBL itemBriefBL = new ItemBriefBL(DataContext);
ItemDetails itemDetails = new ItemDetails();
InitializeIds(ref itemId, ref itemBriefId, ref isItemCreated);
if (itemId > 0)
{
StageBitz.Data.Item item = inventoryBL.GetItem(itemId);
if (item != null)
{
ItemBooking itemBooking = null;
itemDetails.IsEditableToAdminOnly = true;
if (itemBriefId > 0)
{
ProjectBL projectBL = new ProjectBL(DataContext);
itemBooking = itemBriefBL.GetInUseItemBooking(itemBriefId);
itemDetails.CanEditInItemBrief = inventoryBL.CanEditIteminItemBrief(itemBriefId, itemId);
itemDetails.IsEditableToAdminOnly = inventoryBL.IsItemGeneretedFromGivenItemBrief(itemId, itemBriefId) && !projectBL.IsReadOnlyRightsForProject(itemBriefBL.GetItemBrief(itemBriefId).ProjectId, userId, true);
}
else
{
itemDetails.MinQuantity = inventoryBL.GetMaxBookedQuantityForAllDuration(item.ItemId);
ItemStatusInformationForUser itemStatusInformationForUser = inventoryBL.GetItemStatusInformationForUser(item, item.CompanyId.Value, userId);
isReadOnly = itemStatusInformationForUser.IsReadOnly;
itemDetails.IsEditableToAdminOnly = itemStatusInformationForUser.CanEditQuantity;
}
itemDetails.Name = item.Name;
itemDetails.Description = item.Description;
itemDetails.LocationId = item.LocationId;
itemDetails.Quantity = itemBooking != null ? itemBooking.Quantity : item.Quantity.HasValue ? item.Quantity.Value : item.Quantity;
User bookingManager = inventoryBL.GetContactBookingManager(item.CompanyId.Value, item.LocationId);
if (bookingManager != null)
{
itemDetails.BookingManagerName = Utils.GetFullName(bookingManager);
itemDetails.BookingManagerEmail = bookingManager.Email1;
}
if (fromDate.HasValue && toDate.HasValue)
{
itemDetails.AvailableQty = DataContext.GetAvailableItemQuantity(itemId, fromDate.Value, toDate.Value, 0).FirstOrDefault().Value;
}
itemDetails.CreatedFor = item.CreatedFor;
itemDetails.ItemBriefId = itemBriefId;
itemDetails.LastUpdatedDate = item.LastUpdatedDate;
itemTypeId = itemTypeIdToBeLoad.HasValue ? itemTypeIdToBeLoad.Value : item.ItemTypeId.Value;
itemDetails.LastUpdatedDate = item.LastUpdatedDate;
itemDetails.ItemStatus = itemBooking != null?inventoryBL.GetItemBookingStatus(itemBooking.ItemBookingId).Description : string.Empty;
itemDetails.ItemId = itemId;
itemDetails.ItemValues = GetItemFieldValues(itemId).Select(iv =>
new ValuesInfo
{
Id = iv.ItemValueId,
FieldId = iv.FieldId,
FieldOptionId = iv.FieldOptionId,
Value = iv.Value
}).ToList();
itemDetails.CountryId = inventoryBL.GetCountryIdByItemId(item.ItemId);
itemDetails.ItemTypeId = item.ItemTypeId;
itemDetails.Status = "OK";
}
}
else if (itemBriefId > 0)
{
Data.ItemVersionHistory itemVersionHistory = inventoryBL.GetItemVersionHistoryByItemBriefId(itemBriefId);
itemDetails.ItemBriefId = itemBriefId;
if (itemVersionHistory != null)
{
itemId = itemVersionHistory.ItemId;
itemDetails.Name = itemVersionHistory.Name;
itemDetails.Description = itemVersionHistory.Description;
itemDetails.LocationId = null; //itemVersionHistory.Location;
itemDetails.Quantity = itemVersionHistory.Quantity.HasValue ? itemVersionHistory.Quantity.Value : itemDetails.Quantity;
itemDetails.IsEditableToAdminOnly = false;
itemDetails.ItemBriefId = itemVersionHistory.ItemBriefId;
itemDetails.ItemValues = GetItemVersionHistoryValues(itemVersionHistory.ItemVersionHistoryId).Select(ivhv =>
new ValuesInfo
{
Id = ivhv.ItemVersionHistoryId,
FieldId = ivhv.FieldId,
FieldOptionId = ivhv.FieldOptionId,
Value = ivhv.Value
}).ToList();
itemTypeId = itemTypeIdToBeLoad.HasValue ? itemTypeIdToBeLoad.Value : itemVersionHistory.ItemTypeId.Value;
itemDetails.CountryId = inventoryBL.GetCountryIdByItemId(itemVersionHistory.ItemId);
itemDetails.ItemTypeId = itemVersionHistory.ItemTypeId;
itemDetails.Status = "OK";
}
else
{
StageBitz.Data.ItemBrief itemBrief = itemBriefBL.GetItemBrief(itemBriefId);
if (itemBrief != null)
{
itemDetails.Name = itemBrief.Name;
itemDetails.Description = itemBrief.Description;
itemDetails.LocationId = null;
itemDetails.IsEditableToAdminOnly = true;
itemDetails.ItemBriefId = itemBriefId;
itemDetails.Quantity = itemBrief.Quantity.HasValue ? itemBrief.Quantity.Value : itemBrief.Quantity;
itemDetails.ItemBriefId = itemBrief.ItemBriefId;
itemDetails.ItemValues = GetItemBriefFieldValues(itemBriefId).Select(ibfv =>
new ValuesInfo
{
Id = 0,
FieldId = ibfv.FieldId,
FieldOptionId = ibfv.FieldOptionId,
Value = ibfv.Value
}).ToList();
itemTypeId = itemTypeIdToBeLoad.HasValue ? itemTypeIdToBeLoad.Value : itemBriefBL.GetItemBriefType(itemBrief.ItemBriefId).ItemTypeId;
itemDetails.CountryId = itemBriefBL.GetCountryIdByItemBriefId(itemBrief.ItemBriefId);
itemDetails.Status = "OK";
itemDetails.CanEditInItemBrief = true;
itemDetails.ItemTypeId = itemBrief.ItemBriefTypes.FirstOrDefault().ItemTypeId;
}
}
}
itemDetails.IsReadOnly = isReadOnly;
itemDetails.DisplayMarkUp = GetItemTypeHTML(itemTypeId);
Data.ItemType itemType = Utils.GetItemTypeById(itemDetails.ItemTypeId.Value);
itemDetails.ItemTypeName = itemType != null ? itemType.Name : string.Empty;
return(itemDetails);
}
public ItemResult SyncItem(MobileItem mobileItem)
{
string status = string.Empty;
string message = string.Empty;
ItemResult itemResult = new ItemResult();
bool isValidVersion = true;
try
{
using (StageBitzDB dataContext = new StageBitzDB())
{
isValidVersion = Helper.IsValidAppVersion(mobileItem.Version, out status);
if (isValidVersion)
{
if (mobileItem != null)
{
//Check if this Item has already been created in MobileItem table
//If not create
InventoryMobileItem inventoryMobileItem = dataContext.InventoryMobileItems.Where(imi => imi.MobileItemId == mobileItem.DeviceItemId).FirstOrDefault();
if (inventoryMobileItem == null)
{
int userId = int.Parse(Utils.DecryptStringAES(mobileItem.Token));
//Check if the user can Create the Item
CompanyBL companyBL = new CompanyBL(dataContext);
FinanceBL financeBL = new FinanceBL(dataContext);
InventoryBL inventoryBL = new InventoryBL(dataContext);
if (companyBL.HasEditPermissionForInventoryStaff(mobileItem.CompanyId, userId, null))
{
//New Creation of Item
if (mobileItem.ItemId == 0)
{
//To create items in the hidden mode, if the limits have reached.
bool isFreeTrailCompany = companyBL.IsFreeTrialCompany(mobileItem.CompanyId);
CompanyPaymentPackage companyPaymentPackage = financeBL.GetCurrentPaymentPackageFortheCompanyIncludingFreeTrial(mobileItem.CompanyId);
InventoryPaymentPackageDetails inventoryPaymentPackageDetails = null;
if (companyPaymentPackage != null)
{
inventoryPaymentPackageDetails =
Utils.GetSystemInventoryPackageDetailByPaymentPackageTypeId(companyPaymentPackage.InventoryPaymentPackageTypeId);
}
CompanyCurrentUsage companyCurrentUsage = financeBL.GetCompanyCurrentUsage(mobileItem.CompanyId, null);
if (!financeBL.HasExceededInventoryLimit(isFreeTrailCompany, inventoryPaymentPackageDetails, companyCurrentUsage))
{
inventoryMobileItem = new InventoryMobileItem();
inventoryMobileItem.MobileItemId = mobileItem.DeviceItemId;
inventoryMobileItem.CreatedBy = userId;
inventoryMobileItem.CreatedDate = Utils.Now;
dataContext.InventoryMobileItems.AddObject(inventoryMobileItem);
Item item = new Item();
item.Name = mobileItem.Name;
item.IsManuallyAdded = true;
item.ItemTypeId = mobileItem.ItemTypeId;
item.Quantity = mobileItem.Quantity;
item.Description = mobileItem.Description;
item.CompanyId = mobileItem.CompanyId;
item.IsActive = true;
item.CreatedByUserId = item.LastUpdatedByUserId = userId;
item.CreatedDate = item.LastUpdatedDate = Utils.Now;
item.VisibilityLevelCodeId = Utils.GetCodeIdByCodeValue("InventoryVisibilityLevel", "ABOVE_SHAREDINVENTORY");
dataContext.Items.AddObject(item);
dataContext.SaveChanges();
itemResult.Id = item.ItemId;
status = "OK";
}
else
{
status = "LIMITREACHED";
message = "Inventory plan limit reached.";
}
}
else
{
//Edit existing one
Item exItem = inventoryBL.GetItem(mobileItem.ItemId);
if (exItem != null && exItem.IsActive)
{
Code userVisibilityCode = inventoryBL.GetUserInventoryVisibilityLevel(mobileItem.CompanyId, userId, null, false);
if (!inventoryBL.GetItemStatusInformationForUser(exItem, mobileItem.CompanyId, userId).IsReadOnly&& exItem.Code.SortOrder >= userVisibilityCode.SortOrder)
{
if (mobileItem.LastUpdateDate == exItem.LastUpdatedDate)
{
exItem.Name = mobileItem.Name;
exItem.ItemTypeId = mobileItem.ItemTypeId;
exItem.Description = mobileItem.Description;
exItem.Quantity = mobileItem.Quantity;
exItem.LastUpdatedByUserId = userId;
exItem.LastUpdatedDate = Utils.Now;
dataContext.SaveChanges();
status = "OK";
itemResult.Id = mobileItem.ItemId;
}
else
{
status = "ITEMEDITED";
message = "Item already edited.";
}
}
else
{
status = "NORIGHTS";
message = "Check settings with Company Administrator.";
}
}
else
{
status = "ITEMDELETED";
message = "Item no longer exists.";
}
}
}
else
{
status = "NOACCESS";
message = "Check settings with Company Administrator.";
}
}
else
{
itemResult.Id = inventoryMobileItem.ItemId;
status = "ITEMEXIST";
message = "Item already synced.";
}
}
}
else
{
status = "INVALIDAPP";
message = "Please update App.";
}
}
}
catch (Exception ex)
{
AgentErrorLog.HandleException(ex);
status = "ERROR";
message = "Oops! Unkown error. Sorry...";
}
itemResult.MobileId = mobileItem.DeviceItemId;
itemResult.Status = status;
itemResult.Message = message;
return(itemResult);
}
