public StoryEntryModel(List <int> storyFlag, int index)
{
this.storyFlag = storyFlag;
this.index = index;
if (StoryPresets.KnownStoryFlags.TryGetValue(index, out var preset))
{
Preset = new StoryPresetModel(preset);
}
}
public StoryEntryModel(List <int> storyFlag, int index)
{
this.storyFlag = storyFlag;
this.index = index;
if (Presets.STORY.TryGetValue((StoryFlagType)index, out var preset))
{
Preset = new StoryPresetModel(preset);
}
}
public GenericListModel <CompanyModel> GetSearchCompaniesList(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <CompanyModel> baseListModel = new GenericListModel <CompanyModel>();
try
{
//if (!base.CompanyHasPermision(baseListModel))
// return baseListModel;
IQueryable <Company> companies = prepareSearch(dataTableSearchParameters.search.value);
foreach (JQDTColumnOrder order in dataTableSearchParameters.order)
{
switch (order.column)
{
case 0:
if (order.dir == JQDTColumnOrderDirection.asc)
{
companies = companies.OrderBy(c => c.Name);
}
else
{
companies = companies.OrderByDescending(c => c.Name);
}
break;
case 1:
if (order.dir == JQDTColumnOrderDirection.asc)
{
companies = companies.OrderBy(c => c.Notes);
}
else
{
companies = companies.OrderByDescending(c => c.Notes);
}
break;
}
}
baseListModel.Total = companies.Count();
companies = companies.Skip(dataTableSearchParameters.start);
if (dataTableSearchParameters.length != -1)
{
companies = companies.Take(dataTableSearchParameters.length);
}
CompanyMapper.Map(dbContext, companies.ToList(), baseListModel.List);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
public ActionResult CampaignList()
{
ViewBag.Title = string.Format(ViewBag.Title, "Kampanyalar");
var campaigns = Client.Services.API.Management.GetCampaigns();
var model = new GenericListModel <CampaignModel>();
if (campaigns != null && campaigns.Count > 0)
{
model.Items = Mapper.Map <List <CampaignModel> >(campaigns);
}
return(View(model));
}
public ActionResult AccessNodeList()
{
ViewBag.Title = string.Format(ViewBag.Title, "Erişim Noktaları");
var accessNodes = Client.Services.API.Management.GetAccessNodes();
var model = new GenericListModel <AccessNodeModel>();
if (accessNodes != null && accessNodes.Count > 0)
{
model.Items = Mapper.Map <List <AccessNodeModel> >(accessNodes);
}
return(View(model));
}
public ActionResult UserList()
{
ViewBag.Title = string.Format(ViewBag.Title, "Kullanıcılar");
var users = Client.Services.API.Visa.GetUsers();
var model = new GenericListModel <UserModel>();
if (users != null && users.Count > 0)
{
model.Items = Mapper.Map <List <UserModel> >(users);
}
return(View(model));
}
public GenericListModel <SettingModel> GetSearchSettingsList(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <SettingModel> baseListModel = new GenericListModel <SettingModel>();
try
{
//if (!base.UserHasPermision(baseListModel))
// return baseListModel;
IQueryable <Setting> settings = dbContext.Settings.OrderBy(x => x.CreatedAt);
if (!string.IsNullOrEmpty(dataTableSearchParameters.search.value))
{
settings = settings.Where(x => x.Key.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()));
}
foreach (JQDTColumnOrder order in dataTableSearchParameters.order)
{
switch (order.column)
{
case 0:
if (order.dir == JQDTColumnOrderDirection.asc)
{
settings = CommonLayer.Helpers.Utilites.GetLocalizedOrderBy(settings.OrderBy(c => c.EnglishName), settings.OrderBy(c => c.ArabicName));
}
else
{
settings = CommonLayer.Helpers.Utilites.GetLocalizedOrderBy(settings.OrderByDescending(c => c.EnglishName), settings.OrderByDescending(c => c.ArabicName));
}
break;
}
}
baseListModel.Total = settings.Count();
settings = settings.Skip(dataTableSearchParameters.start);
if (dataTableSearchParameters.length != -1)
{
settings = settings.Take(dataTableSearchParameters.length);
}
SettingMapper.Map(settings.ToList(), baseListModel.List);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
public JsonResult GetSettings(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <SettingModel> baseListModel = new GenericListModel <SettingModel>();
using (SettingBAL settingBAL = new SettingBAL(ContextInfo))
{
baseListModel = settingBAL.GetSearchSettingsList(dataTableSearchParameters);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetDriversBySelect2Parameters(Select2Parameters <bool> select2Parameters)
{
GenericListModel <DriverModel> baseListModel = new GenericListModel <DriverModel>();
using (DriverBAL driverBAL = new DriverBAL(ContextInfo))
{
baseListModel = driverBAL.GetDrivers(select2Parameters);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTrucks(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <TruckModel> baseListModel = new GenericListModel <TruckModel>();
using (TruckBAL truckBAL = new TruckBAL(ContextInfo))
{
baseListModel = truckBAL.GetSearchTrucksList(dataTableSearchParameters);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetUsers(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <UserModel> baseListModel = new GenericListModel <UserModel>();
using (UserBAL userBAL = new UserBAL(ContextInfo))
{
baseListModel = userBAL.GetSearchUsersList(dataTableSearchParameters);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetRoles(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <RoleModel> baseListModel = new GenericListModel <RoleModel>();
using (RoleBAL roleBAL = new RoleBAL(ContextInfo))
{
baseListModel = roleBAL.GetSearchRolesList(dataTableSearchParameters);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCompanies(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <CompanyModel> baseListModel = new GenericListModel <CompanyModel>();
using (CompanyBAL companyBAL = new CompanyBAL(ContextInfo))
{
baseListModel = companyBAL.GetSearchCompaniesList(dataTableSearchParameters);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetMyMessagesByOtherUser(string userID, int page, int pageSize)
{
GenericListModel <MessageModel> baseListModel = new GenericListModel <MessageModel>();
using (MessageBAL userBAL = new MessageBAL(ContextInfo))
{
baseListModel = userBAL.GetMyMessagesByOtherUser(userID, page, pageSize);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTrucksBySelect2Parameters(Select2Parameters <bool> select2Parameters)
{
GenericListModel <TruckModel> baseListModel = new GenericListModel <TruckModel>();
using (TruckBAL truckBAL = new TruckBAL(ContextInfo))
{
baseListModel = truckBAL.GetTrucks(select2Parameters);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCompaniesBySelect2Parameters(Select2Parameters <bool> select2Parameters)
{
GenericListModel <CompanyModel> baseListModel = new GenericListModel <CompanyModel>();
using (CompanyBAL companyBAL = new CompanyBAL(ContextInfo))
{
baseListModel = companyBAL.GetCompanies(select2Parameters);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public GenericListModel <RoleModel> GetSearchRolesList(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <RoleModel> baseListModel = new GenericListModel <RoleModel>();
try
{
IQueryable <AspNetRole> aspNetRoles = dbContext.AspNetRoles.OrderBy(x => x.CreatedAt);
if (!string.IsNullOrEmpty(dataTableSearchParameters.search.value))
{
aspNetRoles = aspNetRoles.Where(x => x.Name.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()));
}
foreach (JQDTColumnOrder order in dataTableSearchParameters.order)
{
switch (order.column)
{
case 0:
if (order.dir == JQDTColumnOrderDirection.asc)
{
aspNetRoles = aspNetRoles.OrderBy(c => c.Name);
}
else
{
aspNetRoles = aspNetRoles.OrderByDescending(c => c.Name);
}
break;
}
}
baseListModel.Total = aspNetRoles.Count();
aspNetRoles = aspNetRoles.Skip(dataTableSearchParameters.start);
if (dataTableSearchParameters.length != -1)
{
aspNetRoles = aspNetRoles.Take(dataTableSearchParameters.length);
}
RoleMapper.Map(aspNetRoles.ToList(), baseListModel.List);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
public PlacesViewModel(IMessageProvider messageProvider, Dictionary <string, List <Place> > places)
{
_messageProvider = messageProvider;
Items = new GenericListModel <PlaceViewModel>(places
.Select(x => new
{
World = x.Key,
Places = x.Value.Select((place, i) => new
{
Index = i,
Place = place
})
})
.SelectMany(x => x.Places, (x, place) => new PlaceViewModel(_messageProvider, x.World, place.Index, place.Place))
);
}
public JsonResult ListUsersWithLastMessageByCurrentUser()
{
//Thread.Sleep(10000) ;
GenericListModel <UserModel> baseListModel = new GenericListModel <UserModel>();
using (MessageBAL userBAL = new MessageBAL(ContextInfo))
{
baseListModel = userBAL.ListUsersWithLastMessageByCurrentUser();
}
return(Json(new
{
baseModel = baseListModel,
NotReadCount = baseListModel.List.Where(x => x.LastMessageModel.NotFromMeAndNotRead).Count()
}, JsonRequestBehavior.AllowGet));
}
public GenericListModel <MessageModel> GetMyMessagesByOtherUser(string userID, int page, int pageSize)
{
GenericListModel <MessageModel> baseListModel = new GenericListModel <MessageModel>();
try
{
IQueryable <LMYFrameWorkMVC.Common.DAL.Message> messages = dbContext.Messages.Where(x =>
(x.FromUserID == contextInfo.UserID && x.ToUserID == userID) ||
(x.FromUserID == userID && x.ToUserID == contextInfo.UserID)
).OrderByDescending(x => x.CreatedAt);
baseListModel.Total = messages.Count();
messages = messages.Skip(pageSize * (page - 1)).Take(pageSize);
MessageMapper.Map(dbContext, contextInfo.UserID, messages.ToList(), baseListModel.List);
//Action action = (() =>
//{
// using (var transaction = dbContext.Database.BeginTransaction())
// {
// try
// {
// //update all other users messages
// messages.Where(x => x.FromUserID != contextInfo.UserID).ToList().ForEach(x => x.Read = true);
// base.SaveChanges();
// }
// catch (Exception ex)
// {
// this.HandleError(null, CommonLayer.LookUps.ErrorType.Exception, ex);
// }
// transaction.Commit();
// }
//});
//base.AddWaitingAction(action);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
public void PrepareListUserModel(GenericListModel <UserModel> baseListModel)
{
try
{
//if (!base.UserHasPermision(userModel))
// return;
foreach (UserModel userModel in baseListModel.List)
{
PrepareUserModel(userModel);
userModel.AspNetRolesListItems = dbContext.AspNetRoles.Select(x => new SelectListItem {
Text = x.Name, Value = x.Id, Selected = userModel.RolesIDs.Any(y => y == x.Id)
}).ToList();
}
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
}
public GenericListModel <UserModel> ListUsersWithLastMessageByCurrentUser()
{
GenericListModel <UserModel> baseListModel = new GenericListModel <UserModel>();
try
{
//all users that have conversations with current user
IQueryable <AspNetUser> aspNetUsers = dbContext.AspNetUsers.Where(x =>
x.Id != contextInfo.UserID &&
(
x.Messages.Any(c => c.ToUserID == contextInfo.UserID || c.FromUserID == contextInfo.UserID) ||
x.Messages1.Any(c => c.ToUserID == contextInfo.UserID || c.FromUserID == contextInfo.UserID)
)
);
UserMapper.Map(dbContext, aspNetUsers.ToList(), baseListModel.List);
foreach (UserModel userModel in baseListModel.List)
{
//get last message between two users
LMYFrameWorkMVC.Common.DAL.Message message = dbContext.Messages.Where(x =>
(x.FromUserID == contextInfo.UserID || x.ToUserID == contextInfo.UserID) &&
(x.FromUserID == userModel.Id || x.ToUserID == userModel.Id)
).OrderByDescending(x => x.CreatedAt).FirstOrDefault();
MessageMapper.Map(dbContext, contextInfo.UserID, message, userModel.LastMessageModel);
}
baseListModel.List = baseListModel.List.OrderByDescending(x => x.LastMessageModel.CreatedAt).ToList();
baseListModel.Total = aspNetUsers.Count();
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
public GenericListModel <TruckModel> GetTrucks(Select2Parameters <bool> select2Parameters)
{
GenericListModel <TruckModel> baseListModel = new GenericListModel <TruckModel>();
try
{
IQueryable <Common.DAL.Truck> trucks = prepareSearch(select2Parameters.text);
trucks = trucks.OrderBy(x => x.CreatedAt);
baseListModel.Total = trucks.Count();
trucks = trucks.Skip(select2Parameters.start);
trucks = trucks.Take(select2Parameters.pageSize);
TruckMapper.Map(dbContext, trucks.ToList(), baseListModel.List);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
public ListaViewModel()
{
lstGeric = GenericListModel.GetGenericList();
}
public GenericListModel <TruckModel> GetSearchTrucksList(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <TruckModel> baseListModel = new GenericListModel <TruckModel>();
try
{
IQueryable <Common.DAL.Truck> trucks = prepareSearch(dataTableSearchParameters.search.value);
foreach (JQDTColumnOrder order in dataTableSearchParameters.order)
{
switch (order.column)
{
case 0:
if (order.dir == JQDTColumnOrderDirection.asc)
{
trucks = trucks.OrderBy(c => c.Name);
}
else
{
trucks = trucks.OrderByDescending(c => c.Name);
}
break;
case 1:
if (order.dir == JQDTColumnOrderDirection.asc)
{
trucks = trucks.OrderBy(c => c.OnBuyPrice);
}
else
{
trucks = trucks.OrderByDescending(c => c.OnBuyPrice);
}
break;
case 2:
if (order.dir == JQDTColumnOrderDirection.asc)
{
trucks = trucks.OrderBy(c => c.OnBuyMilage);
}
else
{
trucks = trucks.OrderByDescending(c => c.OnBuyMilage);
}
break;
case 3:
if (order.dir == JQDTColumnOrderDirection.asc)
{
trucks = trucks.OrderBy(c => c.DriverId == null ? "" : c.Driver.Name);
}
else
{
trucks = trucks.OrderByDescending(c => c.DriverId == null ? "" : c.Driver.Name);
}
break;
}
}
baseListModel.Total = trucks.Count();
trucks = trucks.Skip(dataTableSearchParameters.start);
if (dataTableSearchParameters.length != -1)
{
trucks = trucks.Take(dataTableSearchParameters.length);
}
TruckMapper.Map(dbContext, trucks.ToList(), baseListModel.List);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
public ArchiveManagerViewModel(Window window, IArchive archive, string archiveFileName)
{
Window = window;
Archive = archive;
_archiveFileName = archiveFileName;
Entries = new GenericListModel <ArchiveEntryViewModel, ArchiveEntryViewModel>(
archive.Entries.Select(x => new ArchiveEntryViewModel(x)),
Getter, Setter);
OpenCommand = new RelayCommand(o =>
{
Window.DialogResult = true;
Window.Close();
}, o => IsSelected);
ImportCommand = new RelayCommand(o =>
{
var selectedEntry = SelectedValue;
if (selectedEntry == null)
{
return;
}
FileDialog.OnOpen(fileName =>
{
using (var stream = File.OpenRead(fileName))
{
var data = new byte[stream.Length];
stream.Read(data, 0, data.Length);
selectedEntry.ImportData(data);
}
using (var stream = File.Create(_archiveFileName))
archive.Write(stream);
ShowInfoMessageBox("Save imported with success!");
}, Filters);
}, o => IsSelected);
ExportCommand = new RelayCommand(o =>
{
var selectedEntry = SelectedEntry;
if (selectedEntry == null)
{
return;
}
FileDialog.OnSave(fileName =>
{
using (var stream = File.Create(fileName))
{
stream.Write(selectedEntry.Data, 0, selectedEntry.Data.Length);
}
}, Filters, $"{SelectedEntry?.Name ?? "empty save"}.bin", Window);
}, o => !IsSelectedEmpty);
CopyCommand = new RelayCommand(o =>
{
}, o => IsSelected);
PasteCommand = new RelayCommand(o =>
{
}, o => IsSelected);
RenameCommand = new RelayCommand(o =>
{
SingleInputDialog sid = new() { Description = "Please enter a name for the save slot", Text = SelectedEntry?.Name ?? string.Empty };
sid.ShowDialog();
if (sid.DialogResult == true && !string.IsNullOrEmpty(sid.Text))
{
Entries.SelectedValue?.Rename(sid.Text);
}
}, o => !IsSelectedEmpty);
DeleteCommand = new RelayCommand(o =>
{
Entries.SelectedValue?.Erase();
}, o => !IsSelectedEmpty);
}
public SourceView()
{
this.Build();
_eventModel = new EventModel(EventModel.EventModelType.All);
Gtk.TreeViewColumn eventNameCol = new Gtk.TreeViewColumn();
Gtk.CellRenderer rend = new Gtk.CellRendererToggle();
eventNameCol.Title = "Event";
eventNameCol.PackStart(rend, false);
eventNameCol.AddAttribute(rend, "active", (int)EventModel.Columns.Included);
((Gtk.CellRendererToggle)rend).Activatable = true;
((Gtk.CellRendererToggle)rend).Toggled += new Gtk.ToggledHandler(OnIncluded_Toggle);
rend = new Gtk.CellRendererText();
eventNameCol.PackStart(rend, true);
eventNameCol.AddAttribute(rend, "text", (int)EventModel.Columns.Readable);
EventTypeTreeView.AppendColumn(eventNameCol);
EventTypeTreeView.Model = _eventModel;
Gtk.TreeViewColumn buttonCol = new Gtk.TreeViewColumn();
GtkCellRendererButton butRend = new GtkCellRendererButton();
butRend.StockId = "gtk-remove";
buttonCol.PackStart(butRend,true);
Gtk.TreeViewColumn noteCountCol = new Gtk.TreeViewColumn();
rend = new Gtk.CellRendererText();
noteCountCol.Title = "No.";
noteCountCol.PackStart(rend,true);
noteCountCol.SetCellDataFunc(rend, new Gtk.TreeCellDataFunc(ListModelUtil.RenderEventRecordedCount));
EventGroupTreeView.AppendColumn(buttonCol);
EventGroupTreeView.AppendColumn(noteCountCol);
Gtk.TreeSelection selection = EventGroupTreeView.Selection;
selection.Changed += new EventHandler(OnEventGroupSelection_Changed);
_eventGroups = new GenericListModel<GedcomRecordedEvent>();
EventGroupTreeView.Model = _eventGroups.Adapter;
Gtk.TreeViewColumn callNumberCol = new Gtk.TreeViewColumn();
rend = new Gtk.CellRendererText();
callNumberCol.Title = "Call Number";
callNumberCol.PackStart(rend,true);
callNumberCol.AddAttribute(rend, "text", 0);
Gtk.TreeViewColumn mediaTypeCol = new Gtk.TreeViewColumn();
rend = new Gtk.CellRendererText();
mediaTypeCol.Title = "Media Type";
mediaTypeCol.PackStart(rend,true);
mediaTypeCol.AddAttribute(rend, "text", 1);
CallNumberTreeView.AppendColumn(callNumberCol);
CallNumberTreeView.AppendColumn(mediaTypeCol);
RepositoryCitationListModel repoCitationListModel = new RepositoryCitationListModel();
CallNumberTreeView.Model = repoCitationListModel;
selection = CallNumberTreeView.Selection;
selection.Changed += new EventHandler(OnCallNumberSelection_Changed);
// How to handle SourceMediaType.Other ?
// don't include in initial and if the select one is SourceMediaType.Other
// add an item into the dropdown for its value?
// as other isn't really valid this seems like a reasonable idea
Gtk.ListStore mediaTypes = new Gtk.ListStore(typeof(string));
foreach (SourceMediaType mediaType in Enum.GetValues(typeof(SourceMediaType)))
{
if (mediaType != SourceMediaType.Other)
{
Gtk.TreeIter iter = mediaTypes.Append();
mediaTypes.SetValue(iter, 0, mediaType.ToString());
}
}
rend = new Gtk.CellRendererText();
MediaTypeCombo.PackStart(rend,true);
MediaTypeCombo.AddAttribute(rend, "text", 0);
MediaTypeCombo.Model = mediaTypes;
Notebook.Page = 0;
}
public ActionResult Index(GenericListModel<Client> model)
{
PushNavigationItem("Клиенты","/clients");
PushNavigationItem("Список клиентов компании","#");
model.Fetched = CurrentUser.Company.Clients.OrderByDescending(c => c.DateCreated).ToList();
return View(model);
}
public GenericListModel <TruckExpenseModel> GetSearchTruckExpensessList(DataTableSearchParameters <TruckExpenseSearchModel> dataTableSearchParameters)
{
GenericListModel <TruckExpenseModel> baseListModel = new GenericListModel <TruckExpenseModel>();
try
{
//if (!base.TruckExpensesHasPermision(baseListModel))
// return baseListModel;
IQueryable <Common.DAL.TruckExpens> truckExpenses = dbContext.TruckExpenses.OrderBy(x => x.CreatedAt);
if (dataTableSearchParameters.CustomSearchObject != null)
{
if (!string.IsNullOrEmpty(dataTableSearchParameters.CustomSearchObject.AtDateString))
{
dataTableSearchParameters.CustomSearchObject.AtDate = dataTableSearchParameters.CustomSearchObject.AtDateString.ConvertToDateTime();
}
truckExpenses = truckExpenses.Where(x =>
(string.IsNullOrEmpty(dataTableSearchParameters.CustomSearchObject.TruckId) || x.TruckId == dataTableSearchParameters.CustomSearchObject.TruckId) &&
(string.IsNullOrEmpty(dataTableSearchParameters.CustomSearchObject.ExpenseTypeId) || x.ExpenseTypeId == dataTableSearchParameters.CustomSearchObject.ExpenseTypeId) &&
(dataTableSearchParameters.CustomSearchObject.AtDate == null || x.AtDate == dataTableSearchParameters.CustomSearchObject.AtDate.Value)
);
}
if (!string.IsNullOrEmpty(dataTableSearchParameters.search.value))
{
truckExpenses = truckExpenses.Where(x =>
(x.ExpenseTypeId == null || string.IsNullOrEmpty(x.TruckExpensType.Name) || x.TruckExpensType.Name.ToLower().Contains(dataTableSearchParameters.search.value.ToLower())) ||
(x.TruckId == null || string.IsNullOrEmpty(x.Truck.Name) || x.Truck.Name.ToLower().Contains(dataTableSearchParameters.search.value.ToLower())) ||
(x.Price == null || x.Price.ToString().ToLower().Contains(dataTableSearchParameters.search.value.ToLower())) ||
(x.AtDate == null || x.AtDate.ToString().ToLower().Contains(dataTableSearchParameters.search.value.ToLower())) ||
(string.IsNullOrEmpty(x.Notes) || x.Notes.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()))
);
}
foreach (JQDTColumnOrder order in dataTableSearchParameters.order)
{
switch (order.column)
{
case 0:
if (order.dir == JQDTColumnOrderDirection.asc)
{
truckExpenses = truckExpenses.OrderBy(c => c.TruckId == null ? "" : c.Truck.Name);
}
else
{
truckExpenses = truckExpenses.OrderByDescending(c => c.TruckId == null ? "" : c.Truck.Name);
}
break;
case 1:
if (order.dir == JQDTColumnOrderDirection.asc)
{
truckExpenses = truckExpenses.OrderBy(c => c.ExpenseTypeId == null ? "" : c.TruckExpensType.Name);
}
else
{
truckExpenses = truckExpenses.OrderByDescending(c => c.ExpenseTypeId == null ? "" : c.TruckExpensType.Name);
}
break;
case 2:
if (order.dir == JQDTColumnOrderDirection.asc)
{
truckExpenses = truckExpenses.OrderBy(c => c.Price);
}
else
{
truckExpenses = truckExpenses.OrderByDescending(c => c.Price);
}
break;
case 3:
if (order.dir == JQDTColumnOrderDirection.asc)
{
truckExpenses = truckExpenses.OrderBy(c => c.AtDate);
}
else
{
truckExpenses = truckExpenses.OrderByDescending(c => c.AtDate);
}
break;
}
}
baseListModel.Total = truckExpenses.Count();
truckExpenses = truckExpenses.Skip(dataTableSearchParameters.start);
if (dataTableSearchParameters.length != -1)
{
truckExpenses = truckExpenses.Take(dataTableSearchParameters.length);
}
TruckExpenseMapper.Map(dbContext, truckExpenses.ToList(), baseListModel.List);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
public ArchiveManagerViewModel(IArchive archive)
{
Archive = archive;
Entries = new GenericListModel <ArchiveEntryViewModel, ArchiveEntryViewModel>(
archive.Entries.Select(x => new ArchiveEntryViewModel(x)),
Getter, Setter);
OpenCommand = new RelayCommand(o =>
{
Window.DialogResult = true;
Window.Close();
}, o => IsSelected);
ImportCommand = new RelayCommand(o =>
{
var selectedEntry = SelectedValue;
if (selectedEntry == null)
{
return;
}
FileDialog.OnOpen(fileName =>
{
using (var stream = File.OpenRead(fileName))
{
var data = new byte[stream.Length];
stream.Read(data, 0, data.Length);
selectedEntry.ImportData(data);
}
ShowInfoMessageBox("Save imported with success!");
}, Filters, parent: Window);
}, o => IsSelected);
ExportCommand = new RelayCommand(o =>
{
var selectedEntry = SelectedEntry;
if (selectedEntry == null)
{
return;
}
FileDialog.OnSave(fileName =>
{
using (var stream = File.Create(fileName))
{
stream.Write(selectedEntry.Data, 0, selectedEntry.Data.Length);
}
}, Filters, $"{SelectedEntry?.Name ?? "empty save"}.bin", Window);
}, o => !IsSelectedEmpty);
CopyCommand = new RelayCommand(o =>
{
}, o => IsSelected);
PasteCommand = new RelayCommand(o =>
{
}, o => IsSelected);
DeleteCommand = new RelayCommand(o =>
{
Entries.SelectedValue?.Erase();
}, o => !IsSelectedEmpty);
}
public GenericListModel <USAStateModel> GetSearchUSAStatesList(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <USAStateModel> baseListModel = new GenericListModel <USAStateModel>();
try
{
//if (!base.USAStateHasPermision(baseListModel))
// return baseListModel;
IQueryable <USAState> uSAStates = dbContext.USAStates.OrderBy(x => x.CreatedAt);
if (!string.IsNullOrEmpty(dataTableSearchParameters.search.value))
{
uSAStates = uSAStates.Where(x =>
x.Name.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()) ||
x.StateCode.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()) ||
x.Notes.ToLower().Contains(dataTableSearchParameters.search.value.ToLower())
);
}
foreach (JQDTColumnOrder order in dataTableSearchParameters.order)
{
switch (order.column)
{
case 0:
if (order.dir == JQDTColumnOrderDirection.asc)
{
uSAStates = uSAStates.OrderBy(c => c.Name);
}
else
{
uSAStates = uSAStates.OrderByDescending(c => c.Name);
}
break;
case 1:
if (order.dir == JQDTColumnOrderDirection.asc)
{
uSAStates = uSAStates.OrderBy(c => c.StateCode);
}
else
{
uSAStates = uSAStates.OrderByDescending(c => c.StateCode);
}
break;
}
}
baseListModel.Total = uSAStates.Count();
uSAStates = uSAStates.Skip(dataTableSearchParameters.start);
if (dataTableSearchParameters.length != -1)
{
uSAStates = uSAStates.Take(dataTableSearchParameters.length);
}
USAStateMapper.Map(dbContext, uSAStates.ToList(), baseListModel.List);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
public GenericListModel <UserModel> GetSearchUsersList(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <UserModel> baseListModel = new GenericListModel <UserModel>();
try
{
//if (!base.UserHasPermision(baseListModel))
// return baseListModel;
IQueryable <AspNetUser> aspNetUsers = dbContext.AspNetUsers.OrderBy(x => x.CreatedAt);
if (!string.IsNullOrEmpty(dataTableSearchParameters.search.value))
{
aspNetUsers = aspNetUsers.Where(x =>
x.UserName.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()) ||
x.EnglishName.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()) ||
x.ArabicName.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()) ||
x.Email.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()) ||
x.PhoneNumber.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()) ||
x.AspNetRoles.Any(a => a.Name.ToLower().Contains(dataTableSearchParameters.search.value.ToLower()))
);
}
foreach (JQDTColumnOrder order in dataTableSearchParameters.order)
{
switch (order.column)
{
case 0:
if (order.dir == JQDTColumnOrderDirection.asc)
{
aspNetUsers = aspNetUsers.OrderBy(c => c.UserName);
}
else
{
aspNetUsers = aspNetUsers.OrderByDescending(c => c.UserName);
}
break;
case 1:
if (order.dir == JQDTColumnOrderDirection.asc)
{
aspNetUsers = CommonLayer.Helpers.Utilites.GetLocalizedOrderBy(aspNetUsers.OrderBy(c => c.EnglishName), aspNetUsers.OrderBy(c => c.ArabicName));
}
else
{
aspNetUsers = CommonLayer.Helpers.Utilites.GetLocalizedOrderBy(aspNetUsers.OrderByDescending(c => c.EnglishName), aspNetUsers.OrderByDescending(c => c.ArabicName));
}
break;
case 2:
if (order.dir == JQDTColumnOrderDirection.asc)
{
aspNetUsers = aspNetUsers.OrderBy(c => c.Email);
}
else
{
aspNetUsers = aspNetUsers.OrderByDescending(c => c.Email);
}
break;
case 3:
if (order.dir == JQDTColumnOrderDirection.asc)
{
aspNetUsers = aspNetUsers.OrderBy(c => c.PhoneNumber);
}
else
{
aspNetUsers = aspNetUsers.OrderByDescending(c => c.PhoneNumber);
}
break;
}
}
baseListModel.Total = aspNetUsers.Count();
aspNetUsers = aspNetUsers.Skip(dataTableSearchParameters.start);
if (dataTableSearchParameters.length != -1)
{
aspNetUsers = aspNetUsers.Take(dataTableSearchParameters.length);
}
UserMapper.Map(dbContext, aspNetUsers.ToList(), baseListModel.List);
PrepareListUserModel(baseListModel);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
