public ActionResult CountrySearch([C1JsonRequest] CollectionViewRequest <Country> requestData)
{
countrylist = GetCountriesForMultiColumnComboBox();
ncountrylist = countrylist.ToList();
IEnumerable <Country> selectedcountryList = ncountrylist;
if (requestData.ExtraRequestData.Count > 0)
{
var query = requestData.ExtraRequestData["AutoCompleteQuery"] as string;
if (query != null && query != "")
{
var names = query.Split(',');
selectedcountryList = countrylist.Where(item => names.Any(n => item.CountryName.IndexOf(n, StringComparison.OrdinalIgnoreCase) >= 0));
}
}
// Delay result
System.Threading.Thread.Sleep(50);
var resultList = selectedcountryList.Select(item => new Country
{
CountryName = item.CountryName,
CountryShortName = item.CountryShortName,
CountryCode = item.CountryCode
});
return(this.C1Json(CollectionViewHelper.Read(requestData, resultList)));
}
public ActionResult RemoteBindCustomerSale_Read([C1JsonRequest] CollectionViewRequest <Sale> requestData)
{
return(this.C1Json(CollectionViewHelper.Read(requestData, SALES, (col) =>
{
if (col.Binding == "Country")
{
return CustomerSale.NAMEDCOUNTRIES;
}
if (col.Binding == "Product")
{
return CustomerSale.PRODUCTS;
}
if (col.Binding == "Color")
{
return CustomerSale.COLORS;
}
if (col.Binding == "Rank")
{
return CustomerSale.RANKS;
}
return null;
})));
}
public ActionResult GridUpdateSale([C1JsonRequest] CollectionViewEditRequest <Sale> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit <Sale>(requestData, item =>
{
string error = string.Empty;
bool success = true;
try
{
var resultItem = ValidationSales.Find(s => s.ID == item.ID);
var index = ValidationSales.IndexOf(resultItem);
ValidationSales.Remove(resultItem);
ValidationSales.Insert(index, item);
}
catch (Exception e)
{
error = e.Message;
success = false;
}
return new CollectionViewItemResult <Sale>
{
Error = error,
Success = success,
Data = item
};
}, () => ValidationSales)));
}
public ActionResult GridUpdateUserInfo([C1JsonRequest] CollectionViewEditRequest <UserInfo> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit <UserInfo>(requestData, item =>
{
string error = string.Empty;
bool success = true;
try
{
var resultItem = users.Find(u => u.Id == item.Id);
var index = users.IndexOf(resultItem);
users.Remove(resultItem);
users.Insert(index, item);
}
catch (Exception e)
{
error = e.Message;
success = false;
}
return new CollectionViewItemResult <UserInfo>
{
Error = error,
Success = success,
Data = item
};
}, () => users)));
}
public ActionResult ProductsUpdate([C1JsonRequest] CollectionViewEditRequest <Sale> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit <Sale>(requestData, sale =>
{
string error = string.Empty;
bool success = true;
var fSale = SALES.Find(item => item.ID == sale.ID);
fSale.Active = sale.Active;
fSale.Amount = sale.Amount;
fSale.Color = sale.Color;
fSale.Country = sale.Country;
fSale.Discount = sale.Discount;
fSale.End = sale.End;
fSale.Amount2 = sale.Amount2;
fSale.Start = sale.Start;
fSale.Product = sale.Product;
fSale.Rank = sale.Rank;
return new CollectionViewItemResult <Sale>
{
Error = error,
Success = success,
Data = fSale
};
}, () => SALES)));
}
public ActionResult GetProducts()
{
var strType = HttpContext.Request["productType"];
var type = !string.IsNullOrEmpty(strType) ? Convert.ToInt32(strType) : 0;
return(this.C1Json(CollectionViewHelper.Read(new CollectionViewRequest <ProductItem>(), DataService.GetProductItemList((CategoryType)type))));
}
//To Delete selected portfolio
public ActionResult GridDelete([C1JsonRequest] CollectionViewEditRequest <PortfolioStatic.Portfolio> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit <PortfolioStatic.Portfolio>(requestData, customer =>
{
string error = string.Empty;
bool success = true;
try
{
var result = PortfolioStatic.PortfolioList.FirstOrDefault(item => item.Symbol == customer.Symbol);
if (result != null)
{
PortfolioStatic.PortfolioList.Remove(result);
}
else
{
error = "Cannot find the item.";
success = false;
}
}
catch (Exception e)
{
error = e.Message;
success = false;
}
return new CollectionViewItemResult <PortfolioStatic.Portfolio>
{
Error = error,
Success = success && ModelState.IsValid,
Data = customer
};
}, () => PortfolioStatic.PortfolioList.ToList <PortfolioStatic.Portfolio>())));
}
public ActionResult GridShowCaseUpdate([C1JsonRequest] CollectionViewEditRequest <Sale> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit(requestData, sale =>
{
string error = string.Empty;
bool success = true;
try
{
var fSale = model.Find(item => item.ID == sale.ID);
fSale.Country = sale.Country;
fSale.Amount = sale.Amount;
fSale.Start = sale.Start;
fSale.End = sale.End;
fSale.Product = sale.Product;
fSale.Active = sale.Active;
fSale.Amount2 = sale.Amount2;
fSale.Color = sale.Color;
fSale.Discount = sale.Discount;
}
catch (Exception e)
{
error = e.Message;
success = false;
}
return new CollectionViewItemResult <Sale>
{
Error = error,
Success = success,
Data = sale
};
}, () => model)));
}
public ActionResult ShowCase_Bind([C1JsonRequest] CollectionViewRequest <Sale> requestData)
{
var extraData = requestData.ExtraRequestData
.ToDictionary(kvp => kvp.Key, kvp => new StringValues(kvp.Value.ToString()));
var data = new FormCollection(extraData);
_showcaseOption.LoadPostData(data);
model = Sale.GetData(getDataSize()).Select(x => SaleShowCase.FromSale(x)).ToList();
return(this.C1Json(CollectionViewHelper.Read(requestData, model)));
}
public ActionResult GetProducts()
{
#if ASPNETCORE
string strType = this.HttpContext.Request.Query["productType"];
#else
string strType = this.HttpContext.Request["productType"];
#endif
int type = !string.IsNullOrEmpty(strType) ? Convert.ToInt32(strType) : 0;
return(this.C1Json(CollectionViewHelper.Read(new CollectionViewRequest <ProductItem>(), DataService.GetProductItemList((CategoryType)type))));
}
public ActionResult GetTasks()
{
UpdateDateRange();
var strType = HttpContext.Request["taskType"];
var type = !string.IsNullOrEmpty(strType) ? Convert.ToInt32(strType) : 0;
var respone = new ArrayList();
respone.Add(CollectionViewHelper.Read(new CollectionViewRequest <CampainTaskItem>(), DataService.GetTaskItem((CampainTaskType)type)));
return(this.C1Json(respone));
}
public ActionResult ColumnPinning_Bind([C1JsonRequest] CollectionViewRequest <Sale> requestData)
{
var extraData = requestData.ExtraRequestData
.ToDictionary(kvp => kvp.Key, kvp => new StringValues(kvp.Value.ToString()));
var data = new FormCollection(extraData);
_columnPinningDataModel.LoadPostData(data);
var model = Sale.GetData(500);
return(this.C1Json(CollectionViewHelper.Read(requestData, model)));
}
public ActionResult OnPostBind([C1JsonRequest] CollectionViewRequest <Sale> requestData)
{
var extraData = requestData.ExtraRequestData
.ToDictionary(kvp => kvp.Key, kvp => new StringValues(kvp.Value.ToString()));
var data = new FormCollection(extraData);
_gridDataModel.LoadPostData(data);
var model = Sale.GetData(Convert.ToInt32(_gridDataModel.Options["items"].CurrentValue));
return(JsonConvertHelper.C1Json(CollectionViewHelper.Read(requestData, model)));
}
public ActionResult Sorting_Bind([C1JsonRequest] CollectionViewRequest <Sale> requestData)
{
var extraData = requestData.ExtraRequestData
.ToDictionary(kvp => kvp.Key, kvp => new StringValues(kvp.Value.ToString()));
var data = new FormCollection(extraData);
_optionsModel.LoadPostData(data);
var model = Sale.GetData(10).ToList();
var nullObj = new Sale {
};
model.Add(nullObj);
return(this.C1Json(CollectionViewHelper.Read(requestData, model)));
}
public ActionResult GetAnalysisData()
{
this.UpdateDateRange();
ArrayList respone = new ArrayList();
List <ProductsWiseSaleItem> categoryRegionSale = DataService.GetCategoryRegionWiseSales();
respone.Add(CollectionViewHelper.Read <ProductsWiseSaleItem>(new CollectionViewRequest <ProductsWiseSaleItem>(), categoryRegionSale));
var opportunities = DataService.OpportunityItemList;
respone.Add(CollectionViewHelper.Read <Opportunity>(new CollectionViewRequest <Opportunity>(), opportunities));
return(this.C1Json(respone));
}
public ActionResult Create([C1JsonRequest] CollectionViewEditRequest <Fruit> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit <Fruit>(requestData, fruit =>
{
string error = string.Empty;
bool success = true;
fruit.ID = GetId();
fruitsSales.Add(fruit);
return new CollectionViewItemResult <Fruit>
{
Error = error,
Success = success,
Data = fruit
};
}, () => fruitsSales)));
}
public ActionResult Delete([C1JsonRequest] CollectionViewEditRequest <Fruit> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit <Fruit>(requestData, fruit =>
{
string error = string.Empty;
bool success = true;
var fSale = fruitsSales.Find(item => item.ID == fruit.ID);
fruitsSales.Remove(fSale);
return new CollectionViewItemResult <Fruit>
{
Error = error,
Success = success,
Data = fruit
};
}, () => fruitsSales)));
}
public ActionResult PreserveWhiteSpace_Bind([C1JsonRequest] CollectionViewRequest <Sale> requestData)
{
var extraData = requestData.ExtraRequestData
.ToDictionary(kvp => kvp.Key, kvp => new StringValues(kvp.Value.ToString()));
var data = new FormCollection(extraData);
_columnPinningDataModel.LoadPostData(data);
var model = Sale.GetData(50).ToList();
model.ForEach(x => {
if (x.Color.Equals("Black") || x.Color.Equals("White"))
{
x.Color = string.Format(" {0} ", x.Color);
}
});
return(this.C1Json(CollectionViewHelper.Read(requestData, model)));
}
//Get Portfolio
public ActionResult GetPortfolio([C1JsonRequest] CollectionViewRequest <PortfolioStatic.Portfolio> requestData)
{
//To check if new Symbol has been requested, add the new symbol and return portfolio else return original portfolio
const string stockNamesKey = "stockNames";
if (requestData.ExtraRequestData != null && requestData.ExtraRequestData.ContainsKey(stockNamesKey))
{
var stockNameString = requestData.ExtraRequestData[stockNamesKey] as string;
if (!string.IsNullOrEmpty(stockNameString))
{
var stockNames = stockNameString.Split(',').ToList();
string SymbolToAdd = stockNames[stockNames.Count - 1];
PortfolioStatic.AddToPortfolioList(SymbolToAdd);
}
}
return(this.C1Json(CollectionViewHelper.Read(requestData, PortfolioModel.PortfolioList)));
}
public ActionResult NVGridUpdate([C1JsonRequest] CollectionViewEditRequest <Sale> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit(requestData, sale =>
{
string error = string.Empty;
bool success = true;
var fSale = FlexGridModel.Source.Find(item => item.ID == sale.ID);
fSale.Country = sale.Country;
fSale.Product = sale.Product;
fSale.Amount = sale.Amount;
fSale.Discount = sale.Discount;
return new CollectionViewItemResult <Sale>
{
Error = error,
Success = success,
Data = fSale
};
}, () => FlexGridModel.Source)));
}
public ActionResult RemoteBindCustomerSale_Read([C1JsonRequest] CollectionViewRequest <Sale> requestData)
{
return(this.C1Json(CollectionViewHelper.Read(requestData, SALES, (col) =>
{
var cell = col as C1.Web.Mvc.MultiRow.CellInfo;
if (cell.Binding == "Product")
{
return CustomerSale.PRODUCTS;
}
if (cell.Binding == "Color")
{
return CustomerSale.COLORS;
}
return null;
})));
}
public ActionResult Update([C1JsonRequest] CollectionViewEditRequest <Fruit> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit <Fruit>(requestData, fruit =>
{
string error = string.Empty;
bool success = true;
var fSale = fruitsSales.Find(item => item.ID == fruit.ID);
fSale.Name = fruit.Name;
fSale.Country = fruit.Country;
fSale.MayPrice = fruit.MayPrice;
fSale.MarPrice = fruit.MarPrice;
fSale.AprPrice = fruit.AprPrice;
return new CollectionViewItemResult <Fruit>
{
Error = error,
Success = success,
Data = fSale
};
}, () => fruitsSales)));
}
public ActionResult MultiRowEditorsUpdate([C1JsonRequest] CollectionViewEditRequest <Sale> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit <Sale>(requestData, sale =>
{
string error = string.Empty;
bool success = true;
var fSale = Source.Find(item => item.ID == sale.ID);
fSale.Country = sale.Country;
fSale.Amount = sale.Amount;
fSale.Start = sale.Start;
fSale.End = sale.End;
fSale.Product = sale.Product;
fSale.Active = sale.Active;
fSale.Amount2 = sale.Amount2;
fSale.Color = sale.Color;
return new CollectionViewItemResult <Sale>
{
Error = error,
Success = success && ModelState.IsValid,
Data = fSale
};
}, () => Source)));
}
//To Update selected portfolio
public ActionResult GridUpdate([C1JsonRequest] CollectionViewEditRequest <PortfolioStatic.Portfolio> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit <PortfolioStatic.Portfolio>(requestData, customer =>
{
string error = string.Empty;
bool success = true;
try
{
PortfolioStatic.PortfolioList.Where(x => x.Symbol == customer.Symbol).ToList().ForEach(x =>
{
x.Change = customer.Change;
x.Chart = customer.Chart;
x.Color = customer.Color;
x.Cost = customer.Shares * customer.Price;
x.Gain = customer.Price > 0 ? (customer.LastPrice - customer.Price) / customer.Price : 0;
x.LastPrice = customer.LastPrice;
x.Name = customer.Name;
x.Price = customer.Price;
x.PriceHistory = customer.PriceHistory;
x.Shares = customer.Shares;
x.Symbol = customer.Symbol;
x.Value = customer.Value;
});
}
catch (Exception e)
{
error = e.Message;
success = false;
}
return new CollectionViewItemResult <PortfolioStatic.Portfolio>
{
Error = error,
Success = success && ModelState.IsValid,
Data = customer
};
}, () => PortfolioStatic.PortfolioList.ToList <PortfolioStatic.Portfolio>())));
}
private ActionResult Delete <T>(CollectionViewEditRequest <T> requestData, DbSet <T> data, Func <T, object> getKey) where T : class
{
return(this.C1Json(CollectionViewHelper.Edit(requestData, item =>
{
string error = string.Empty;
bool success = true;
try
{
T resultItem = null;
foreach (var i in data)
{
if (string.Equals(getKey(i).ToString(), getKey(item).ToString()))
{
resultItem = i;
break;
}
}
if (resultItem != null)
{
data.Remove(resultItem);
_db.SaveChanges();
}
}
catch (Exception e)
{
error = GetExceptionMessage(e);
success = false;
}
return new CollectionViewItemResult <T>
{
Error = error,
Success = success,
Data = item
};
}, () => data.ToList())));
}
public ActionResult GridEditorsCreate([C1JsonRequest] CollectionViewEditRequest <Sale> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit(requestData, item =>
{
string error = string.Empty;
bool success = true;
try
{
Source.Add(item);
item.ID = Source.Max(u => u.ID) + 1;
}
catch (Exception e)
{
error = e.Message;
success = false;
}
return new CollectionViewItemResult <Sale>
{
Error = error,
Success = success,
Data = item
};
}, () => Source)));
}
public ActionResult MultiRowEditorsDelete([C1JsonRequest] CollectionViewEditRequest <Sale> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit(requestData, item =>
{
string error = string.Empty;
bool success = true;
try
{
var resultItem = Source.Find(u => u.ID == item.ID);
Source.Remove(resultItem);
}
catch (Exception e)
{
error = e.Message;
success = false;
}
return new CollectionViewItemResult <Sale>
{
Error = error,
Success = success,
Data = item
};
}, () => Source)));
}
private ActionResult Create <T>(CollectionViewEditRequest <T> requestData, DbSet <T> data) where T : class
{
return(this.C1Json(CollectionViewHelper.Edit <T>(requestData, item =>
{
string error = string.Empty;
bool success = true;
try
{
data.Add(item);
_db.SaveChanges();
}
catch (Exception e)
{
error = GetExceptionMessage(e);
success = false;
}
return new CollectionViewItemResult <T>
{
Error = error,
Success = success,
Data = item
};
}, () => data.ToList <T>())));
}
public ActionResult GridCreateUserInfo([C1JsonRequest] CollectionViewEditRequest <UserInfo> requestData)
{
return(this.C1Json(CollectionViewHelper.Edit <UserInfo>(requestData, item =>
{
string error = string.Empty;
bool success = true;
try
{
users.Add(item);
item.Id = users.Max(u => u.Id) + 1;
}
catch (Exception e)
{
error = e.Message;
success = false;
}
return new CollectionViewItemResult <UserInfo>
{
Error = error,
Success = success,
Data = item
};
}, () => users)));
}
public ActionResult GetTopData()
{
UpdateDateRange();
var respone = new ArrayList();
var topProducts = DataService.GetTopSaleProductList(3);
respone.Add(CollectionViewHelper.Read(new CollectionViewRequest <SaleItem>(), topProducts));
List <SaleItem> topCustomers = DataService.GetTopSaleCustomerList(7);
respone.Add(CollectionViewHelper.Read(new CollectionViewRequest <SaleItem>(), topCustomers));
List <SaleGoalItem> goalItems = DataService.CategorySalesVsGoal;
respone.Add(CollectionViewHelper.Read(new CollectionViewRequest <SaleGoalItem>(), goalItems));
List <SaleGoalItem> regionalGoalItems = DataService.RegionSalesVsGoal;
respone.Add(CollectionViewHelper.Read(new CollectionViewRequest <SaleGoalItem>(), regionalGoalItems));
return(this.C1Json(respone));
}
