public ActionResult DataSourceGetAll(DataManager dm)
{
OISTIModels obj = new OISTIModels();
IEnumerable data = obj.GetAll(null, null, null).ToList();
int count = obj.GetAll(null, null, null).ToList().Count();
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
public ActionResult PerfCatDataSource([FromBody] DataManagerRequest dm)
{
var _data = context.PcPerformanceCategory.OrderByDescending(a => a.PcCategoryCode).Where(a => (a.DeletedCat == false) || (a.DeletedCat == null)).ToList();
IEnumerable data = _data;
int count = _data.Count;
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformFiltering(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip > 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take > 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }));
}
public ActionResult CriteriaSearchDataSource([FromBody] DataManagerRequest dm, int?PcCategoryCode)
{
var _data = context.ViewPcCriteria.Where(a => (a.PcCategoryCode == PcCategoryCode)).ToList();
IEnumerable data = _data;
int count = _data.Count;
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformFiltering(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip > 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take > 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }));
}
protected void createEvent_Click(object sender, EventArgs e)
{
if (coverImage.HasFile)
{
User user = (User)Session["loggedUser"];
string en = eventName.Value;
string cn = category.Value;
string pl = place.Value;
string dt = date.Value;
int st = int.Parse(hours.Value.ToString());
int min = int.Parse(minutes.Value.ToString());
string strtime = st + ":" + min;
int dr = int.Parse(duration.Value.ToString());
int pr = int.Parse(price.Value.ToString());
string desc = description.Value;
string ci = coverImage.FileName;
int user_id = user.id;
DataOperations dop = new DataOperations();
string path = Server.MapPath("~/uploads/" + user_id);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
coverImage.SaveAs(path + "/" + ci);
Event eve = new Event(0, user_id, en, desc, cn, pl, dt, strtime, dr, pr, user_id + "/" + ci, 0);
if (dop.createEvent(eve))
{
Session["eventCreated"] = "Event Created Successfully. Sent for admin Approval.";
Response.Redirect("MyEvents.aspx");
}
else
{
errorMsg.InnerText = "Please try again";
}
}
else
{
errorMsg.InnerText = "Please select a cover image";
}
}
public override object Read(DataManagerRequest dataManager, string key = null)
{
if (PLUserAccounts == null)
{
return(null);
}
if (dataManager.Search != null && dataManager.Search.Count > 0)
{
// Searching
PLUserAccounts = DataOperations.PerformSearching(PLUserAccounts, dataManager.Search).ToList();
}
if (dataManager.Sorted != null && dataManager.Sorted.Count > 0)
{
// Sorting
PLUserAccounts = DataOperations.PerformSorting(PLUserAccounts, dataManager.Sorted).ToList();
}
if (dataManager.Where != null && dataManager.Where.Count > 0)
{
// Filtering
PLUserAccounts = DataOperations.PerformFiltering(PLUserAccounts, dataManager.Where, dataManager.Where[0].Operator).ToList();
}
int count = PLUserAccounts.Count();
if (dataManager.Skip != 0)
{
//Paging
PLUserAccounts = DataOperations.PerformSkip(PLUserAccounts, dataManager.Skip).ToList();
}
if (dataManager.Take != 0)
{
PLUserAccounts = DataOperations.PerformTake(PLUserAccounts, dataManager.Take).ToList();
}
return(dataManager.RequiresCounts ? new DataResult()
{
Result = PLUserAccounts, Count = count
} : (object)PLUserAccounts);
}
private static Dictionary <string, DataCommandConfig> GetAllDataCommandConfigInfos(out List <string> configFileList)
{
DataCommandFileList fileList = ConfigHelper.LoadSqlConfigListFile();
if (fileList == null || fileList.FileList == null || fileList.FileList.Length <= 0)
{
configFileList = new List <string>(1);
return(new Dictionary <string, DataCommandConfig>(0));
}
configFileList = new List <string>(fileList.FileList.Length + 1);
Dictionary <string, DataCommandConfig> cache = new Dictionary <string, DataCommandConfig>();
foreach (var file in fileList.FileList)
{
string path = file.FileName;
string root = Path.GetPathRoot(path);
if (root == null || root.Trim().Length <= 0)
{
path = Path.Combine(ConfigHelper.ConfigFolder, path);
}
if (!string.IsNullOrWhiteSpace(path) && File.Exists(path))
{
configFileList.Add(path);
}
DataOperations op = ConfigHelper.LoadDataCommandList(path);
if (op != null && op.DataCommand != null && op.DataCommand.Length > 0)
{
foreach (var da in op.DataCommand)
{
if (cache.ContainsKey(da.Name))
{
throw new ApplicationException("Duplicate name '" + da.Name + "' for data command in file '" + path + "'.");
}
cache.Add(da.Name, da);
}
}
}
return(cache);
}
static void Main(string[] args)
{
DataOperations ops = new DataOperations();
ops.TestSqlConnection();
if (ops.IsSuccessFul)
{
var foregroundColorColor = Console.ForegroundColor;
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine("Successfully connected!!!");
Console.ForegroundColor = foregroundColorColor;
}
else
{
var foregroundColorColor = Console.ForegroundColor;
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Unsuccessful");
Console.ForegroundColor = foregroundColorColor;
Console.WriteLine(ops.LastExceptionMessage);
}
Console.ReadLine();
}
public ActionResult DataSourceUserManagement(DataManager dm)
{
IEnumerable data = db.View_UserManagement.OrderBy(a => a.Email).ToList();
int count = db.View_UserManagement.OrderBy(a => a.Email).ToList().Count;
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip > 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take > 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
public bool CheckAccessRights(int Id, int UserId, string ControllerName, string ActionName, int HasAccess)
{
DataOperations DO = new DataOperations();
List <tbl_AccessRight> ARS = DO.GetAccessRights();
int cnt;
if (Id > 0 && HasAccess != 0)
{
cnt = ARS.Where(ar => ar.ID != Id && ar.UserId == UserId && ar.Controller == ControllerName && ar.Action == ActionName && ar.HasAccess == HasAccess).Count();
}
else if (Id > 0)
{
cnt = ARS.Where(ar => ar.ID != Id && ar.UserId == UserId && ar.Controller == ControllerName && ar.Action == ActionName).Count();
}
else
{
cnt = ARS.Where(ar => ar.UserId == UserId && ar.Controller == ControllerName && ar.Action == ActionName).Count();
}
bool result = cnt > 0 ? true : false;
return(result);
}
private void cmbUserName_SelectedValueChanged(object sender, EventArgs e)
{
try
{
if (cmbUserName.SelectedItem != null)
{
DataTable dtUserRoles = DataOperations.RetrieveUserRolesOnuserName(cmbUserName.SelectedItem.ToString());
if (dtUserRoles != null)
{
if (dtUserRoles.Rows.Count > 0)
{
ArrayList lstUserRoles = Validations.GetArrayListFromDataTable(dtUserRoles, 0);
cmbUserRole.DataSource = lstUserRoles;
}
}
}
}
catch (Exception ex)
{
PepsiLiteErrorHandling.WriteErrorLog(ex.ToString());
}
}
public ActionResult Edit(int id)
{
PersonVM viewModel = new PersonVM();
DataOperations dataOperations = new DataOperations();
RegionRepository regionRepository = new RegionRepository();
tbl_Person tblItem = dataOperations.GetPersonById(id);
viewModel = populateDropDownList(viewModel);
viewModel.ID = id;
viewModel.PIN = tblItem.PIN;
viewModel.FirstName = tblItem.Name;
viewModel.LastName = tblItem.Surname;
viewModel.FatherName = tblItem.Fathername;
viewModel.GenderType = (int)tblItem.Gender;
viewModel.PersonType = (int)tblItem.PersonType;
viewModel.Address = tblItem.Address;
viewModel.Description = tblItem.Description;
return(View(viewModel));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["loggedUser"] != null)
{
if (((User)Session["loggedUser"]).type.Equals("admin"))
{
Response.Redirect("index.aspx");
}
else
{
}
}
else
{
Response.Redirect("index.aspx");
}
int eventId = int.Parse(Request["id"].ToString());
DataOperations dop = new DataOperations();
dop.deleteEvent(eventId);
Response.Redirect("MyEvents.aspx");
}
private void ChangeCurrentOperation(DataOperations newState)
{
MenuItem item = findMenuItemByName("Вставить");
switch (newState)
{
case DataOperations.none:
currentOperation = DataOperations.none;
item.IsEnabled = false;
break;
case DataOperations.copy:
currentOperation = DataOperations.copy;
item.IsEnabled = true;
break;
case DataOperations.cut:
currentOperation = DataOperations.cut;
item.IsEnabled = true;
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["loggedUser"] != null)
{
if (((User)Session["loggedUser"]).type.Equals("admin"))
{
Response.Redirect("index.aspx");
}
else
{
}
}
else
{
Response.Redirect("index.aspx");
}
DataOperations dop = new DataOperations();
int eventId = int.Parse(Request["id"].ToString());
eve = dop.getEvent(eventId);
if (eve == null)
{
Response.Redirect("MyEvents.aspx");
}
else
{
if (!IsPostBack)
{
eventName.Value = eve.name;
place.Value = eve.place;
category.Value = eve.category_name;
date.Value = eve.date;
hours.Value = eve.start_time.Substring(0, eve.start_time.IndexOf(':'));
minutes.Value = eve.start_time.Substring(eve.start_time.IndexOf(':') + 1);
duration.Value = eve.duration.ToString();
price.Value = eve.price.ToString();
}
}
}
public void RowFitler_EqualsCaseSensitiveUsingNewView()
{
// arrange
var bsContact = new BindingSource();
var ops = new DataOperations();
bsContact.DataSource = ops.GetAll();
// act
var newView = bsContact.RowFilterNewView("ContactTitle", "Owner", true);
// assert 1
Assert.IsTrue(bsContact.Count == 19,
"Expected 19 records");
// act 2
bsContact.RowFilter("ContactTitle", "Order Administrator", true);
// assert 2
Assert.IsTrue(bsContact.Count == 2,
"Expected 2 records");
}
public ActionResult DataSourceFacility(DataManager dm)
{
IEnumerable data = _context.ViewAFacility.OrderBy(o => o.Facility).ToList();
int count = _context.ViewAFacility.ToList().Count();
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }));
}
public static float GetZoomAmountFromPinch(TouchState fingerOne, TouchState fingerTwo)
{
// Pinching
if (DataOperations.IsPinching(ref fingerOne.Delta.X, ref fingerTwo.Delta.X, ref fingerOne.Delta.Y, ref fingerTwo.Delta.Y))
{
// Get delta distance between both touches
double oldDistance = DataOperations.GetDistance2D(fingerOne.LastPosition.X, fingerTwo.LastPosition.X, fingerOne.LastPosition.Y, fingerTwo.LastPosition.Y);
double newDistance = DataOperations.GetDistance2D(fingerOne.Position.X, fingerTwo.Position.X, fingerOne.Position.Y, fingerTwo.Position.Y);
double deltaDistance = oldDistance - newDistance;
// Precision control
if (Math.Abs(deltaDistance) > pinchPrecision)
{
float scale = (float)(newDistance / oldDistance);
float zoom = (newDistance > oldDistance) ? scale : -scale;
zoom *= newDistance < oldDistance ? pinchSpeed * 2.0f : pinchSpeed;
return(zoom);
}
}
return(0);
}
public async Task GetProductsWithoutProjection()
{
var expectedProductName = "Chai";
var categoryIdentifier = 1;
var expectedProductIdentifier = 1;
var expectedUnitsInStock = 39;
var result = await DataOperations.GetProductsWithoutProjection(categoryIdentifier);
var firstProduct = result.FirstOrDefault();
Assert.IsTrue(firstProduct is not null, "Expected a product");
Assert.IsTrue(firstProduct.ProductName == expectedProductName,
$"Expected product-name {expectedProductName} got {firstProduct.ProductName}");
Assert.IsTrue(firstProduct.ProductId == expectedProductIdentifier,
$"Expected product-id {expectedProductIdentifier} got {firstProduct.ProductId}");
Assert.IsTrue(firstProduct.UnitsInStock == expectedUnitsInStock,
$"Expected units in stock {expectedUnitsInStock} got {firstProduct.UnitsInStock}");
}
public ActionResult Create(BusinessCenterVM viewModel)
{
try
{
var UserProfile = (UserProfileSessionData)this.Session["UserProfile"];
if (UserProfile != null)
{
tbl_BusinessCenter item = new tbl_BusinessCenter()
{
Name = viewModel.Name,
Description = viewModel.Description,
Address = viewModel.Address,
InsertDate = DateTime.Now,
InsertUser = UserProfile.UserId
};
DataOperations dataOperations = new DataOperations();
tbl_BusinessCenter dbItem = dataOperations.AddBusinessCenter(item);
if (dbItem != null)
{
TempData["success"] = "Ok";
TempData["message"] = "Məlumatlar uğurla əlavə olundu";
return(RedirectToAction("Index"));
}
else
{
TempData["success"] = "notOk";
TempData["message"] = "Məlumatlar əlavə olunarkən xəta baş verdi";
return(RedirectToAction("Index"));
}
}
}
catch (ApplicationException ex)
{
return(View(viewModel));
}
throw new ApplicationException("Invalid model");
}
/// <summary>
/// Send email with a callback, not no using statement is used as
/// doing so would circumvent the callback.
/// </summary>
/// <param name="pConfigurationSection"></param>
/// <param name="pSendToo"></param>
/// <returns></returns>
public async Task ExampleSend3Async(string pConfigurationSection, string pSendToo, [CallerMemberName] string name = "")
{
var ops = new DataOperations();
var data = ops.Read(5);
var mc = new MailConfiguration(pConfigurationSection);
var mail = new MailMessage
{
Subject = $"Called from: {name}",
From = new MailAddress(mc.FromAddress)
};
mail.To.Add(pSendToo);
mail.Priority = MailPriority.High;
mail.IsBodyHtml = true;
mail.AlternateViews.PlainTextView(data.TextMessage);
mail.AlternateViews.HTmlView(data.HtmlMessage);
//send the message
var smtp = new SmtpClient(mc.Host, mc.Port)
{
Credentials = new NetworkCredential(mc.UserName, mc.Password),
EnableSsl = mc.EnableSsl
};
smtp.SendCompleted += Smtp_SendCompleted;
smtp.SendCompleted += (s, e) => {
smtp.Dispose();
mail.Dispose();
};
// ReSharper disable once AsyncConverter.AsyncAwaitMayBeElidedHighlighting
await smtp.SendMailAsync(mail).ConfigureAwait(false);
}
public static void Login(byte[] data, int length)
{
int offset = 1;
var reconnecting = DataOperations.getByte(data, offset++);
var clientVersion = DataOperations.getShort(data, offset);
/* -- First bytes are always:
* 75
* 0
* 0
* 155
* 41
* 165
* 20
* 232
* 64
*/
/*
* Rest of packet is encrypted
*/
}
protected void removeFriend(long arg0)
{
streamClass.createPacket(52);
streamClass.addLong(arg0);
streamClass.formatPacket();
for (int i = 0; i < friendsCount; i++)
{
if (friendsList[i] != arg0)
{
continue;
}
friendsCount--;
for (int j = i; j < friendsCount; j++)
{
friendsList[j] = friendsList[j + 1];
friendsWorld[j] = friendsWorld[j + 1];
}
break;
}
displayMessage("@pri@" + DataOperations.hashToName(arg0) + " has been removed from your friends list");
}
public ActionResult UrlDatasource([FromBody] DataManagerRequest dm)
{
IEnumerable DataSource = _context.Orders.ToList();
DataOperations operation = new DataOperations();
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
DataSource = operation.PerformSorting(DataSource, dm.Sorted);
}
int count = DataSource.Cast <Orders>().Count();
if (dm.Skip != 0)//Paging
{
DataSource = operation.PerformSkip(DataSource, dm.Skip);
}
if (dm.Take != 0)
{
DataSource = operation.PerformTake(DataSource, dm.Take);
}
return(Json(new { result = DataSource, count = count }));
}
public IActionResult ForDropDown([FromBody] DataManagerRequest dm)
{
IEnumerable <Suppliers> DataSource = null;//= data.SqlQuery<Products>("select * from Products");
DataOperations operation = new DataOperations();
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
if (dm.Where.FirstOrDefault().value != null)
{
// DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
DataSource = data.SqlQuery <Suppliers>($"SELECT [Id], [Name] from Suppliers where " +
$"[Name] like CONCAT('%',@searching,'%') or " +
$"[Code] like CONCAT('%',@searching,'%') ORDER BY Id OFFSET 0 ROWS FETCH NEXT 100 ROWS ONLY", new { searching = dm.Where.FirstOrDefault().value });
}
}
if (DataSource == null)
{
DataSource = data.SqlQuery <Suppliers>($"SELECT [Id], [Name] from Suppliers ORDER BY Id OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY");
}
int count = data.SqlQuery <int>("select count(*) from Suppliers").FirstOrDefault();
return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource));
}
/// <summary>
/// Загрузить данные с API и с файла.
/// </summary>
/// <param name="connectionSettings">настройки подключения.</param>
/// <returns>Результат операции.</returns>
public async Task <bool> DownloadDataAsync(ConnectionSettings connectionSettings)
{
try
{
var dataOperation = new DataOperations(connectionSettings);
var result = await dataOperation.DownloadDataFromAPIAsync();
if (result)
{
await LoadDataAsync();
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
private void frmLogin_Load(object sender, EventArgs e)
{
try
{
GetUserNamesAndSetToUserNameTxtBox_AutoComplete();
DataTable dtUserRoles = DataOperations.GetUserRoles();
if (dtUserRoles != null)
{
if (dtUserRoles.Rows.Count > 0)
{
UserRoleTbl = dtUserRoles;
cmbUserRoles.DataSource = Validations.GetArrayListFromDataTable(dtUserRoles, 1);
cmbUserRoles.SelectedIndex = 1;
}
}
}
catch (Exception ex)
{
PepsiLiteErrorHandling.WriteErrorLog(ex.ToString());
}
}
public object Post([FromBody] DataManagerRequest dm)
{
BindDataSource();
IEnumerable DataSource = Orders.ToList();
if (dm.Search != null && dm.Search.Count > 0)
{
DataSource = DataOperations.PerformSearching(DataSource, dm.Search); //Search
}
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
DataSource = DataOperations.PerformSorting(DataSource, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
DataSource = DataOperations.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
}
int count = DataSource.Cast <Order>().Count();
if (dm.Skip != 0)
{
DataSource = DataOperations.PerformSkip(DataSource, dm.Skip); //Paging
}
if (dm.Take != 0)
{
DataSource = DataOperations.PerformTake(DataSource, dm.Take);
}
if (dm.RequiresCounts)
{
return new { result = DataSource, count = count }
}
;
else
{
return new { result = DataSource }
};
}
/*
* SectionX and SectionY is basically
* Our starting X,Y. But with nothing better to go with
* The one that is default used is the one we get from starting pos in lumbridge
* (Grabbed from my XNA Client :P for quick ref)
*/
public static void SetInventoryItems(sbyte[] packetData, int length)
{
var inv = Inventory.Instance;
inv.Clear();
int off = 1;
var inventoryItemsCount = packetData[off++] & 0xff;
for (int item = 0; item < inventoryItemsCount; item++)
{
int data = DataOperations.getShort(packetData, off);
off += 2;
var itemIndex = data & 0x7fff;
var invItem = new InventoryItem(itemIndex, data / 32768);
invItem.ItemPictureIndex = DataLoader.baseItemPicture + Data.itemInventoryPicture[itemIndex];
invItem.ItemPictureMask = Data.itemPictureMask[itemIndex];
// inventoryItems[item] = data & 0x7fff;
// inventoryItemEquipped[item] = data / 32768;
if (Data.itemStackable[data & 0x7fff] == 0)
{
invItem.Amount = DataOperations.getInt(packetData, off);
// inventoryItemCount[item] = DataOperations.getInt(packetData, off);
off += 4;
}
else
{
invItem.Amount = 1;
// inventoryItemCount[item] = 1;
}
inv.Add(invItem);
}
}
public override object Read(DataManagerRequest dm, string key = null)
{
dummyProperty.InterfaceMethod();
IEnumerable <Ord> DataSource = Orders;
if (dm.Search != null && dm.Search.Count > 0)
{
// Searching
DataSource = DataOperations.PerformSearching(DataSource, dm.Search);
}
if (dm.Sorted != null && dm.Sorted.Count > 0)
{
// Sorting
DataSource = DataOperations.PerformSorting(DataSource, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0)
{
// Filtering
DataSource = DataOperations.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);
}
int count = DataSource.Cast <Ord>().Count();
if (dm.Skip != 0)
{
//Paging
DataSource = DataOperations.PerformSkip(DataSource, dm.Skip);
}
if (dm.Take != 0)
{
DataSource = DataOperations.PerformTake(DataSource, dm.Take);
}
return(dm.RequiresCounts ? new DataResult()
{
Result = DataSource, Count = count
} : (object)DataSource);
}
public ActionResult DataSource([FromBody] DataManagerRequest dm)
{
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(iBaseURI);
MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json");
client.DefaultRequestHeaders.Accept.Add(contentType);
HttpResponseMessage response = client.GetAsync("/api/VehicleTypes/?mdBID=" + mdBId).Result;
var stringData = response.Content.ReadAsStringAsync().Result;
List <VehicleType> acaSession = JsonConvert.DeserializeObject <List <VehicleType> >(stringData);
DataOperations operation = new DataOperations();
IEnumerable data = acaSession;
var count = data.AsQueryable().Count();
if (dm.Skip > 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take > 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }));
}
}
