Developer application (Marwan)
Hello,
Name: Marwan Abu Ahmad
Age: 26
Languages (Programming and/or other):
English - Fluent
Hebrew - Fluent
Arabic - Mother Language
Coding languages:
C# ASP.Net Core , ASP.Net Core Web Api <=== (Strongest)
C
Python
Java
JavaScript
HTML
CSS
TypeScript
SQL
Skills / Experience:
Currently working in a High-Tech company in my home town called epsilon delta,
I work as a backend Developer for the company for a year now, before that I never worked in this lane of work,
I have a diploma as a practical software engineer, I'm very passionate about it I love what I do so much.
I have played Gunz a long time since Ijji and since I was at school so we are talking about 10 years ago, I quitted it due to going to university and working at the same time,
I tried once to make a private server of Gunz of my own and I succeeded of making it work I also made few maps of my own in GTKRadiant (I don't know if it is still used until now) but closed the server due to insufficient funds and insufficient time and staff to keep it up and running.
Company decided to move its backend from Visual Basic to ASP.Net Core
I write the business logic and services and I also write the APIs for them.
I'm a very quick self learner , I have excellent communication skills and I'm a perfect team player
Proof of work:
API Controller :
Code:
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Services;
using SharedClasses.DTO.TokenDTOs;
using SharedClasses.DTO;
using SharedClasses.Handlers;
using Services.Interfaces;
using MainProgram.BL;
using Repositories.Interfaces;
using System.Net;
namespace MainProgram.Controllers;
[Route("api/[controller]")]
[ApiController]
public class UsersController : ControllerBase
{
private readonly PerformanceHandler ph = new PerformanceHandler();
private readonly responseHandler rh;
private readonly ErrorHandler er = new ErrorHandler();
//private readonly IsharedVariablesService variablesService;
private readonly IEnterProgLogService progLogService;
private readonly IUserService usersService;
private readonly ItblUserPermsService userPermissionService;
private readonly IUserDepartmentService userDepService;
public UsersController(
/*IsharedVariablesService sharedVariableService,*/
IEnterProgLogService enterProgLogService,
IUserService userService,
ItblUserPermsService userPermsService,
IBranchesService branchService,
IDepartmentsService departmentService, IUserDepartmentService userDepService)
{
//this.variablesService = sharedVariableService;
this.progLogService = enterProgLogService;
this.usersService = userService;
this.userPermissionService = userPermsService;
this.userDepService = userDepService;
this.rh = new responseHandler(
null,
branchService,
userService,
userPermsService,
departmentService,
enterProgLogService,
null,null,null, userDepService
/*sharedVariableService*/);
}
private TokenValidation tokenInvalid()
{
TokenValidation token = new TokenValidation();
token.IsToken = false;
this.HttpContext.Response.StatusCode = StatusCodeHandler.unAuthorized();
return token;
}
[HttpPost("deleteUserDepartment")]
public IActionResult deleteUserDepartment(TokenUserDepParam data)
{
string msg = "";
IActionResult response;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(data.token.token))
{
var isAdminResponse = usersService.isAdminUser(progLogService.userID);//Check if user requested to do the function is admin or not.
if (isAdminResponse.IsAdmin)
{
var result = userDepService.deleteUserDepartment(data.UserDep.UserId,data.UserDep.DepartmentId);
if (result)
response = Ok(rh.createResponse(StatusCodeHandler.statusCode(), MessageHandler.DataDeleted(), result));
else response = BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), MessageHandler.DeleteFail(), result));
}//If
else response = Forbid(rh.createResponse(StatusCodeHandler.forbidden(), MessageHandler.NotAdmin(), null));
}//If
else
{
var res = tokenInvalid();
response = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}//Else
ph.FunctionFinish();
ph.PerformanceToLog("addOrUpdateUserDepartment");
return response;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "addOrUpdateUserDepartment", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
[HttpPost("addOrUpdateUserDepartment")]
public IActionResult addOrUpdateUserDepartment(TokenUserDepBoolParam data)
{
string msg = "";
IActionResult response;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(data.token.token))
{
var isAdminResponse = usersService.isAdminUser(progLogService.userID);//Check if user requested to do the function is admin or not.
if (isAdminResponse.IsAdmin)
{
var result = userDepService.addOrUpdateUserDepartment(data.UserDep, ref msg, data.isAdd);
if (result)
response = Ok(rh.createResponse(StatusCodeHandler.statusCode(), msg, result));
else response = BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), msg, result));
}//If
else response = Forbid(rh.createResponse(StatusCodeHandler.forbidden(), MessageHandler.NotAdmin(), null));
}//If
else
{
var res = tokenInvalid();
response = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}//Else
ph.FunctionFinish();
ph.PerformanceToLog("addOrUpdateUserDepartment");
return response;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "addOrUpdateUserDepartment", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
[HttpPost("getUserDepartments")]
public IActionResult getUserDepartments(TokenIndxParam data)
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(data.token.token))
{
result = Ok(rh.createResponse(StatusCodeHandler.statusCode(), "", userDepService.getUserDepartments(data.indx)));
}
else
{
var res = tokenInvalid();
result = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}
ph.FunctionFinish();
ph.PerformanceToLog("getUserDepartments");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "getUserDepartments", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
[HttpPost("updateUserSignature")]
public IActionResult updateUserSignature(TokenIndxStringParam data)
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(data.token.token))
{
var response = usersService.updateUserSignature(data.Indx, data.Name);
if (response)
result = Ok(rh.createResponse(StatusCodeHandler.statusCode(), MessageHandler.SignatureUpdated(), response));
else result = BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), MessageHandler.ErrSignatureUpdate(), response));
}
else
{
var res = tokenInvalid();
result = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}
ph.FunctionFinish();
ph.PerformanceToLog("updateUserSignature");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "updateUserSignature", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
[HttpPost("getUserSignature")]
public IActionResult getUserSignature(TokenIndxParam data)
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(data.token.token))
{
result = Ok(rh.createResponse(StatusCodeHandler.statusCode(), "", usersService.getUserSignature(data.indx)));
}
else
{
var res = tokenInvalid();
result = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}
ph.FunctionFinish();
ph.PerformanceToLog("getUserSignature");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "getUserSignature", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
[HttpPost("getUserSettings")]
public IActionResult getUserSettings(Token token)
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(token.token))
{
result = Ok(rh.createResponse(StatusCodeHandler.statusCode(), "", usersService.getUserTblSetting(progLogService.userID)));
}
else
{
var res = tokenInvalid();
result = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}
ph.FunctionFinish();
ph.PerformanceToLog("getUserSettings");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "getUserSettings", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
[HttpPost("isAdminUser")]
public IActionResult isAdmin(Token token)
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(token.token))
{
result = Ok(rh.createResponse(StatusCodeHandler.statusCode(), "", usersService.isAdminUser(progLogService.userID)));
}
else
{
var res = tokenInvalid();
result = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}
ph.FunctionFinish();
ph.PerformanceToLog("isAdminUser");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "isAdminUser", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
/// <summary>
/// Function to kick an online user
/// </summary>
/// <param name="data">Data contains the requisting user token and the user token desired to be kicked from the app.</param>
/// <returns>boolean if the function succeded</returns>
[HttpPost("kickUser")]
public IActionResult kickUser([FromBody]TokenIndxParam data)
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(data.token.token))
{
result = Ok(rh.createResponse(StatusCodeHandler.statusCode(), "", progLogService.kickUser(data.indx)));
}
else
{
var res = tokenInvalid();
result = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}
ph.FunctionFinish();
ph.PerformanceToLog("kickUser");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "kickUser", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
/// <summary>
/// Function that gets all the data needed for the data entry home page.
/// </summary>
/// <param name="token">User logged in token.</param>
/// <returns>Response that contains all users and branches from the database, a message and the http request Code.</returns>
[HttpPost("getUsersforDataEntry")]
public IActionResult getUsersForDataEntry([FromBody]Token token)
//gets users for data entry page along with the branches
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(token.token))
{
if (usersService.isAdminUser(progLogService.userID).IsAdmin)
if(usersService.canEnterUsers(progLogService.userID))
result = Ok(rh.createResponse(StatusCodeHandler.statusCode(), MessageHandler.DataRetrieved(), rh.createUsersBranchesResponse()));
else result = Problem(
statusCode: 403,
detail: rh.createResponse(StatusCodeHandler.forbidden(), MessageHandler.CannotEnterUsers(), null));
else result = Problem(
statusCode: 403,
detail: rh.createResponse(StatusCodeHandler.forbidden(), MessageHandler.NotAdmin(), null));
}
else
{
var tokenCheck = tokenInvalid();
result = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), tokenCheck));
}
ph.FunctionFinish();
ph.PerformanceToLog("getUsersForDataEntry");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "getUsersForDataEntry", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
/// <summary>
/// Function to delete a certain user by sending its indx.
/// </summary>
/// <param name="token">User logged in token.</param>
/// <param name="indx">User indx that is desired to remove.</param>
/// <returns>Response contains a boolean value, a message and the http request Code.</returns>
[HttpPost("deleteUser")]
public IActionResult deleteUser([FromBody] TokenIndxParam data)
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(data.token.token))
{
if (usersService.isAdminUser(progLogService.userID).IsAdmin)
result = Ok(rh.createResponse(StatusCodeHandler.statusCode(), MessageHandler.DataDeleted(), usersService.deleteUserByIndx(data.indx)));
else result = Forbid(rh.createResponse(StatusCodeHandler.forbidden(), MessageHandler.NotAdmin(), null));
}
else
{
var res = tokenInvalid();
result = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}
ph.FunctionFinish();
ph.PerformanceToLog("deleteUser");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "deleteUser", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
/// <summary>
/// Function to get all the data needed in the add user page.
/// </summary>
/// <param name="token">User logged in token.</param>
/// <returns>Languages,Branches,Categories and user types.</returns>
[HttpPost("getDataForAddUser")]
public IActionResult getDataForAddUser([FromBody] Token token)
//gets the data for the add user page..
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(token.token))
{
if (usersService.isAdminUser(progLogService.userID).IsAdmin)
result = Ok(rh.createResponse(StatusCodeHandler.statusCode(), MessageHandler.DataRetrieved(), rh.createAddUserResponse()));
else result = Forbid(rh.createResponse(StatusCodeHandler.forbidden(), MessageHandler.NotAdmin(), null));
}
else
{
var res = tokenInvalid();
result = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}
ph.FunctionFinish();
ph.PerformanceToLog("getDataForAddUser");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "getDataForAddUser", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
/// <summary>
/// Function to get the data needed for the edit user page.
/// </summary>
/// <param name="token">User logged in token.</param>
/// <param name="indx">User indx to get its data.</param>
/// <returns>User details,Languages,Branches,Categories,User Types ,User settings , Departments and user permissions.</returns>
[HttpPost("getDataForEditUser")]
public IActionResult getDataEditUser([FromBody] TokenIndxParam data)
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(data.token.token))
{
if (usersService.isAdminUser(progLogService.userID).IsAdmin)
result = Ok(
rh.createResponse(
StatusCodeHandler.statusCode(),
MessageHandler.DataRetrieved(),
rh.createEditUserResponse(data.indx)));
else result = Forbid(rh.createResponse(StatusCodeHandler.forbidden(), MessageHandler.NotAdmin(), null));
}
else
{
var res = tokenInvalid();
result = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}
ph.FunctionFinish();
ph.PerformanceToLog("getDataForEditUser");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "getDataForEditUser", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
/// <summary>
/// Function to get all the online users that exists in the app now.
/// </summary>
/// <param name="token">User logged in token</param>
/// <returns>a list of online users.</returns>
[HttpPost("getOnlineUsers")]
public IActionResult getOnlineUsers([FromBody] Token token)
{
IActionResult result;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(token.token))
{
result = Ok(
rh.createResponse(
StatusCodeHandler.statusCode(),
MessageHandler.DataRetrieved(),
usersService.getOnlineUsers()));
}
else
{
var res = tokenInvalid();
result = Unauthorized(
rh.createResponse(
StatusCodeHandler.unAuthorized(),
MessageHandler.InvalidToken(),
res));
}
ph.FunctionFinish();
ph.PerformanceToLog("getOnlineUsers");
return result;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "getOnlineUsers", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
/// <summary>
/// Function to add or update a user in the database.
/// </summary>
/// <param name="token">User logged in token</param>
/// <param name="userDetails">User details that you wanna update</param>
/// <returns>A response contains the http request code, the data you need and the message</returns>
[HttpPost("addOrUpdateUser")]
public IActionResult addOrUpdateUser([FromBody] AddOrUpdateUserVariable userDetails)
{
string msg = "";
IActionResult response;
try
{
ph.FunctionBegin();
if (progLogService.validateToken(userDetails.token.token))
{
var isAdminResponse = usersService.isAdminUser(progLogService.userID);//Check if user requested to do the function is admin or not.
if (isAdminResponse.IsAdmin)
{
if (userDetails.userToAdd.Indx != null && userDetails.userToAdd.Indx > 0)
{
var result = usersService.updateUser(userDetails.userToAdd, ref msg);//Updates user details
if (!result)
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), msg, null));
var permsResult = userPermissionService.updateUserPermissionsList(userDetails.permissionsToAdd);//Updates user permissions.
response = Ok(rh.createResponse(StatusCodeHandler.statusCode(), msg, result && permsResult));
}//If
else
{
var insertResponse = usersService.insertUser(userDetails.userToAdd, ref msg);
if (insertResponse == null)
{
response = BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), msg, insertResponse));
}//If
else
{
response = Ok(rh.createResponse(StatusCodeHandler.statusCode(), msg, insertResponse));
}//Else
}//Else
}//If
else response = Forbid(rh.createResponse(StatusCodeHandler.forbidden(), MessageHandler.NotAdmin(), null));
}//If
else
{
var res = tokenInvalid();
response = Unauthorized(rh.createResponse(StatusCodeHandler.unAuthorized(), MessageHandler.InvalidToken(), res));
}//Else
ph.FunctionFinish();
ph.PerformanceToLog("addOrUpdateUser");
return response;
}
catch (Exception ex)
{
er.writeToErrorLog(MessageHandler.ProjectName(), MessageHandler.DataEntry(), "addOrUpdateUser", ex);
return BadRequest(rh.createResponse(StatusCodeHandler.badRequest(), ex.Message, null));
}
}
}
Main Repository Functionality:
Code:
using EFDal.Models;
using Microsoft.EntityFrameworkCore.ChangeTracking;
using Repositories;
using Repositories.Interfaces;
using Repositories.MainRepositories;
using SDEFDal.Models;
using System.Collections.Generic;
namespace Repositories.MainRepositories;
public abstract class MDbRepository<TEntity, MDbContex> : IRepository<TEntity>
where TEntity : class
where MDbContex : MDbContext
{
protected readonly MDbContex Db;
protected MDbRepository(MDbContex context)
{
Db = context;
}
public virtual bool delete(int indx)
{
try
{
var entityToRemove = Db.Set<TEntity>().Find(indx);
var res = Db.Set<TEntity>().Remove(entityToRemove);
if (res.State.ToString() == "Deleted")
return true;
else return false;
}
catch (Exception ex)
{
throw;
}
}
public virtual List<TEntity> getAll()
{
try
{
return Db.Set<TEntity>().ToList();
}
catch (Exception ex)
{
throw;
}
}
public virtual TEntity getBy(int indx)
{
try
{
return Db.Set<TEntity>().Find(indx);
}
catch (Exception ex)
{
throw;
}
}
public virtual bool insert(TEntity entity)
{
try
{
var res = Db.Set<TEntity>().Add(entity);
if (res.State.ToString() == "Added")
return true;
else return false;
}
catch (Exception ex)
{
throw;
}
}
public virtual void save()
{
Db.SaveChanges();
}
public virtual bool update(TEntity entity)
{
try
{
var res = Db.Set<TEntity>().Update(entity);
if (res.State.ToString() == "Modified")
return true;
else return false;
}
catch (Exception ex)
{
throw;
}
}
}
Custom Repository functionality:
Code:
using EFDal.Models;
using Microsoft.Identity.Client;
using Microsoft.IdentityModel.Tokens;
using Microsoft.EntityFrameworkCore;
using SharedClasses;
using Repositories.Interfaces;
using SharedClasses.Handlers;
using SharedClasses.Selectors;
using SharedClasses.DTO;
using Repositories.MainRepositories;
using EFDal.Views;
using System.Net.Sockets;
namespace Repositories;
public class UsersRepository : MDbRepository<User,MDbContext> , IUsersRepository
{
private MDbContext db;
private List<IndxName> Departments;
public UsersRepository(MDbContext db) : base(db)
{
this.db = db;
}
public List<IndxName> getClerks(bool isBlocked,int companyID, int branchID)
{
try
{
var mainBranchVar = db.WebVariables.Where(v => v.Company == companyID && v.Branch == branchID && v.WebSiteCode.ToUpper() == "tco".ToUpper()).FirstOrDefault();
var isInMainBranch = (SharedClasses.SharedFunctions.ifNullOrEmpty(mainBranchVar == null ? "N" : mainBranchVar.VariableValue ,"N").ToUpper() == "Y".ToUpper());
var branchIndxes = db.Branches.Where(b => b.Company == companyID && !isInMainBranch ? b.Indx == branchID : true).Select(c => c.Indx).ToList();
var clerks = (from users in db.Users
where branchIndxes.Contains((int)users.Branch)
where isBlocked ? users.EnterTheProgram == true : true
orderby users.UserName
select new IndxName
{
Name = users.UserName,
Indx = users.Indx
}).ToList<IndxName>();
return clerks;
}
catch
{
throw;
}
}
public UserSettingsSelector? getUserSettings(int indx)
{
UserSettingsSelector? dataToReturn = new UserSettingsSelector();
try
{
dataToReturn = db.Users.Where(u => u.Indx == indx).Select(u => new UserSettingsSelector
{
EnterTheProgram = u.EnterTheProgram,
EnterData = u.EnterData,
EnterUsers = u.EnterUsers,
EnterReservations = u.EnterReservations,
Enterallotment = u.Enterallotment,
EnterDohot = u.EnterDohot,
EnterQueries = u.EnterQueries,
CanConfirm = u.CanConfirm,
EnterAccounting = u.EnterAccounting,
EnterPriceListForHotel = u.EnterPriceListForHotel,
EnterNazarenePackages = u.EnterNazarenePackages,
EnterBusManagment = u.EnterBusManagment,
EnterFlights = u.EnterFlights,
EnterCountries = u.EnterCountries,
EnterRoomType = u.EnterRoomType,
EnterBusPrices = u.EnterBusPrices,
ChangeConstants = u.ChangeConstants,
EnterHotelNotes = u.EnterHotelNotes,
EnterServicePrices = u.EnterServicePrices,
EnterAgents = u.EnterAgents,
EnterPromotions = u.EnterPromotions,
EnterMaxDiscount = u.EnterMaxDiscount,
EnterShuttlePrices = u.EnterShuttlePrices,
EnterVisaPrices = u.EnterVisaPrices,
CanCheckServices = u.CanCheckServices,
CanSeeNetPrice = u.CanSeeNetPrice,
MakeConfCode = u.MakeConfCode,
EnterIncoming = u.EnterIncoming,
CanAllowResvs = u.CanAllowResvs,
CanSeeSremarks = u.CanSeeSremarks,
CanGiveResvCode = u.CanGiveResvCode,
CanGiveVchcode = u.CanGiveVchcode,
CanControlResvs = u.CanControlResvs,
CanGiveOpenCode = u.CanGiveOpenCode,
CanGiveDisCode = u.CanGiveDisCode,
CanChangeVchfromVchscreen = u.CanChangeVCHfromVCHscreen
}).FirstOrDefault();
return dataToReturn;
}
catch (Exception ex)
{
throw;
}
}
public IEnumerable<User> getAll(bool? isActive = null)
{
try
{
if (isActive != null && isActive == true)
return db.Users.Where(u => u.EnterTheProgram == true).ToList().OrderBy(u => u.UserName);
else if (isActive != null && isActive == false)
return db.Users.Where(u => u.EnterTheProgram == false).ToList().OrderBy(u => u.UserName);
return db.Users.ToList().OrderBy(u => u.UserName);
}
catch (Exception ex)
{
throw;
}
}
public IEnumerable<IndxName> getAllFreeLancers()
{
try
{
List<IndxName> users = db.Users
.Where(user => user.IsFreeLancer == true)
.Select(user => new IndxName
{
Name = user.UserName,
Indx = user.Indx
})
.OrderBy(user => user.Name).ToList();
if (users.Count > 0)
return users;
else throw new Exception("There are no free lancer users.");
}
catch (Exception ex)
{
throw;
}
}
public IEnumerable<AdvancedUser> getAdvancedUsers(int branchIndx, int userIndx, string? userName, bool? isBlocked = false)
//Previous Name: ShowUsers
//function that gets 4 parameters isblocked branchIndx userIndx and username
//returns a list of user with 3 columns added at the end of the table (BranchName , LanguageName ,UserTypeName)
{
try
{
List<AdvancedUser> users = (from User in db.Users
join branch in db.Branches on User.Branch equals branch.Indx into newBTable
from subBranch in newBTable.DefaultIfEmpty() // does the left join to the branches table
join languages in db.Languages on User.Lang equals languages.Indx into newLTable
from subLanguages in newLTable.DefaultIfEmpty() // does the left join to the languages table
join docketType in db.DocketTypes on User.UserType equals docketType.Indx
where (branchIndx != null && branchIndx > 0 ? User.Branch == branchIndx : true) &&
(userIndx != null && userIndx > 0 ? User.Indx == userIndx : true) &&
(!(bool)isBlocked ? User.EnterTheProgram == true : true) &&
(userName != null ? User.UserName == userName : true)
orderby User.Branch ascending, User.UserName ascending // order the data by the branch index first then by the user name
select new AdvancedUser
{
Indx = User.Indx,
UserName = User.UserName,
Password = User.Password,
EnterTheProgram = User.EnterTheProgram,
EnterData = User.EnterData,
EnterUsers = User.EnterUsers,
EnterReservations = User.EnterReservations,
Enterallotment = User.Enterallotment,
EnterDohot = User.EnterDohot,
EnterQueries = User.EnterQueries,
CanConfirm = User.CanConfirm,
EnterAccounting = User.EnterAccounting,
EnterPriceListForHotel = User.EnterPriceListForHotel,
EnterNazarenePackages = User.EnterNazarenePackages,
EnterBusManagment = User.EnterBusManagment,
EnterFlights = User.EnterFlights,
EnterCountries = User.EnterCountries,
EnterRoomType = User.EnterRoomType,
EnterBusPrices = User.EnterBusPrices,
ChangeConstants = User.ChangeConstants,
EnterHotelNotes = User.EnterHotelNotes,
EnterServicePrices = User.EnterServicePrices,
EnterAgents = User.EnterAgents,
EnterMaxDiscount = User.EnterMaxDiscount,
EnterShuttlePrices = User.EnterShuttlePrices,
EnterVisaPrices = User.EnterVisaPrices,
EnterIncoming = User.EnterIncoming,
EnterPromotions = User.EnterPromotions,
CanCheckServices = User.CanCheckServices,
CanSeeNetPrice = User.CanSeeNetPrice,
MakeConfCode = User.MakeConfCode,
CanAllowResvs = User.CanAllowResvs,
CanSeeSremarks = User.CanSeeSremarks,
CanGiveResvCode = User.CanGiveResvCode,
CanGiveVchcode = User.CanGiveVchcode,
CanControlResvs = User.CanControlResvs,
CanGiveOpenCode = User.CanGiveOpenCode,
CanGiveDisCode = User.CanGiveDisCode,
UserCatagory = User.UserCatagory,
ConfCode = User.ConfCode,
Branch = User.Branch,
Lang = User.Lang,
UserType = User.UserType,
UserCategory2 = User.UserCategory2,
OpenDate = User.OpenDate,
Email = User.Email,
DomainLogin = User.DomainLogin,
FinAccIndx = User.FinAccIndx,
AccIndx = User.AccIndx,
Phone = User.Phone,
Mobile = User.Mobile,
Skype = User.Skype,
IsFreeLancer = User.IsFreeLancer,
CanChangeVchfromVchscreen = User.CanChangeVCHfromVCHscreen,
BranchName = subBranch.Branch1,
LanguageName = subLanguages.Lang,
UserTypeName = docketType.DocketType1
}).ToList();
if (users.Count > 0)
return users;
else throw new Exception("There are no such users.");
}
catch (Exception ex)
{
throw;
}
}
public bool updateUserSignature(int indx, string signature)
{
try
{
var user = db.Users.Where(u=>u.Indx == indx).FirstOrDefault();
if (user != null)
{
user.Signature = signature;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return true;
}
else return false;
}
catch
{
throw;
}
}
public string getUserSignature(int indx)
{
try
{
return db.Users.Where(u => u.Indx == indx).Select(u => u.Signature).FirstOrDefault();
}
catch
{
throw;
}
}
private static string getDepartmentName(List<IndxName> Departments , int indx)
{
try
{
return Departments.Where(d=>d.Indx == indx).Select(d=>d.Name).FirstOrDefault();
}
catch
{
throw;
}
}
public IEnumerable<UsersForDataEntry> getForDataEntry()
//Previous name: ShowUsersForDataEntry
// Function that returns the data of users for the data entry
{
try
{
this.Departments = db.Departments.Select(d=> new IndxName { Indx = d.Indx , Name = d.DepartmentName }).ToList();
var userDepartments = db.UserDepartments.GroupBy(dv => dv.UserId)
.ToDictionary(group => group.Key,
group => group.Where(g => g.IsMain == true).FirstOrDefault() ?? group.FirstOrDefault());
var qryJoin = (from User in db.Users
join branch in db.Branches on User.Branch equals branch.Indx into newBTable
from subBranch in newBTable.DefaultIfEmpty() // does the left join to the branches table
//join departments in db.UserDepartments on User.Indx equals departments.UserId
join departments2 in db.UserDepartments on User.Indx equals departments2.UserId into newDepartments2
//join department in db.Departments on subDepartments.DepartmentId equals department.Indx// into newDTable
//from subDepartment in newDTable.DefaultIfEmpty() // does the left join to the departments table
orderby subBranch.Indx, User.UserName ascending // order the data by the branch index first then by the user name
select new UsersForDataEntry
{
Indx = User.Indx,
UserName = User.UserName,
Password = User.Password,
UserCatagory = User.UserCatagory,
Email = User.Email,
EnterTheProgram = User.EnterTheProgram,
BranchName = subBranch.Branch1, // name of the new column in the new table of data
DepartmentName = newDepartments2.ToList().Count() > 0 ? getDepartmentName(this.Departments, userDepartments[User.Indx].DepartmentId) : "", // name of the new column in the new table of data
Signature = User.Signature
}).ToList();
if (qryJoin.Count > 0)
return qryJoin;
else throw new Exception("There are no users in the database.");
}
catch (Exception ex)
{
throw;
}
}
public IEnumerable<User> getByBranchId(int branchIndx, bool? isActive = null)
{
try
{
if (isActive != null && isActive == true)
return db.Users.Where(u => u.Branch == branchIndx && u.EnterTheProgram == true).ToList();
else if (isActive != null && isActive == false)
return db.Users.Where(u => u.Branch == branchIndx && u.EnterTheProgram == false).ToList();
return db.Users.Where(u => u.Branch == branchIndx).ToList();
}
catch (Exception ex)
{
throw;
}
}
public User getBy(int? indx, string? username = null)
{
try
{
if (indx.HasValue)
return db.Users.Where(u => u.Indx == indx).FirstOrDefault();
else if (!username.IsNullOrEmpty())
return db.Users.Where(u => u.UserName == username).FirstOrDefault();
return null;
}
catch (Exception ex)
{
throw;
}
}
public List<OnlineUsersSelector> getOnlineUsers()
{
try
{
var onlineUsersQuery = (from userEnterProLog in db.UserEnterProgLogs
join users in db.Users on userEnterProLog.UserId equals users.Indx into newEnterProgLog
where DateTime.Now < userEnterProLog.ValidTime
where userEnterProLog.ExitTime == null
from newUsers in newEnterProgLog.DefaultIfEmpty()
orderby userEnterProLog.UserId descending, userEnterProLog.CurrentTime descending
select new OnlineUsersSelector
{
Indx = newUsers.Indx,
UserName = newUsers.UserName,
Email = newUsers.Email,
LatestAction = userEnterProLog.CurrentTime,
ValidTime = userEnterProLog.ValidTime
}).ToList();
return onlineUsersQuery;
}
catch (Exception ex)
{
throw;
}
}
public SharedClasses.Selectors.IndxName insert(User user)
{
try
{
var entity = db.Users.Add(user).Entity;
db.SaveChanges();
SharedClasses.Selectors.IndxName dataToReturn = new SharedClasses.Selectors.IndxName
{
Indx = entity.Indx,
Name = entity.UserName
};
return dataToReturn;
}
catch (Exception ex)
{
throw;
}
}
public List<User> getAdminUsers()
{
try
{
return db.Users.Where(u=>u.UserCategory2 == "Resv Manager").ToList();
}
catch
{
throw;
}
}
public List<User> getEmails(string email, int indx)
{
try
{
return db.Users.Where(u => u.Email == email && u.Indx != indx).ToList();
}
catch
{
throw;
}
}
}
Is all proof of work your own work?
Yes all of the code I have given is a code that i wrote from 0,
I have started a new project when i first came into the company and now i have written alot of classes and DTOs of my own
Alot of controllers I written from empty controllers
nothing I have given is brought from the internet or another sources
Closing:
If you decide to proceed with me, I can show the whole project.
Im doing this out of love for the game, and as a hobby not more.
I already work as a developer and i love my work, its perfectly fine with me if you guys decide not to proceed with me.
Thanks,
