public static bool CreateOffer(OffersModel myOffer)
{
myOffer.offeredById = HttpContext.Current.Session["UserId"].ToString();
OffersModel offerModel = new OffersModel();
return(offerModel.CreateOffer(myOffer));
}
public ActionResult _Index(int?page, ProdSearch prodSearch)
{
int TotalCount = 0;
var pageSize = 6;
var pageNumber = page ?? 1;
int CurrentPage = pageNumber;
var endPage = CurrentPage + 4;
int PagesToShow = 10;
ViewBag.PageSize = pageSize;
OffersModel model = new OffersModel();
var ProductModelList = Services.ProductService.GetProduct(prodSearch, page, out TotalCount);
ViewBag.TotalCount = TotalCount;
model.ProductList = ProductModelList;
var result = Helper.CommonFunction.GetPages(TotalCount, pageSize, CurrentPage, PagesToShow);
int totalPages = (TotalCount / pageSize) + (TotalCount % pageSize == 0 ? 0 : 1);
ViewBag.result = result;
ViewBag.totalPages = totalPages;
ViewBag.CurrentPage = CurrentPage;
var pageCount = result.Count();
ViewBag.pageCount = pageCount;
ViewBag.endPage = endPage;
return(View(model));
}
public async Task <PartialViewResult> GetOffersAsync(string customerId)
{
List <Offer> offers;
OffersModel offersModel;
try
{
offers = await Provider.PartnerOperations.GetOffersAsync().ConfigureAwait(false);
offersModel = new OffersModel
{
AvailableOffers = (from offer in offers
where offer.IsAvailableForPurchase
select new OfferModel()
{
Billing = offer.Billing,
Description = offer.Description,
Id = offer.Id,
IsAddOn = offer.IsAddOn,
IsAvailableForPurchase = offer.IsAvailableForPurchase,
MaximumQuantity = offer.MaximumQuantity,
MinimumQuantity = offer.MinimumQuantity,
Name = offer.Name,
PrerequisiteOffers = offer.PrerequisiteOffers
}).ToList(),
CustomerId = customerId
};
return(PartialView("Offers", offersModel));
}
finally
{
offers = null;
}
}
public static List <OffersModel> GetMyOffers(string userId, int startValue, int noOfRows)
{
userId = HttpContext.Current.Session["UserId"].ToString();
OffersModel offersModel = new OffersModel();
return(offersModel.MyOffers(userId, startValue, noOfRows));
}
public async Task <PartialViewResult> Offers(string customerId)
{
OffersModel offersModel = new OffersModel()
{
AvailableOffers = await GetOfferModelsAsync(),
CustomerId = customerId
};
return(PartialView(offersModel));
}
public ActionResult HomePageOffersSlideBlock(int count, bool partialView = false, string categoryId = null)
{
var categories = _categoryService.GetAllCategories();
var model = new OffersModel();
model.Categories = new List <OffersCategoryModel>();
foreach (var category in categories)
{
var categoryModel = new OffersCategoryModel();
categoryModel.CateogyTitle = category.Name;
categoryModel.CategoryId = category.Id;
model.Categories.Add(categoryModel);
}
var products = _productService.SearchProductsWithAttributes(0, ProductSortingEnum.CreatedOn, 0, count, 0, 0, 0, 0, 0, null, null);
if (!string.IsNullOrEmpty(categoryId))
{
products = _productService.SearchProductsWithAttributes(0, ProductSortingEnum.CreatedOn, 0, count, 0, Convert.ToInt32(categoryId), 0, 0, 0, null, null);
}
model.Products = new List <OffersProductModel>();
if (products.Any())
{
model.Products = new List <OffersProductModel>();
foreach (var i in products)
{
var productModel = new OffersProductModel()
{
Id = i.Id,
Rating = Math.Round(i.Rating ?? 0),
BankRating = Math.Round(i.Customer.Rating ?? 0),
Name = i.Name,
ProductAttributeValue = i.ProductAttributes.FirstOrDefault(x => x.CategoryProductAttribute.ProductBoxAttribute),
MetaTitle = i.MetaTitle,
PictureThumbnailUrl =
_pictureService.GetPictureUrl(i.Customer.ProviderLogoId.GetValueOrDefault(), 100, false),
ShortDescription = i.ShortDescription,
FullDescription = i.FullDescription,
SeName = i.GetSeName(),
OrderingLink = i.OrderLink,
};
model.Products.Add(productModel);
}
}
if (partialView)
{
return(PartialView("OffersSlideBox", model));
}
else
{
return(View(model));
}
}
// GET: Offers
public ActionResult Index()
{
OffersModel offers = new OffersModel();
offers.HealthProducts = new List <Product>();
offers.PharmacyProducts = new List <PharmacyProduct>();
offers.HealthProducts = db.Products.Include(p => p.SubClassification).ToList();
offers.PharmacyProducts = db.PharmacyProducts.Include(p => p.PharmacySubCategory).ToList();
return(PartialView(offers));
}
public int Edit(int id, OffersModel ObjOffersModel)
{
try
{
if (id > 0)
{
if (ObjOffersModel != null)
{
Offer ObjOffers = DBContext.Offers.Where(a => a.Offer_ID == id).FirstOrDefault();
if (ObjOffers != null)
{
//OffersModel Edit Properties mapping here.
//ObjOffers.Profile_Name = ObjOffersModel.Profile_Name;
//ObjOffers.Password = ObjOffersModel.Password;
//ObjOffers.First_Name = ObjOffersModel.First_Name;
//ObjOffers.Middle_Name = ObjOffersModel.Middle_Name;
//ObjOffers.Last_Name = ObjOffersModel.Last_Name;
//ObjOffers.Email_Address = ObjOffersModel.Email_Address;
//ObjOffers.Contact_Number = ObjOffersModel.Contact_Number;
//ObjOffers.Cell_Number = ObjOffersModel.Cell_Number;
//ObjOffers.Location_ID = ObjOffersModel.Location_ID;
//ObjOffers.PickUp_Address = ObjOffersModel.PickUp_Address;
//ObjOffers.Drop_Address = ObjOffersModel.Drop_Address;
//ObjOffers.QR_Code = ObjOffersModel.QR_Code;
//ObjOffers.Rating = ObjOffersModel.Rating;
//ObjOffers.Created_DateTime = ObjOffersModel.Created_DateTime;
//ObjOffers.Created_By = ObjOffersModel.Created_By;
//ObjOffers.Modified_DateTime = ObjOffersModel.Modified_DateTime;
//ObjOffers.Modified_By = ObjOffersModel.Modified_By;
//ObjOffers.Deleted = ObjOffersModel.Deleted;
DBContext.SubmitChanges();
return(ObjOffers.Offer_ID);
}
else
{
return(WebApiResponse.NoRecordFound);
}
}
else
{
return(WebApiResponse.InputObjectIsNull);
}
}
else
{
return(WebApiResponse.InputIdInvalid);
}
}
catch (Exception ex)
{
throw ex;
}
}
public OffersModelList UpgradeOfferDetails(string userID, string customerType = "")
{
int activetype = 1;
if (customerType == "inactive")
{
activetype = 0;
}
OffersModelList _OffersModelList = new OffersModelList();
_OffersModelList.OffersList = new List <OffersModel>();
string Sqlconnectionstring = ConfigurationManager.ConnectionStrings["HDCConnection"].ConnectionString;
try
{
SqlConnection sqlcon = new SqlConnection(Sqlconnectionstring);
sqlcon.Open();
SqlCommand cmd = new SqlCommand(@"SELECT
A.CustUsageID AS CustUsageID
,[Cust_FirstName]
,[Cust_LastName]
,[DataImage]
,TariffDescription
,TariffImage
,TariffCost
,serviceType
FROM [dbo].Tbl_CustUsage A inner join
[dbo].Tbl_Tariffmaster B On A.TariffID = B.TariffID
Where A.userID = '" + userID + "' and A.isactive='" + activetype + "'", sqlcon);
SqlDataReader SqlDR = cmd.ExecuteReader();
while (SqlDR.Read())
{
OffersModel _OffersModel = new OffersModel();
_OffersModel.ProductID = SqlDR["CustUsageID"].ToString();
_OffersModel.Description = SqlDR["TariffDescription"].ToString();
_OffersModel.Cost = SqlDR["TariffCost"].ToString();
_OffersModel.Image = SqlDR["TariffImage"].ToString();
_OffersModelList.ServiceType = SqlDR["serviceType"].ToString();
_OffersModelList.OffersList.Add(_OffersModel);
}
sqlcon.Close();
}
catch (Exception ex)
{
}
return(_OffersModelList);
}
public OffersModel getOfferDetails()
{
OffersModel obj1 = new OffersModel();
List <int> lst1 = new List <int>();
List <string> lst2 = new List <string>();
List <string> lst3 = new List <string>();
lst1.Add(10);
lst2.Add("Test1");
lst3.Add("Test2");
obj1.Price = lst1;
obj1.Name = lst2;
obj1.OfferDetails = lst2;
return(obj1);
}
public ActionResult Edit(int id, OffersModel ObjInputOffersModel)
{
//Customized try catch block by Imran Khan. CodeSnippet
try
{
string JsonString = string.Empty;
string ApiURL = OTS.GlobalSettings.WebAPIURL + this.GetType().Name.Replace("Controller", string.Empty) + "/" + System.Reflection.MethodBase.GetCurrentMethod().Name + "/" + id;
int UpdatedOffersId = 0;
UpdatedOffersId = (int)iWebServiceConsumer.ConsumeJsonWebService(ApiURL, ObjInputOffersModel, UpdatedOffersId, OTS.GlobalSettings.WebAPITimeout, out JsonString);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewBag.Error = ex.ToString();
return(View("Error"));
}
}
public ActionResult Offers()
{
var lngId = 1;
if (Session["lngId"] != null)
{
lngId = (int)Session["lngId"];
}
ViewBag.Link = 2;
OffersModel model = new OffersModel();
model.ContentLeft = Db.Labels.Where(m => m.ViewId == "Offers" && m.ElementId == "ContentLeft" && m.LanguageId == lngId).FirstOrDefault().Text;
model.ContentRight = Db.Labels.Where(m => m.ViewId == "Offers" && m.ElementId == "ContentRight" && m.LanguageId == lngId).FirstOrDefault().Text;
return(View(model));
}
public static string makeRequest(int offerId, OffersModel offerDetails)
{
string resp = "Expired";
if (HttpContext.Current.Session["UserName"] != null)
{
resp = "Success";
}
else
{
HttpContext.Current.Session["OfferId"] = offerId;
HttpContext.Current.Session["OfferCategoryId"] = offerDetails.offerCategoryId;
HttpContext.Current.Session["OfferSubCategoryId"] = offerDetails.offerSubCategoryId;
HttpContext.Current.Session["OfferQuantity"] = offerDetails.offerQuantity;
HttpContext.Current.Session["OfferUnit"] = offerDetails.unitId;
}
return(resp);
}
/// <summary>
/// Gets the offers.
/// </summary>
/// <returns> Offers Model.</returns>
public List <OffersModel> GetOffers()
{
List <OffersModel> offersList = new List <OffersModel>();
var allOfferData = this.offerRepository.GetAll();
foreach (var item in allOfferData)
{
OffersModel offers = new OffersModel();
offers.Id = item.Id;
offers.OfferID = item.OfferId;
offers.OfferName = item.OfferName;
offers.CreateDate = item.CreateDate;
offers.UserID = item.UserId;
offers.OfferGuId = item.OfferGuid;
offersList.Add(offers);
}
return(offersList);
}
public OffersModel GetPaging(int?page, out int TotalCount)
{
var body = "";
// int pageSize = 10;
int pageNumber = (page ?? 1);
var model1 = new OffersModel();
var productList = ServerResponse.Invoke <ServiceResult <List <ProductModel> > >("api/product/getProductPaging?pageNumber=" + page, body, "GET");
TotalCount = productList.TotalCount;
if (productList.data != null)
{
model1.ProductList = productList.data.ToList();
return(model1);
}
else
{
}
return(model1);
}
public OffersModelList GetUserTarrif(string userID)
{
OffersModelList _OffersModelList = new OffersModelList();
OffersModel _OffersModel = new OffersModel();
string Sqlconnectionstring = ConfigurationManager.ConnectionStrings["HDCConnection"].ConnectionString;
try
{
SqlConnection sqlcon = new SqlConnection(Sqlconnectionstring);
sqlcon.Open();
SqlCommand cmd = new SqlCommand(@"SELECT [Cust_FirstName]
,[Cust_LastName]
,[DataImage]
,A.[TariffID]
,B.TariffDescription
,B.TariffImage
,B.TariffCost
,B.serviceType
FROM [dbo].[Tbl_CustUsage] A
inner join [dbo].[tbl_TariffMaster] B On A.TariffID = B.TariffID
Where A.CustomerID = " + userID + "", sqlcon);
SqlDataReader SqlDR = cmd.ExecuteReader();
while (SqlDR.Read())
{
_OffersModel.ProductID = SqlDR["TariffID"].ToString();
_OffersModel.Description = SqlDR["TariffDescription"].ToString();
_OffersModel.Cost = SqlDR["TariffCost"].ToString();
_OffersModel.Image = SqlDR["TariffImage"].ToString();
_OffersModelList.ServiceType = SqlDR["serviceType"].ToString();
_OffersModelList.CustomerType = SqlDR["customerType"].ToString();
_OffersModelList.OffersList.Add(_OffersModel);
}
sqlcon.Close();
}
catch (Exception ex)
{
}
return(_OffersModelList);
}
public int Delete(int id, OffersModel ObjInputOffersModel)
{
try
{
//Just keep ObjInputOffersModel as parameter for Deleted Log.
Offer ObjOffers = DBContext.Offers.Where(a => a.Offer_ID == id).FirstOrDefault();
if (ObjOffers != null)
{
DBContext.Offers.DeleteOnSubmit(ObjOffers);
DBContext.SubmitChanges();
return(ObjOffers.Offer_ID);
}
else
{
return(0);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Index(OffersSearch search, int?page, string name, string hotelName, string description, string dateFrom,
string dateTo, string peopleFrom, string peopleTo, string priceFrom, string priceTo)
{
ViewBag.CurrentSearch = new OffersSearch();
ViewBag.empty = null;
if (search != null)
{
page = 1;
ViewBag.CurrentSearch = search;
}
else
{
ViewBag.CurrentSearch.nameSearch = name;
ViewBag.CurrentSearch.hotelName = hotelName;
ViewBag.CurrentSearch.descriptionSearch = description;
ViewBag.CurrentSearch.dateFrom = dateFrom;
ViewBag.CurrentSearch.dateTo = dateTo;
ViewBag.CurrentSearch.peopleFrom = peopleFrom;
ViewBag.CurrentSearch.peopleTo = peopleTo;
ViewBag.CurrentSearch.priceFrom = priceFrom;
ViewBag.CurrentSearch.priceTo = priceTo;
search = ViewBag.CurrentSearch;
}
int pageSize = 10;
int pageNumber = (page ?? 1);
var user = HttpContext.User.Identity;
bool canEdit = user.Name == "Admin" ? true : false;
bool canBook = user.Name != "" ? true : false;
var offers = _offersSqlExecutor.FilterOffers(search);
OffersModel model = new OffersModel {
Offers = offers.ToPagedList <Offer>(pageNumber, pageSize), CanEdit = canEdit, CanBook = canBook, Search = search
};
return(View(model));
}
public ActionResult searchCoupons(OffersViewModel foSearchRequest)
{
OffersModel loCouponsModel = getCouponsList(foSearchRequest);
return(PartialView("~/Areas/Admin/Views/Coupons/_Coupons.cshtml", loCouponsModel));
}
public static List <IOffers> activeOffersSubCategory(int subCategoryId, int startValue, int noOfRows)
{
OffersModel offers = new OffersModel();
return(offers.ActiveOffersSubCategory(subCategoryId, startValue, noOfRows));
}
public static List <IOffers> getActiveOffers(int categoryId, int startValue, int noOfRows, string searchVal, float userLat, float userLng)
{
OffersModel offersModel = new OffersModel();
return(offersModel.ActiveOffers(categoryId, startValue, noOfRows, searchVal, userLat, userLng));
}
public OffersModel getCouponsList(OffersViewModel foRequest)
{
if (foRequest.inPageSize <= 0)
{
foRequest.inPageSize = 10;
}
if (foRequest.inPageIndex <= 0)
{
foRequest.inPageIndex = 1;
}
if (foRequest.stSortColumn == "")
{
foRequest.stSortColumn = null;
}
if (foRequest.stSearch == "")
{
foRequest.stSearch = null;
}
Func <IQueryable <Offers>, IOrderedQueryable <Offers> > orderingFunc =
query => query.OrderBy(x => x.id);
Expression <Func <Offers, bool> > expression = null;
if (!string.IsNullOrEmpty(foRequest.stSearch))
{
foRequest.stSearch = foRequest.stSearch.Replace("%20", " ");
expression = x => x.OfferCode.ToLower().Contains(foRequest.stSearch.ToLower()) && x.IsDeleted == false;
}
else
{
expression = x => x.IsDeleted == false;
}
if (!string.IsNullOrEmpty(foRequest.stSortColumn))
{
switch (foRequest.stSortColumn)
{
case "ID DESC":
orderingFunc = q => q.OrderByDescending(s => s.id);
break;
case "ID ASC":
orderingFunc = q => q.OrderBy(s => s.id);
break;
case "OfferCode DESC":
orderingFunc = q => q.OrderByDescending(s => s.OfferCode);
break;
case "OfferCode ASC":
orderingFunc = q => q.OrderBy(s => s.OfferCode);
break;
case "OfferDescription DESC":
orderingFunc = q => q.OrderByDescending(s => s.OfferDescription);
break;
case "OfferDescription ASC":
orderingFunc = q => q.OrderBy(s => s.OfferDescription);
break;
case "FlatDiscount DESC":
orderingFunc = q => q.OrderByDescending(s => s.FlatDiscount);
break;
case "FlatDiscount ASC":
orderingFunc = q => q.OrderBy(s => s.FlatDiscount);
break;
case "PercentageDiscount DESC":
orderingFunc = q => q.OrderByDescending(s => s.PercentageDiscount);
break;
case "PercentageDiscount ASC":
orderingFunc = q => q.OrderBy(s => s.PercentageDiscount);
break;
case "ProductId DESC":
orderingFunc = q => q.OrderByDescending(s => s.ProductId);
break;
case "ProductId ASC":
orderingFunc = q => q.OrderBy(s => s.ProductId);
break;
case "CategoryId DESC":
orderingFunc = q => q.OrderByDescending(s => s.CategoryId);
break;
case "CategoryId ASC":
orderingFunc = q => q.OrderBy(s => s.CategoryId);
break;
case "StartDate DESC":
orderingFunc = q => q.OrderByDescending(s => s.StartDate);
break;
case "StartDate ASC":
orderingFunc = q => q.OrderBy(s => s.StartDate);
break;
case "EndDate DESC":
orderingFunc = q => q.OrderByDescending(s => s.EndDate);
break;
case "EndDate ASC":
orderingFunc = q => q.OrderBy(s => s.EndDate);
break;
case "IsActive DESC":
orderingFunc = q => q.OrderByDescending(s => s.IsActive);
break;
case "IsActive ASC":
orderingFunc = q => q.OrderBy(s => s.IsActive);
break;
}
}
(List <Offers>, int)objCoupons = Repository <Offers> .GetEntityListForQuery(expression, orderingFunc, null, foRequest.inPageIndex, foRequest.inPageSize);
OffersModel objCouponViewModel = new OffersModel();
objCouponViewModel.inRecordCount = objCoupons.Item2;
objCouponViewModel.inPageIndex = foRequest.inPageIndex;
objCouponViewModel.Pager = new Pager(objCoupons.Item2, foRequest.inPageIndex);
//#region Category DDl
//var objCategories = Repository<Categories>.GetEntityListForQuery(x => x.IsDeleted == false).Item1.ToList();
//objProductsViewModel.objCategoryList.Add(new SelectListItem { Text = "-- Select --", Value = "0", Selected = true });
//foreach (var Category in objCategories)
//{
// objProductsViewModel.objCategoryList.Add(new SelectListItem { Text = Category.Name, Value = Category.Id.ToString(), Selected = false });
//}
//#endregion
if (objCoupons.Item1.Count > 0)
{
foreach (var coupon in objCoupons.Item1)
{
objCouponViewModel.loOfferList.Add(new OffersViewModel
{
id = coupon.id,
OfferCode = coupon.OfferCode,
OfferDescription = coupon.OfferDescription,
FlatDiscount = coupon.FlatDiscount,
PercentageDiscount = coupon.PercentageDiscount,
ProductId = coupon.ProductId,
ProductName = Repository <Products> .GetEntityListForQuery(x => x.id == coupon.ProductId).Item1.Select(x => x.Name).FirstOrDefault(),
CategoryId = coupon.CategoryId,
StartDate = coupon.StartDate,
EndDate = coupon.EndDate,
CategoryName = Repository <Categories> .GetEntityListForQuery(x => x.Id == coupon.CategoryId).Item1.Select(x => x.Name).FirstOrDefault(),
IsActive = coupon.IsActive
});
}
}
return(objCouponViewModel);
}
public static bool CancelOffer(string offerId)
{
OffersModel offersModel = new OffersModel();
return(offersModel.CancelOffer(offerId));
}
public OffersModelList GetUserProfile(string userID)
{
int activetype = 1;
OffersModelList _OffersModelList = new OffersModelList();
_OffersModelList.OffersList = new List <OffersModel>();
string Sqlconnectionstring = ConfigurationManager.ConnectionStrings["HDCConnection"].ConnectionString;
try
{
SqlConnection sqlcon = new SqlConnection(Sqlconnectionstring);
sqlcon.Open();
SqlCommand cmd = new SqlCommand(@"SELECT [CustUsageID]
,[Cust_FirstName]
,[Cust_LastName]
,[DataImage]
,A.[TariffID]
,B.TariffDescription
,B.TariffImage
,B.TariffCost
,B.serviceType
FROM [dbo].[Tbl_CustUsage] A
inner join [dbo].[tbl_TariffMaster] B On A.TariffID = B.TariffID
Where A.userID = '" + userID + "' and A.isactive='" + activetype + "'", sqlcon);
SqlDataReader SqlDR = cmd.ExecuteReader();
while (SqlDR.Read())
{
OffersModel _OffersModel = new OffersModel();
_OffersModel.ProductID = SqlDR["TariffID"].ToString();
_OffersModel.Description = SqlDR["TariffDescription"].ToString();
_OffersModel.Cost = SqlDR["TariffCost"].ToString();
_OffersModel.Image = SqlDR["TariffImage"].ToString();
_OffersModelList.ServiceType = SqlDR["serviceType"].ToString();
_OffersModelList.OffersList.Add(_OffersModel);
}
SqlDR.Close();
SqlCommand cmd1 = new SqlCommand(@"CREATE TABLE #tmpCust (CustomerID INT,Cust_FirstName nCHAR(10),Cust_LastName nCHAR(10),strStatus VARCHAR(50))
INSERT INTO #tmpCust(CustomerID,Cust_FirstName,Cust_LastName)
SELECT CustomerID,Cust_FirstName,Cust_LastName FROM
(
SELECT [CustomerID] , A.Cust_FirstName,A.Cust_LastName
,SUM(B.TariffCost) AS TariffCost
FROM [dbo].[Tbl_CustUsage] A
inner join [dbo].[tbl_TariffMaster] B On A.TariffID = B.TariffID
group by A.customerID, A.Cust_FirstName,A.Cust_LastName
) A
ORDER BY A.TariffCost DESC
UPDATE TOP (25) PERCENT tmp SET tmp.strStatus = 'Gold'
FROM #tmpCust tmp WHERE tmp.strStatus IS NULL
UPDATE TOP (25) PERCENT tmp SET tmp.strStatus = 'Silver'
FROM #tmpCust tmp WHERE tmp.strStatus IS NULL
UPDATE TOP (25) PERCENT tmp SET tmp.strStatus = 'Platinum'
FROM #tmpCust tmp WHERE tmp.strStatus IS NULL
UPDATE TOP (25) PERCENT tmp SET tmp.strStatus = 'Bronze'
FROM #tmpCust tmp WHERE tmp.strStatus IS NULL
SELECT * FROM #tmpCust where CustomerID=(Select DISTINCT CustomerID from Tbl_Login Where UserID= '" + userID + "') DROP TABLE #tmpCust", sqlcon);
SqlDataReader SqlDr1 = cmd1.ExecuteReader();
while (SqlDr1.Read())
{
_OffersModelList.CustomerType = SqlDr1["strStatus"].ToString();
}
SqlDr1.Close();
sqlcon.Close();
}
catch (Exception ex)
{
}
return(_OffersModelList);
}
