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);
}
/// <summary>
/// Gets the payment package summaries.
/// </summary>
/// <param name="paymentSummaryDetail">The payment summary detail.</param>
/// <param name="dateToConsider">The date to consider.</param>
/// <param name="dataContext">The data context.</param>
/// <returns></returns>
public static List <CompanyPaymentSummary> GetPaymentPackageSummaries(PaymentSummaryDetails paymentSummaryDetail, DateTime dateToConsider, StageBitzDB dataContext)
{
int anualDurationCodeId = Utils.GetCodeIdByCodeValue("PaymentPackageDuration", "ANUAL");
int invoiceMethodCodeId = Utils.GetCodeIdByCodeValue("PaymentMethod", "INVOICE");
List <CompanyPaymentSummary> summaryList = new List <CompanyPaymentSummary>();
DateTime nextCycleStartDate = Utils.Today;
decimal totalDue = 0;
decimal educationalDiscount = decimal.Parse(Utils.GetSystemValue("EducationalDiscount"));
FinanceBL financeBL = new FinanceBL(dataContext);
CompanyBL companyBL = new CompanyBL(dataContext);
CompanyPaymentSummary existingCompanyPackageSummary = dataContext.CompanyPaymentSummaries.Where(cps => cps.CompanyId == paymentSummaryDetail.CompanyId).OrderByDescending(cps => cps.CompanyPaymentSummaryId).FirstOrDefault();
CompanyPaymentPackage currentCompanyPaymentPackage = financeBL.GetPaymentPackageForCompanyByDay(dateToConsider, paymentSummaryDetail.CompanyId);
if (existingCompanyPackageSummary != null && companyBL.IsFreeTrialCompany(paymentSummaryDetail.CompanyId)) //check whether there is an upgrade/downgrade during the freetrial
{
existingCompanyPackageSummary = null;
}
if (existingCompanyPackageSummary == null || currentCompanyPaymentPackage == null)
{
//This is for the very first time from UI. So return the amount based on promotional and educational discount amount.
totalDue = financeBL.CalculateALLPackageAmountsByPeriod(paymentSummaryDetail.ProjectPaymentPackageTypeId, paymentSummaryDetail.InventoryPaymentPackageTypeId, paymentSummaryDetail.PaymentDurationTypeCodeId);
if (paymentSummaryDetail.IsEducationPackage)
{
totalDue = totalDue * (100 - educationalDiscount) / 100;
}
else if (paymentSummaryDetail.DiscountCodeUsageToApply != null)
{
DateTime endDate = paymentSummaryDetail.PaymentDurationTypeCodeId == anualDurationCodeId?paymentSummaryDetail.PackageStartDate.AddYears(1) : paymentSummaryDetail.PackageStartDate.AddMonths(1);
totalDue = financeBL.GetDiscountedAmount(paymentSummaryDetail.CompanyId, totalDue, paymentSummaryDetail.PaymentDurationTypeCodeId, paymentSummaryDetail.DiscountCodeUsageToApply, paymentSummaryDetail.PackageStartDate, endDate);
}
nextCycleStartDate = paymentSummaryDetail.PaymentDurationTypeCodeId == anualDurationCodeId?paymentSummaryDetail.PackageStartDate.AddYears(1) : paymentSummaryDetail.PackageStartDate.AddMonths(1);
summaryList.Add(CreateCompanyPaymentSummary(totalDue, nextCycleStartDate, paymentSummaryDetail, paymentSummaryDetail.DiscountCodeUsageToApply, paymentSummaryDetail.PackageStartDate, nextCycleStartDate, (paymentSummaryDetail.PaymentMethodCodeId != null && paymentSummaryDetail.PaymentMethodCodeId == invoiceMethodCodeId), paymentSummaryDetail.PaymentMethodCodeId, paymentSummaryDetail.CompanyPaymentPackage));
}
else
{
//This happens when a user upgrades or daily agent makes repeat payments at the end of the Payment Cycle.
DateTime endDate = existingCompanyPackageSummary.NextPaymentCycleStartingDate;
int dateDifference = 0;
InventoryPaymentPackageDetails currentInventoryPaymentPackageDetails = Utils.GetSystemInventoryPackageDetailByPaymentPackageTypeId(currentCompanyPaymentPackage.InventoryPaymentPackageTypeId);
InventoryPaymentPackageDetails newInventoryPaymentPackageDetails = Utils.GetSystemInventoryPackageDetailByPaymentPackageTypeId(paymentSummaryDetail.InventoryPaymentPackageTypeId);
ProjectPaymentPackageDetails currentProjectPaymentPackageDetails = Utils.GetSystemProjectPackageDetailByPaymentPackageTypeId(currentCompanyPaymentPackage.ProjectPaymentPackageTypeId);
ProjectPaymentPackageDetails newProjectPaymentPackageDetails = Utils.GetSystemProjectPackageDetailByPaymentPackageTypeId(paymentSummaryDetail.ProjectPaymentPackageTypeId);
decimal currentTotalAmount, newTotalAmount;
//Just Get the Amounts from tables
if (currentCompanyPaymentPackage.PaymentDurationCodeId == anualDurationCodeId)
{
currentTotalAmount = currentInventoryPaymentPackageDetails.AnualAmount + currentProjectPaymentPackageDetails.AnualAmount;
newTotalAmount = newInventoryPaymentPackageDetails.AnualAmount + newProjectPaymentPackageDetails.AnualAmount;
}
else
{
currentTotalAmount = currentInventoryPaymentPackageDetails.Amount + currentProjectPaymentPackageDetails.Amount;
newTotalAmount = newInventoryPaymentPackageDetails.Amount + newProjectPaymentPackageDetails.Amount;
}
if (dateToConsider < endDate && paymentSummaryDetail.HasPackageChanged) //this happens only when a user upgrades during the payment cycle
{
dateDifference = (int)(endDate - dateToConsider).TotalDays;
totalDue = GetProrataAmount(paymentSummaryDetail, currentCompanyPaymentPackage, existingCompanyPackageSummary.DiscountCodeUsage, newTotalAmount, currentTotalAmount, endDate, dateDifference);
summaryList.Add(CreateCompanyPaymentSummary(totalDue, endDate, paymentSummaryDetail, paymentSummaryDetail.DiscountCodeUsageToApply, dateToConsider, endDate, (paymentSummaryDetail.PaymentMethodCodeId != null && paymentSummaryDetail.PaymentMethodCodeId == invoiceMethodCodeId), paymentSummaryDetail.PaymentMethodCodeId, paymentSummaryDetail.CompanyPaymentPackage));
}
else
{
//this get executed by a user when changing the package during Agent down or on package virtual end date or during a gap filling execution
// currentCompanyPaymentPackage will always be the existing package.
DateTime startDate, tempNextCycleDate = endDate;
while (tempNextCycleDate <= dateToConsider)
{
if (tempNextCycleDate == dateToConsider && paymentSummaryDetail.IsUserAction)
{
break;
}
//Find the next Package Start Date based on the duration
startDate = tempNextCycleDate;
tempNextCycleDate = currentCompanyPaymentPackage.PaymentDurationCodeId == anualDurationCodeId?tempNextCycleDate.AddYears(1) : tempNextCycleDate.AddMonths(1);
decimal recordTotalAmount = currentTotalAmount;
DiscountCodeUsage discountCodeUsage = null;
//Get the relavent education or Discount
if (currentCompanyPaymentPackage.IsEducationalPackage)
{
recordTotalAmount = recordTotalAmount * (100 - educationalDiscount) / 100;
}
else
{
//Get the DiscountCode Usage for the Day
discountCodeUsage = financeBL.GetDiscountCodeUsageByDate(startDate, currentCompanyPaymentPackage.CompanyId);
if (discountCodeUsage != null)
{
recordTotalAmount = financeBL.GetDiscountedAmount(currentCompanyPaymentPackage.CompanyId, recordTotalAmount, currentCompanyPaymentPackage.PaymentDurationCodeId, discountCodeUsage, startDate, tempNextCycleDate);
}
}
if (paymentSummaryDetail.PaymentMethodCodeId != null)
{ //this will set is monthly agent processed to true for the past records when gap filling if the user has selected the invoice option.
summaryList.Add(CreateCompanyPaymentSummary(recordTotalAmount, tempNextCycleDate, paymentSummaryDetail, discountCodeUsage, startDate, tempNextCycleDate, (paymentSummaryDetail.PaymentMethodCodeId == invoiceMethodCodeId), paymentSummaryDetail.PaymentMethodCodeId, currentCompanyPaymentPackage));
}
else
{
summaryList.Add(CreateCompanyPaymentSummary(recordTotalAmount, tempNextCycleDate, paymentSummaryDetail, discountCodeUsage, startDate, tempNextCycleDate, (currentCompanyPaymentPackage.PaymentMethodCodeId != null && currentCompanyPaymentPackage.PaymentMethodCodeId == invoiceMethodCodeId), currentCompanyPaymentPackage.PaymentMethodCodeId, currentCompanyPaymentPackage));
}
}
if (tempNextCycleDate == dateToConsider && paymentSummaryDetail.IsUserAction) //if the user do any pricing plan change on the same summmnary end date, this will calculate amounts according to the new selections
{
startDate = tempNextCycleDate;
tempNextCycleDate = paymentSummaryDetail.PaymentDurationTypeCodeId == anualDurationCodeId?tempNextCycleDate.AddYears(1) : tempNextCycleDate.AddMonths(1);
decimal recordTotalAmount = newTotalAmount;
if (paymentSummaryDetail.PaymentDurationTypeCodeId == anualDurationCodeId)
{
recordTotalAmount = newInventoryPaymentPackageDetails.AnualAmount + newProjectPaymentPackageDetails.AnualAmount;
}
else
{
recordTotalAmount = newInventoryPaymentPackageDetails.Amount + newProjectPaymentPackageDetails.Amount;
}
//Get the relevant education or Discount
if (paymentSummaryDetail.IsEducationPackage)
{
recordTotalAmount = recordTotalAmount * (100 - educationalDiscount) / 100;
}
else if (paymentSummaryDetail.DiscountCodeUsageToApply != null)
{
recordTotalAmount = financeBL.GetDiscountedAmount(paymentSummaryDetail.CompanyId, recordTotalAmount, paymentSummaryDetail.PaymentDurationTypeCodeId, paymentSummaryDetail.DiscountCodeUsageToApply, startDate, tempNextCycleDate);
}
summaryList.Add(CreateCompanyPaymentSummary(recordTotalAmount, tempNextCycleDate, paymentSummaryDetail, paymentSummaryDetail.DiscountCodeUsageToApply, startDate, tempNextCycleDate, paymentSummaryDetail.PaymentMethodCodeId != null && paymentSummaryDetail.PaymentMethodCodeId == invoiceMethodCodeId, paymentSummaryDetail.PaymentMethodCodeId, paymentSummaryDetail.CompanyPaymentPackage));
}
if (paymentSummaryDetail.HasPackageChanged && dateToConsider > endDate) // user upgrade after the yearly cycle (Calculcate Pro rata)
{
dateDifference = (int)(tempNextCycleDate - dateToConsider).TotalDays;
totalDue = GetProrataAmount(paymentSummaryDetail, currentCompanyPaymentPackage, summaryList.Count() > 0 ? summaryList.Last().DiscountCodeUsage : null, newTotalAmount, currentTotalAmount, tempNextCycleDate, dateDifference);
summaryList.Add(CreateCompanyPaymentSummary(totalDue, tempNextCycleDate, paymentSummaryDetail, paymentSummaryDetail.DiscountCodeUsageToApply, dateToConsider, tempNextCycleDate, paymentSummaryDetail.PaymentMethodCodeId != null && paymentSummaryDetail.PaymentMethodCodeId == invoiceMethodCodeId, paymentSummaryDetail.PaymentMethodCodeId, paymentSummaryDetail.CompanyPaymentPackage));
}
}
}
return(summaryList);
}
/// <summary>
/// This is to be called by monthly agent and manual payment.
/// </summary>
public static bool ProcessInvoicesAndPayments(int companyId, DateTime dateToConsider, bool shouldCreateInvoices, int userId)
{
using (StageBitzDB dataContext = new StageBitzDB())
{
FinanceSupport.InitializePaymentSettings();
bool isPaymentSuccess = false;
bool isManualPayment = (companyId == 0) ? false : true;
List <Invoice> invoiceList = new List <Invoice>();
if (shouldCreateInvoices)
{
List <CompanyPaymentSummary> unProcessedPaymentSummaries = GetUnProcessedCompanyPaymentSummaries(0, dataContext, dateToConsider);
//Only consider companies which has payment packages
List <Data.Company> companies = (from c in dataContext.Companies
join cpp in dataContext.CompanyPaymentPackages on c.CompanyId equals cpp.CompanyId
select c).Distinct().ToList();
if (unProcessedPaymentSummaries.Count > 0)
{
CompanyBL companyBL = new CompanyBL(dataContext);
foreach (Data.Company company in companies)
{
try
{
List <CompanyPaymentSummary> unProcessedCompanyPaymentSummaries = unProcessedCompanyPaymentSummaries = unProcessedPaymentSummaries.Where(upcs => upcs.CompanyId == company.CompanyId).OrderBy(ups => ups.CompanyPaymentSummaryId).ToList();
//*******Consider payment summaries for the company*********
if (unProcessedCompanyPaymentSummaries != null && unProcessedCompanyPaymentSummaries.Count() > 0)
{
if (!companyBL.IsFreeTrialCompany(company.CompanyId, dateToConsider))
{
decimal totalAmount = unProcessedCompanyPaymentSummaries.Sum(ups => ups.Amount);
DateTime fromDate = unProcessedCompanyPaymentSummaries.First().FromDate;
DateTime toDate = unProcessedCompanyPaymentSummaries.Last().ToDate;
Invoice invoice = null;
if (totalAmount > 0) //generate the invoice only if there is a due amount to pay
{
invoice = FinanceSupport.CreateInvoice(company.CompanyId, "Company", "PACKAGEFEE", string.Format("Payment for Company {0}", company.CompanyName), decimal.Round(totalAmount, 2), fromDate, toDate, dataContext);
}
foreach (CompanyPaymentSummary companyPackagePaymentSummary in unProcessedCompanyPaymentSummaries)
{
companyPackagePaymentSummary.IsMonthlyAgentProcessed = true;
if (invoice != null)
{
companyPackagePaymentSummary.Invoice = invoice;
}
companyPackagePaymentSummary.LastUpdatedDate = Utils.Today;
companyPackagePaymentSummary.LastUpdatedBy = 0;
}
}
}
}
catch (Exception ex)
{
AgentErrorLog.WriteToErrorLog("Failed to create Invoice for projectId" + company.CompanyId);
AgentErrorLog.HandleException(ex);
isPaymentSuccess = false;
}
}
//Complete upto now.
dataContext.SaveChanges();
}
//Get all the Unprocessed Invoices to send to the payment gateway.
invoiceList = FinanceSupport.GetUnProcessedInvoicesByRelatedTable("Company", companyId, "PACKAGEFEE", dataContext);
}
else
{
int companyStatusCodeID = 0;
if (!isManualPayment)
{
//Not Manual means, Payment Retry.
companyStatusCodeID = Utils.GetCodeByValue("CompanyStatus", "GRACEPERIOD").CodeId;
}
//Get all the Unprocessed Invoices to send to the payment gateway.
//For Grace period payment Retry process projectId is 0.
invoiceList = FinanceSupport.GetPaymentFailedInvoices("PACKAGEFEE", companyStatusCodeID, companyId, "Company", dataContext);
}
//Because we need Payment Log records before process Invoices.
foreach (Invoice invoice in invoiceList)
{
FinanceSupport.CreatePaymentLog(invoice.InvoiceID, dataContext);
}
dataContext.SaveChanges();
//Get distinct company Ids within the unprocessed invoice list
var companyIds = invoiceList.Select(inv => inv.RelatedID).Distinct();
foreach (int distinctCompanyId in companyIds)
{
isPaymentSuccess = ProcessInvoicesByCompany(invoiceList, distinctCompanyId, isManualPayment, dataContext);
if (isPaymentSuccess)
{
CompanyBL companyBL = new CompanyBL(dataContext);
companyBL.ActivateUnProcessedSummaries(distinctCompanyId, userId);
}
}
dataContext.SaveChanges();
//For the Monthly Agent Runner the return value is not important but for the manual payment.
return(isPaymentSuccess);
}
}
