public ActionResult List(int? page, string search, int? size)
{
if (size == null)
size = 40;
if (size > 100)
size = 100;
if (page == null)
page = 0;
int total;
var userSearch = new UserSearch();
if (!string.IsNullOrEmpty(search))
{
search = search + "%";
userSearch.Name = search;
userSearch.Email = search;
userSearch.Login = search;
userSearch.Phone = search;
userSearch.Junction = JunctionType.Or;
}
userSearch.Org = OrnamentContext.MemberShip.CurrentUser().Org;
IList<User> userResult = _userDao.Search(userSearch, page.Value, size.Value, out total);
var result = new
{
data = new ArrayList(),
TotalRecords = total
};
foreach (User user in userResult)
{
result.data.Add(new
{
user.Id,
user.Name,
user.LoginId,
user.Contact.Email,
user.Security.IsLocked,
user.Contact.EmailVerified,
Deny = user.IsDeny,
LastActivityDate =
user.Other.LastActivityDate != null
? user.Other.LastActivityDate.Value.ToString("yyyy-MM-dd HH:mm:ss")
: "",
});
}
return Json(result, JsonRequestBehavior.AllowGet);
}
public Int32 AddOrdinaryPacketReceive(UserSearch ordinaryPacketReceive)
{
return(_dal.AddOrdinaryPacketReceive(ordinaryPacketReceive));
}
public static List<UserSearch> getListUserByUserName(string userName, string connString)
{
#region code
List<UserSearch> lists = new List<UserSearch>();
using (SqlConnection conn = new SqlConnection(connString))
{
try
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sony_sp_get_all_user_by_username";
cmd.Parameters.AddWithValue("@username", userName);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
UserSearch user = new UserSearch();
user.Id = (int)reader["id"];
user.FullName = reader["fullname"].ToString();
user.UserName = reader["username"].ToString();
user.Created = (DateTime)reader["registered"];
user.Updated = (DateTime)reader["updated"];
lists.Add(user);
}
}
}
}
catch (Exception ex)
{
WriteLog("", "Get User Error: " + ex.Message, connString);
return new List<UserSearch>();
}
}
return lists;
#endregion
}
public PagedResponse <GetUserDto> Execute(UserSearch request)
{
var query = Context.Users.AsQueryable();
if (request.FirstName != null)
{
query = query.Where(r => r.FirstName.ToLower().Contains(request.FirstName.ToLower()));
}
if (request.LastName != null)
{
query = query.Where(r => r.LastName.ToLower().Contains(request.LastName.ToLower()));
}
if (request.Username != null)
{
query = query.Where(r => r.Username.ToLower().Contains(request.Username.ToLower()));
}
if (request.Active.HasValue)
{
query = query.Where(c => c.IsDeleted != request.Active);
}
else
{
query = query.Where(c => c.IsDeleted == false);
}
if (request.RoleId.HasValue)
{
if (!Context.Roles.Any(r => r.Id == request.RoleId))
{
throw new EntityNotFoundException("Role");
}
query = query.Where(u => u.RoleId == request.RoleId);
}
var totalCount = query.Count();
query = query.Skip((request.PageNumber - 1) * request.PerPage).Take(request.PerPage);
var pagesCount = (int)Math.Ceiling((double)totalCount / request.PerPage);
var response = new PagedResponse <GetUserDto>
{
CurrentPage = request.PageNumber,
TotalCount = totalCount,
PagesCount = pagesCount,
Data = query.Select(u => new GetUserDto
{
Id = u.Id,
FirstName = u.FirstName,
LastName = u.LastName,
Email = u.Email,
Username = u.Username,
Role = u.Role.Name
})
};
return(response);
}
/// <summary>
/// This is a Geotab API console example of sending text messages. It illustrates how to send a basic message, canned response message and location message.
///
/// Steps:
/// 1) Process command line arguments: Server, Database, Username and Password.
/// 2) Create Geotab API object and Authenticate.
/// 3) Send a basic text message.
/// 4) Send a canned response Text Message.
/// 5) Get a Text Message reply.
/// 6) Send an GPS location Text Message.
///
/// A complete Geotab API object and method reference is available at the Geotab SDK page.
/// </summary>
/// <param name="args">The command line arguments for the application. Note: When debugging these can be added by: Right click the project > Properties > Debug Tab > Start Options: Command line arguments.</param>
static async Task Main(string[] args)
{
if (args.Length != 4)
{
Console.WriteLine();
Console.WriteLine("Command line parameters:");
Console.WriteLine("dotnet run <server> <database> <username> <password>");
Console.WriteLine();
Console.WriteLine("Command line: dotnet run server database username password");
Console.WriteLine("server - The server name (Example: my.geotab.com)");
Console.WriteLine("database - The database name (Example: G560)");
Console.WriteLine("username - Geotab user name (Example: [email protected])");
Console.WriteLine("password - Geotab password");
return;
}
// Process command line augments
string server = args[0];
string database = args[1];
string username = args[2];
string password = args[3];
try
{
// Create Geotab API object
API api = new API(username, password, null, database, server);
// Authenticate
Console.WriteLine("Authenticating...");
await api.AuthenticateAsync();
// Get a device to send text messages to.
IList <Device> devices = await api.CallAsync <IList <Device> >("Get", typeof(Device), new { resultsLimit = 1 });
// Make sure we have a device
if (devices == null || devices.Count == 0)
{
throw new InvalidOperationException("Datastore does not contain any devices");
}
Device messageRecipient = devices[0];
Console.WriteLine("Messages will be send to: " + messageRecipient.Name);
// Get the User who the messages will be sent from
UserSearch userSearch = new UserSearch
{
Name = username
};
IList <User> users = await api.CallAsync <List <User> >("Get", typeof(User), new { search = userSearch });
if (users == null || users.Count == 0)
{
throw new InvalidOperationException("Could not find the user you are authenticated in as");
}
User user = users[0];
Console.WriteLine("Messages will be sent from: " + user.Name);
/*
* Basic Message
* A basic text message with a string message.
*/
// Set up the message content
TextContent messageContent = new TextContent("Testing: Geotab API example text message", false);
// Construct the text message
DateTime utcNow = DateTime.UtcNow;
TextMessage basicTextMessage = new TextMessage(null, null, utcNow, utcNow, messageRecipient, user, messageContent, true, true, null, null, null);
// Add the text message. MyGeotab will take care of the actual sending.
basicTextMessage.Id = await api.CallAsync <Id>("Add", typeof(TextMessage), new { entity = basicTextMessage });
/*
* Canned Response Message
* A canned response message is a text message with a list of predetermined responses the receiver can select from.
*/
// Example of sending a text message with canned a response.
// Set up message and response options.
CannedResponseContent cannedResponseContent = new CannedResponseContent
{
Message = "Testing: Geotab API example text message with response options"
};
cannedResponseContent.CannedResponseOptions.Add(new CannedResponseOption("Ok"));
// Construct the text message.
TextMessage textMessageWithResponses = new TextMessage(messageRecipient, null, cannedResponseContent, true);
// Add the text message, Geotab will take care of the sending process.
textMessageWithResponses.Id = await api.CallAsync <Id>("Add", typeof(TextMessage), new { entity = textMessageWithResponses });
Console.WriteLine("Text message sent");
// Keep track of our last "known" sent date. We will send another message but for the purpose of this example we are going to pretend it's from a Device.
DateTime lastKnownSentDate = DateTime.Now;
//-------
// START: MOCK A DEVICE REPLY.
// **FOR EXAMPLE PURPOSES ONLY.**
// THIS LOGIC IS HANDELED BY THE MYGEOTAB SYSTEM. YOU WOULD NOT NORMALLY DO THIS IN A WORKING ENVIRONMENT.
//-------
// Here we are adding a new text message with "isDirectionToVehicle = false", this means the message came from the device.
// Normally, these will be sent by the Garmin device. This is just to show how to search for new responses.
TextMessage textMessageFromDevice = new TextMessage(null, null, utcNow, utcNow, messageRecipient, user, new TextContent(cannedResponseContent.CannedResponseOptions[0].Text, false), false, true, null, null, textMessageWithResponses);
textMessageFromDevice.Id = await api.CallAsync <Id>("Add", typeof(TextMessage), new { entity = textMessageFromDevice });
Console.WriteLine("Response Sent");
//-------
// END: MOCK A DEVICE REPLY
//-------
// Request any messages that have been delivered/sent/read since the date provided.
IList <TextMessage> textMessages = await api.CallAsync <IList <TextMessage> >("Get", typeof(TextMessage), new { search = new TextMessageSearch(ToDate(lastKnownSentDate)) });
Console.WriteLine($"{textMessages.Count} delivered/sent/read");
/*
* Location Message
* A location message is a message with a location. A series of location messages can be sent in succession to comprise a route.
* A clear message can be sent to clear any previous location messages.
*/
// Example of sending a text message with a GPS location
// Set up message and GPS location
LocationContent clearStopsContent = new LocationContent("Testing: Geotab API example clear all stops message", "Reset Stops", 0, 0);
// Construct a "Clear Previous Stops" message
TextMessage clearMessage = new TextMessage(messageRecipient, user, clearStopsContent, true);
// Add the clear stops text message, Geotab will take care of the sending process.
clearMessage.Id = await api.CallAsync <Id>("Add", typeof(TextMessage), new { entity = clearMessage });
Console.WriteLine("Clear Stops Message sent");
// Set up message and GPS location
LocationContent withGPSLocation = new LocationContent("Testing: Geotab API example location message", "Geotab", 43.452879, -79.701648);
// Construct the location text message.
TextMessage locationMessage = new TextMessage(messageRecipient, user, withGPSLocation, true);
// Add the text message, Geotab will take care of the sending process.
locationMessage.Id = await api.CallAsync <Id>("Add", typeof(TextMessage), new { entity = locationMessage });
Console.WriteLine("Address Message sent");
}
catch (Exception ex)
{
// Write any errors to the Console.
Console.WriteLine(ex);
}
}
PagedResponse <UserDto> IQuery <UserSearch, PagedResponse <UserDto> > .Execute(UserSearch search)
{
var query = context.Users.Include(x => x.UserUseCases).Include(u => u.Country).AsQueryable(); //spajam usera sa usecases
if (!string.IsNullOrEmpty(search.FirstName) || !string.IsNullOrWhiteSpace(search.FirstName))
{
query = query.Where(x => x.FirstName.ToLower().Contains(search.FirstName.ToLower()));
}
if (!string.IsNullOrEmpty(search.LastName) || !string.IsNullOrWhiteSpace(search.LastName))
{
query = query.Where(x => x.LastName.ToLower().Contains(search.LastName.ToLower()));
}
if (!string.IsNullOrEmpty(search.Email) || !string.IsNullOrWhiteSpace(search.Email))
{
query = query.Where(x => x.Email.ToLower().Contains(search.Email.ToLower()));
}
return(query.Paged <UserDto, User>(search, mapper));
}
public IActionResult Get([FromQuery] UserSearch search, [FromServices] IGetUsersQuery query)
{
return(Ok(_executor.ExecuteQuery(query, search)));
}
public ActionResult SearchResults(UserSearch userSearch)
{
var searchResult = this.gitHubApi.GetUserDetails(userSearch.Username);
return(View(searchResult));
}
public ActionResult SearchUsername(UserSearch userSearch)
{
return(RedirectToAction("SearchResults", userSearch));
}
public HttpResponseMessage Export(GlobalSolusindoDb Db, string fileName, UserSearchFilter filter)
{
_fileName = fileName;
_workbook = new XSSFWorkbook(); //Creating New Excel object
using (var userSearch = new UserSearch(Db))
{
var data = userSearch.GetDataByFilter(filter);
var dataExport = data.Records.Select(c => new UserExportDTO
{
JoinDate = c.JoinDate,
UserName = c.Username,
KategoriJabatanTitle = c.KategoriJabatanTitle,
Name = c.Name,
TglLahir = c.TglLahir,
NoKTP = c.NoKTP,
ReligionName = c.Religion, //?
CategoryContract = c.CategoryContract, //?
Project = c.Project, //?
Gender = c.Gender, //?
MartialStatus = c.MaritalStatus, //?
NPWP = c.NPWP, //?
BPJS = c.BPJS, //?
ContactNumber = c.NoHP,
G1EmailID = c.Email,
PersonalEmail = c.PersonalEmail,
Address = c.Address,
NamaBank = c.BankName, //?
NoRekening = c.AccountNumber, //?
Salary = c.Salary, //?
Remark = c.Description, //?
Status = null //?
}).ToList();
WriteSheetData(dataExport, "UserUpload");
}
using (var jabatanQry = new KategoriJabatanQuery())
{
var data = jabatanQry.GetQuery().Select(c => new LOVDTO {
Id = c.KategoriJabatan_PK, Name = c.Title
}).ToList();
WriteSheetData(data, "Position");
}
//_workbook.Close();
using (var memoryStream = new MemoryStream()) //creating memoryStream
{
_workbook.Write(memoryStream);
var response = new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new ByteArrayContent(memoryStream.ToArray())
};
response.Content.Headers.ContentType = new MediaTypeHeaderValue
("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.Content.Headers.ContentDisposition =
new ContentDispositionHeaderValue("attachment")
{
FileName = $"{_fileName}_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx"
};
return(response);
}
}
