public static bool ArchiveCustomer(int CorporateReminderId, int customerId)
{
try
{
var api = Exigo.WebService();
var response = api.CreateCustomerExtended(new CreateCustomerExtendedRequest
{
CustomerID = customerId,
ExtendedGroupID = (int)CustomerExtendedGroup.CorporateReminder,
Field1 = CorporateReminderId.ToString()
});
return(true);
}
catch (Exception e)
{
return(false);
}
}
public Event GetEventDetailsService(int eventId, bool ApiCall = false)
{
if (ApiCall)
{
return(ApiGetEventDetails(eventId));
}
//getting event details for selected event
Event EventDetails = new Event();
using (var Context = Exigo.Sql())
{
Context.Open();
string sqlProcedure = string.Format("GetEventDetails {0}", eventId);
EventDetails = Context.Query <Event>(sqlProcedure).FirstOrDefault();
Context.Close();
}
return(EventDetails);
}
public ActionResult FeesOrdersList(int page, DateTime?StartDate, DateTime?EndDate, int?OrderID)
{
SetCommonViewBagData();
var model = Exigo.GetCustomerOrders(new GetCustomerOrdersRequest
{
CustomerID = Identity.Current.CustomerID,
Page = page,
RowCount = RowCount,
OrderID = OrderID, //20161228 80967 DV.
StartDate = StartDate, //20161222 80967 DV. Client requested ability to work with date range.
EndDate = EndDate, //20161222 80967 DV. Client requested ability to work with date range.
IncludeOrderDetails = true,
ShowOnlyFeesAndServicesOrders = true //20161222 80967 DV. Use this to only show orders that contain ItemID 58 or 627
}); //.Where(c => !c.Other11.IsNullOrEmpty()).ToList(); //20121222 80967 DV. Per client remove this filter entirely. If we bring it back move it inside the GetCustomerOrders method since it was not working correctly anyway
return(View("OrderList", model));
}
List <WebCategory> IProductService.GetDynamicCategories(int ParentCategoryID)
{
//var categories = Exigo.OData().WebCategories.Where(i => i.ParentID == ParentCategoryID).OrderBy(i => i.SortOrder);
List <Common.Api.ExigoOData.WebCategory> categories = null;
using (var Context = Exigo.Sql())
{
Context.Open();
string sqlProcedure = string.Format("GetWebCategories");
categories = Context.Query <Common.Api.ExigoOData.WebCategory>(sqlProcedure).Where(i => i.ParentID == ParentCategoryID).OrderBy(i => i.SortOrder).ToList();
Context.Close();
}
return(categories.Select(category => new WebCategory
{
Id = category.WebCategoryID,
Name = category.WebCategoryDescription,
}).ToList());
}
public ActionResult ReturnedOrdersList(int page)
{
SetCommonViewBagData();
var model = Exigo.GetCustomerOrders(new GetCustomerOrdersRequest
{
CustomerID = Identity.Current.CustomerID,
Page = page,
RowCount = RowCount,
OrderTypes = new int[] {
OrderTypes.ReturnOrder
},
IncludeOrderDetails = true
}).Where(c => c.Other11.IsNullOrEmpty()).ToList();
return(View("OrderList", model));
}
private int UplineDirector(int RankID, int CustomerID)
{
int DirestorId = 2;
try
{
using (var context = Exigo.Sql())
{
string sqlProcedure = string.Format("UplineLeader {0},{1}", RankID, CustomerID);
UplineDirectors Director = context.Query <UplineDirectors>(sqlProcedure).FirstOrDefault();
DirestorId = Director.UplineLeader;
}
}
catch (Exception)
{
}
return(DirestorId);
}
string IShippingService.GetShippingMethodDescription(int shipMethodId)
{
try
{
var context = Exigo.Sql();
var SqlProcedure = string.Format("GetShippingMethodDescription {0}", shipMethodId);
var shipMethod = context.Query <Common.Api.ExigoOData.ShipMethod>(SqlProcedure).FirstOrDefault();
if (null == shipMethod)
{
return("Call Customer Service");
}
return(shipMethod.ShipMethodDescription);
}
catch
{ return("Call Customer Service"); }
}
public ActionResult Payment()
{
var model = ShoppingViewModelFactory.Create <PaymentMethodsViewModel>(PropertyBag);
model.PaymentMethods = Exigo.GetCustomerPaymentMethods(new GetCustomerPaymentMethodsRequest
{
CustomerID = Identity.Current.CustomerID,
ExcludeIncompleteMethods = true,
ExcludeInvalidMethods = true
});
model.Addresses = Exigo.GetCustomerAddresses(Identity.Current.CustomerID)
.Where(c => c.IsComplete)
.Select(c => c as ShippingAddress);
ViewBag.HasAutoOrderItems = ShoppingCart.Items.Count(c => c.Type == ShoppingCartItemType.AutoOrder) > 0;
return(View("Payment", model));
}
public JsonNetResult UpdateWebsiteAddress(CustomerSite customersite)
{
Exigo.UpdateCustomerSite(new CustomerSite
{
CustomerID = Identity.Current.CustomerID,
Address = customersite.Address
});
var html = customersite.Address.AddressDisplay + "<br />" + customersite.Address.City + ", " + customersite.Address.State + " " + customersite.Address.Zip + ", " + customersite.Address.Country;
return(new JsonNetResult(new
{
success = true,
action = "UpdateWebsiteAddress",
html = html
}));
}
public int AuthenticateCustomer(string loginname, string password)
{
var customer = (from c in Exigo.OData().CreateQuery <Common.Api.ExigoOData.Customer>("AuthenticateLogin")
.AddQueryOption("loginName", "'" + loginname + "'")
.AddQueryOption("password", "'" + password + "'")
select new Common.Api.ExigoOData.Customer {
CustomerID = c.CustomerID
}).FirstOrDefault();
if (customer == null)
{
return(0);
}
else
{
return(customer.CustomerID);
}
}
public static List <PayableTypesList> PayableTypes()
{
List <PayableTypesList> PayableTypes = new List <PayableTypesList>();
try
{
using (var context = Exigo.Sql())
{
var sql = @"SELECT PayableTypeID as PayableType,PayableTypeDescription FROM PayableTypes";
PayableTypes = context.Query <PayableTypesList>(sql).ToList();
}
}
catch (Exception)
{
return(PayableTypes);
}
return(PayableTypes);
}
public JsonNetResult UpdateWebsiteName(CustomerSite customersite)
{
Exigo.UpdateCustomerSite(new CustomerSite
{
CustomerID = Identity.Current.CustomerID,
FirstName = customersite.FirstName,
LastName = customersite.LastName
});
var html = string.Format("{0} {1}", customersite.FirstName, customersite.LastName);
return(new JsonNetResult(new
{
success = true,
action = "UpdateWebsiteName",
html = html
}));
}
public static List <PriceTypesList> PriceTypesList()
{
List <PriceTypesList> PriceTypesList = new List <PriceTypesList>();
try
{
using (var context = Exigo.Sql())
{
var sql = @"SELECT PriceTypeID,PriceTypeDescription FROM PriceTypes";
PriceTypesList = context.Query <PriceTypesList>(sql).ToList();
}
}
catch (Exception)
{
return(PriceTypesList);
}
return(PriceTypesList);
}
public JsonNetResult UpdatePassword(string password)
{
Exigo.WebService().UpdateCustomer(new UpdateCustomerRequest
{
CustomerID = Identity.Current.CustomerID,
LoginPassword = password
});
var html = "********";
return(new JsonNetResult(new
{
success = true,
action = "UpdatePassword",
message = "Your password has been updated",
html = html
}));
}
public JsonNetResult UpdateName(string firstname, string lastname)
{
Exigo.WebService().UpdateCustomer(new UpdateCustomerRequest
{
CustomerID = Identity.Current.CustomerID,
FirstName = firstname,
LastName = lastname
});
var html = string.Format("{0} {1}, {3}# {2}", firstname, lastname, Identity.Current.CustomerID, Resources.Common.ID);
return(new JsonNetResult(new
{
success = true,
action = "UpdateName",
html = html
}));
}
public JsonNetResult SetAvatarFromFile(HttpPostedFileBase file)
{
// Validate that the file is valid
var isValidImage = (file != null && file.ContentLength > 0 && AllowableImageFormats.Contains(file.ContentType.ToLower()));
if (isValidImage)
{
// Save the image
var bytes = GlobalUtilities.GetBytesFromStream(file.InputStream);
Exigo.Images().SaveUncroppedCustomerAvatar(Identity.Current.CustomerID, bytes);
}
return(new JsonNetResult(new
{
success = isValidImage,
length = file.ContentLength
}));
}
public static List <CurrenciesList> CurrenciesList()
{
List <CurrenciesList> CurrenciesList = new List <CurrenciesList>();
try
{
using (var context = Exigo.Sql())
{
var sql = @"SELECT CurrencyCode,CurrencyDescription,CurrencySymbol FROM Currencies";
CurrenciesList = context.Query <CurrenciesList>(sql).ToList();
}
}
catch (Exception)
{
return(CurrenciesList);
}
return(CurrenciesList);
}
public ActionResult CommissionDetail(int runid, int periodid)
{
var model = new CommissionDetailViewModel();
// View Requests
if (!Request.IsAjaxRequest())
{
model.CommissionPeriods = Exigo.GetCommissionPeriodList(Identity.Current.CustomerID, true);
return(View("CommissionDetail", model));
}
// AJAX requests
else
{
// Real-time commissions
if (runid == 0)
{
model.Commissions = Exigo.GetCustomerRealTimeCommissions(new GetCustomerRealTimeCommissionsRequest
{
CustomerID = Identity.Current.CustomerID,
GetPeriodVolumes = true
});
// Check Period ID
if (periodid > 0)
{
model.PeriodID = periodid;
model.Commissions = model.Commissions.Where(c => c.Period.PeriodID == periodid);
}
return(PartialView("_RealTimeCommissionDetail", model));
}
// Historical Commissions
else
{
model.Commissions = new List <ICommission>()
{
Exigo.GetCustomerHistoricalCommission(Identity.Current.CustomerID, runid)
};
return(PartialView("_HistoricalCommissionDetail", model));
}
}
}
public ActionResult CreateResource(ResourceListViewModel res, HttpPostedFileBase UploadFile)
{
var context = Exigo.ODataResources();
int CategoryID = 0;
if (!string.IsNullOrEmpty(res.SelectedCategoryID))
{
CategoryID = Convert.ToInt32(res.SelectedCategoryID);
}
var resource = new ResourceContext.ResourceManager();
resource.Description = res.Description;
resource.CreatedDate = DateTime.Now;
resource.ResourceCategoryID = CategoryID;
//2015-09-10
//Ivan S.
//66
//Ben wanted me to save the ResourceType, originally the Title was saving the type from a fixed list of File types
//I now get the description from the resource types and save the right resource typeID
resource.Title = context.ResourceTypes.Where(t => t.ResourceTypeID == res.ResourceTypeID).FirstOrDefault().ResourceTypeDescription;
resource.ResourceTypeID = (Int32)res.ResourceTypeID; //It was missing
//2015-09-08
//Ivan S.
//66
//Sets the initial order for the new resource to the maximum number for that category
var lastResource = context.ResourceManagement.Where(r => r.ResourceCategoryID == resource.ResourceCategoryID).OrderByDescending(r => r.ResourceOrder).FirstOrDefault();
int? lastResourceOrder = InitialOrderValue - 1;
if (lastResource != null)
lastResourceOrder = lastResource.ResourceOrder;
resource.ResourceOrder = ++lastResourceOrder;
resource.Url = res.Url;
resource.UploadedThumbnailPath = res.UploadedThumbnailPath;
context.AddToResourceManagement(resource);
context.SaveChanges();
return RedirectToAction("ManageResources");
}
public ActionResult Subscriptions()
{
var model = new SubscriptionsViewModel();
// Get the calendars we are subscribed to
var calendars = Exigo.GetCustomerCalendarSubscriptions(Identity.Current.CustomerID);
// Get the customers for each of the calendar subscriptions
var customerIDs = calendars.Select(c => c.CustomerID).Distinct().ToList();
var apiCustomers = Exigo.OData().Customers
.Where(customerIDs.ToOrExpression <Common.Api.ExigoOData.Customer, int>("CustomerID"))
.Select(c => new Common.Api.ExigoOData.Customer()
{
CustomerID = c.CustomerID,
FirstName = c.FirstName,
LastName = c.LastName
})
.ToList();
// Pair the data together to create our models
var customers = new List <CalendarSubscriptionCustomer>();
foreach (var apiCustomer in apiCustomers)
{
// Create the special customer first
var customer = new CalendarSubscriptionCustomer()
{
CustomerID = apiCustomer.CustomerID,
FirstName = apiCustomer.FirstName,
LastName = apiCustomer.LastName
};
// Add their calendars
customer.Calendars = calendars.Where(c => c.CustomerID == customer.CustomerID).ToList();
// Add our model to the collection
model.CalendarSubscriptionCustomers.Add(customer);
}
return(View(model));
}
public static List <CustomerTypeDescriptionID> GetCustomerTypeDescriptionID()
{
List <CustomerTypeDescriptionID> list = new List <CustomerTypeDescriptionID>();
try
{
using (var context = Exigo.Sql())
{
var SqlProcedure = string.Format("GetCustomerTypes");
list = context.Query <CustomerTypeDescriptionID>(SqlProcedure).ToList();
return(list);
}
}
catch (Exception)
{
return(list);
}
}
public ActionResult UseBankAccount(BankAccount newBankAccount, bool billingSameAsShipping = false)
{
if (billingSameAsShipping)
{
var address = PropertyBag.ShippingAddress;
newBankAccount.BillingAddress = new Address
{
Address1 = address.Address1,
Address2 = address.Address2,
City = address.City,
State = address.State,
Zip = address.Zip,
Country = address.Country
};
}
// Verify that the card is valid
if (!newBankAccount.IsValid)
{
return(new JsonNetResult(new
{
success = false
}));
}
else
{
// Save the bank account to the customer's account if applicable
var paymentMethodsOnFile = Exigo.GetCustomerPaymentMethods(new GetCustomerPaymentMethodsRequest
{
CustomerID = Identity.Current.CustomerID,
ExcludeIncompleteMethods = true,
ExcludeInvalidMethods = true,
}).Where(c => c is BankAccount).Select(c => c as BankAccount);
if (paymentMethodsOnFile.FirstOrDefault() == null)
{
Exigo.SetCustomerBankAccount(Identity.Current.CustomerID, newBankAccount);
}
}
return(UsePaymentMethod(newBankAccount));
}
public List <CharityModel> GetCharityName(int eventId)
{
List <CharityModel> CharityList = new List <CharityModel>();
try
{
using (var context = Exigo.Sql())
{
var SqlProcedure = string.Format("GetCharityName {0}", eventId);
CharityList = context.Query <CharityModel>(SqlProcedure).ToList();
}
}
catch (Exception ex)
{
return(CharityList);
}
return(CharityList);
}
public JsonNetResult UpdateEmailAddress(Customer customer)
{
Exigo.WebService().UpdateCustomer(new UpdateCustomerRequest
{
CustomerID = Identity.Current.CustomerID,
Email = customer.Email
});
Exigo.SendEmailVerification(Identity.Current.CustomerID, customer.Email);
var html = string.Format("{0}", customer.Email);
return(new JsonNetResult(new
{
success = true,
action = "UpdateEmailAddress",
html = html
}));
}
public ActionResult VolumeList(KendoGridRequest request = null)
{
if (Request.HttpMethod.ToUpper() == "GET")
{
return(View());
}
// Establish the query
using (var context = new KendoGridDataContext(Exigo.Sql()))
{
return(context.Query(request, @"
SELECT
pv.PeriodID,
p.StartDate,
p.EndDate,
p.PeriodDescription,
pv.PaidRankID,
r.RankDescription,
Team1TGBV = pv.Volume55,
Team2TGBV = pv.Volume56,
Team3TGBV = pv.Volume57,
Team4TGBV = pv.Volume58,
Team5TGBV = pv.Volume59,
Team6TGBV = pv.Volume91
FROM
PeriodVolumes pv
inner join Periods p
on p.PeriodID = pv.PeriodID
and p.PeriodTypeID = pv.PeriodTypeID
left join Ranks r
on r.RankID = pv.PaidRankID
WHERE
p.StartDate <= GetDate() + 1
AND pv.PeriodTypeID = @periodtypeid
and pv.CustomerID = @id
", new
{
id = Identity.Current.CustomerID,
periodtypeid = PeriodTypes.Default
}).Tokenize("CustomerID"));
}
}
public ActionResult VolumesList(int id, KendoGridRequest request = null)
{
if (Request.HttpMethod.ToUpper() == "GET")
{
return(PartialView("Partials/VolumesList"));
}
using (var context = new KendoGridDataContext(Exigo.Sql()))
{
return(context.Query(request, @"
SELECT
p.PeriodID
, p.StartDate
, p.EndDate
, p.PeriodDescription
, r.RankDescription
, pv.PaidRankID
, pv.Volume1
, pv.Volume2
, pv.Volume3
, pv.Volume4
, pv.Volume5
FROM Customers c
INNER JOIN Periods p
ON p.EndDate > c.CreatedDate
AND p.PeriodTypeID = @periodtype
AND p.StartDate <= GETDATE()
INNER JOIN PeriodVolumes pv
ON pv.PeriodID = p.PeriodID
AND pv.PeriodTypeID = p.PeriodTypeID
AND pv.CustomerID = c.CustomerID
LEFT JOIN Ranks r
ON r.RankID = pv.PaidRankID
WHERE c.CustomerID = @customerid
", new
{
customerid = id,
periodtype = PeriodTypes.Default
}).Tokenize("CustomerID"));
}
}
/// <summary>
/// This method returns the list of item codes which the customer has already purchased.
/// </summary>
protected IList <string> PurchasedItemCodes()
{
List <string> itemCodes = new List <string>();
var response = Exigo.GetCustomerExtendedDetails(CustomerId, (int)CustomerExtendedGroup.NewProductsLaunchPurchase);
foreach (var row in response)
{
var sku = row.Field1;
// There shouldn't be any duplicates but it is better to perform the check just in case versus having the application crash...
if (!itemCodes.Contains(sku))
{
itemCodes.Add(sku);
}
}
return(itemCodes);
}
/// <summary>
/// This method calculates the points account for this reward.
/// </summary>
public RewardsAccount CalculatePointsAccount(IList <Product> productsInShoppingCart)
{
if (IsRewardPointsAccount)
{
var pointAccountResponse = Exigo.GetCustomerPointAccount(CustomerId, RewardPointsAccountId.Value);
var creditsRemaining = (null != pointAccountResponse ? pointAccountResponse.Balance : 0M);
var productWithDiscount = GetRewardProducts(productsInShoppingCart);
var account = new RewardsAccount {
PointAccountID = RewardPointsAccountId.Value, Balance = creditsRemaining, AppliedAmount = productWithDiscount.Count()
};
return(account);
}
return(null);
}
public static string GetProducImageUrl(string ItemCode)
{
List <string> url = new List <string>();
try
{
using (var context = Exigo.Sql())
{
var SqlProcedure = string.Format("GetProducImageUrl '{0}'", ItemCode);
url = context.Query <string>(SqlProcedure).ToList();
return(url.First().ToString());
}
}
catch (Exception)
{
return("");
}
}
public ActionResult ProductList()
{
var model = new EnrollmentProductListViewModel();
model.OrderItems = Exigo.GetItems(new ExigoService.GetItemsRequest
{
Configuration = OrderConfiguration
}).ToList();
var autoOrderItems = Exigo.GetItems(new ExigoService.GetItemsRequest
{
Configuration = AutoOrderConfiguration
}).ToList();
autoOrderItems.ForEach(c => c.Type = ShoppingCartItemType.AutoOrder);
model.AutoOrderItems = autoOrderItems;
return(View(model));
}
public User(Exigo.OData.CustomerType custType, int CustomerID)
{
if (DoesTheAdminUserHaveSuperUserRights(CustomerID))
{
//Switch case to determine what wealth club benefits (if any) should appear)
//Switch case to determine what sub level (if any) should appear)
switch (SuperUserPermissionLevel_1) // Property ID5
{
case "Wealth":
case "Gold": SetGoldLevelPermissions(); break;
case "Silver": SetSilverLevelPermissions(); break;
case "Bronze": SetBronzeLevelPermissions(); break; // Reference ID-4 // Override ID-3
case "SuperUserPermissionLevel_1": SetSuperUserLevel_1_Permissions(); break; // Case ID2 // Reference ID-5
case "SuperUserPermissionLevel_2": SetSuperUserLevel_2_Permissions(); break;
default: SetWealthClubAllFalse(); break;
}
}
else
SetWealthClubAllFalse();
//Switch case to determine if IBD or Customer or Administrator links should appear
switch (custType.CustomerTypeDescription)
{
case "IBD": SetIBDPermissions(); break; // Case ID-1 // Reference ID-1
case "Retail Customer": SetCustomerPermissions(); break; // Case ID-2 // Reference ID2.1
case "Wholesale Customer": SetCustomerPermissions(); break; // Reference ID2.1
case "Preferred Customer": SetCustomerPermissions(); break; // Reference ID2.1
case "Administrator": SetPermissionsForCustomerTypeAdministratorWithNoSuperUserAccess(); break; // Case ID-3 // Reference ID-3
default: break;
}
}
