public override Task <NameResponse> Hello(NameRequest request, ServerCallContext context)
{
return(Task.FromResult(new NameResponse()
{
Name = $"Hello {request.Name}"
}));
}
public List <OrderResponce> GetOrders(NameRequest request)
{
var result = new List <OrderResponce>();
if (request.Name == null)
{
var OrderList = _context.Orders.Select(o => new Order
{
IdOrder = o.IdOrder,
DateAccepted = o.DateAccepted,
DateFinished = o.DateFinished,
Notes = o.Notes,
IdClient = o.IdClient
}).ToList();
for (var i = 0; i < OrderList.Count; i++)
{
result.Add(new OrderResponce
{
IdOrder = OrderList[i].IdOrder,
DateAccepted = OrderList[i].DateAccepted,
DateFinished = OrderList[i].DateFinished,
Notes = OrderList[i].Notes,
IdClient = OrderList[i].IdClient
});
}
return(result);
}
int IdClient = _context.Customers
.Where(c => c.Name == request.Name)
.Select(c => c.IdClient).SingleOrDefault();
if (IdClient == 0)
{
return(null);
}
var list = _context.Orders
.Where(o => o.IdClient == IdClient)
.Select(o => new Order
{
IdOrder = o.IdOrder,
DateAccepted = o.DateAccepted,
DateFinished = o.DateFinished,
Notes = o.Notes,
IdClient = o.IdClient
}).ToList();
for (var i = 0; i < list.Count; i++)
{
result.Add(new OrderResponce
{
IdOrder = list[i].IdOrder,
DateAccepted = list[i].DateAccepted,
DateFinished = list[i].DateFinished,
Notes = list[i].Notes,
IdClient = list[i].IdClient
});
}
return(result);
}
public override Task <TaskListResponse> GetAllDepTasks(NameRequest request, ServerCallContext context) //TODO this throws error when invoked
{
//get all department teams
TeamListResp teams = new TeamListResp();
DBConnection.Open();
String command = "SELECT TeamID, TeamName FROM Team WHERE DepartmentName =" + request.TeamName;
SqlCommand newCommand = new SqlCommand(command, DBConnection);
SqlDataReader dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
teams.TeamDesc.Add(new TeamDescription {
Index = dataReader.GetInt32(0), Name = dataReader.GetString(1)
});
}
//get all tasks for these teams
TaskListResponse taskList = new TaskListResponse();
foreach (var team in teams.TeamDesc)
{
command = "SELECT * FROM ScheduleItem WHERE Team =" + team.Name;
newCommand = new SqlCommand(command, DBConnection);
dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
taskList.Tasks.Add(new MessagesPack.Task {
Status = dataReader.GetString(3), Team = dataReader.GetString(1), TeamID = dataReader.GetInt32(0), Text = dataReader.GetString(4)
});
}
}
dataReader.Close();
DBConnection.Close();
return(System.Threading.Tasks.Task.FromResult(taskList));
}
public void CreateTeamAreaPath(Guid teamProjectId, string clientName)
{
var request = new NameRequest {
name = clientName
};
Post($"/{teamProjectId}/_apis/wit/classificationNodes/areas?api-version=5.1", request);
}
public void RenameTeamAreaPath(Guid teamProjectId, string oldClientName, string newClientName)
{
var request = new NameRequest {
name = newClientName
};
Patch($"/{teamProjectId}/_apis/wit/classificationNodes/areas/{oldClientName}?api-version=5.1", request);
}
public IActionResult IsCollectionExist(NameRequest request)
{
if (collectionService.IsExist(request.Name))
{
return(Ok());
}
return(NotFound());
}
public override Task <IntegerResponse> GetTeamID(NameRequest request, ServerCallContext context)
{
var tmp = new IntegerResponse
{
Number = GetTeamIdFromName(request.TeamName)
};
return(System.Threading.Tasks.Task.FromResult(tmp));
}
public override Task <IntegerResponse> GetTeamID(NameRequest request, ServerCallContext context)
{
IntegerResponse tmp = new IntegerResponse();
DBConnection.Open();
tmp.Number = GetTeamIdFromName(request.TeamName);
DBConnection.Close();
return(System.Threading.Tasks.Task.FromResult(tmp));
}
public dynamic GetNames(NameRequest request)
{
HttpClient _client = new HttpClient();
_client.BaseAddress = new Uri(request.Uri);
var result = _client.GetStringAsync("").Result;
return(JsonConvert.DeserializeObject <dynamic>(result));
}
public override Task <NameReply> CheckNameRequest(NameRequest request, ServerCallContext context)
{
var resp = GetName();
return(Task.FromResult(new NameReply
{
Message = resp
}));
}
public EmployeeRequest(NameRequest name, DocumentRequest document, EmailRequest email,
AddressRequest address, EmployeePositionRequest employeePosition)
{
Name = name;
Document = document;
Email = email;
Address = address;
EmployeePosition = employeePosition;
}
public void GetNames()
{
var request = new NameRequest();
var feed = new JsonFeed();//("https://api.chucknorris.io");//, 1);
request.Uri = "https://www.names.privserv.com/api/";
var res = feed.GetNames(request);
Assert.IsNotNull(res);
}
public IActionResult GetOrders(NameRequest request)
{
var orders = _service.GetOrders(request);
if (orders == null)
{
return(BadRequest("404 Bad Request!"));
}
return(Ok(orders));
}
public ActionResult UpdateName(NameRequest request)
{
var update = new EmployeeUpdatePatch()
{
Name = request.Name,
EmpId = request.EmpId
};
employeeService.UpdatePatch(update);
return(Ok());
}
public override Task <NameReply> CheckJokeNameRequest(NameRequest request, ServerCallContext context)
{
request.Uri = _urlName;
var response = _feed.GetNames(request);
// _names = Tuple.Create(response.name.ToString(), response.surname.ToString());
return(Task.FromResult(new NameReply
{
FirstName = response.name.ToString(),
LastName = response.surname.ToString()
}));
}
public IActionResult DeleteTrainingHours([FromBody] NameRequest data)
{
var decodedToken = authentication.DecodeTokenFromRequest(Request.Headers["Authorization"]);
string role = authentication.GetRoleFromToken(decodedToken);
int id = authentication.GetIDFromToken(decodedToken);
if (role == "Club")
{
if (_clubLogic.DeleteTrainingHours(data.Name, id))
{
return(Ok());
}
}
return(StatusCode(500, "Failed"));
}
public override Task <TeamListResp> GetDepartmetTeams(NameRequest request, ServerCallContext context)
{
TeamListResp tmp = new TeamListResp();
DBConnection.Open();
String command = "SELECT * FROM Team WHERE DepartmentName=" + request.TeamName;
SqlCommand newCommand = new SqlCommand(command, DBConnection);
SqlDataReader dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
tmp.TeamDesc.Add(new TeamDescription {
Index = dataReader.GetInt32(0), Name = dataReader.GetString(1)
});
}
dataReader.Close();
DBConnection.Close();
return(System.Threading.Tasks.Task.FromResult(tmp));
}
public override Task <TeamListResp> GetDepartmentWorkers(NameRequest request, ServerCallContext context)
{
var tmp = new TeamListResp();
_dbConnection.Open();
var command = "SELECT * FROM Worker WHERE DepartmentName = '" + request.TeamName + "'";
var newCommand = new SqlCommand(command, _dbConnection);
var dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
tmp.TeamDesc.Add(new TeamDescription {
Index = dataReader.GetInt32(0), Name = dataReader.GetString(2)
});
}
dataReader.Close();
_dbConnection.Close();
return(System.Threading.Tasks.Task.FromResult(tmp));
}
GetAllDepTasks(NameRequest request, ServerCallContext context)
{
var teams = new TeamListResp();
_dbConnection.Open();
var command = "SELECT TeamID, TeamName FROM Team WHERE DepartmentName = '" + request.TeamName + "'";
var newCommand = new SqlCommand(command, _dbConnection);
var dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
teams.TeamDesc.Add(new TeamDescription
{
Index = dataReader.GetInt32(0), Name = dataReader.GetString(1)
});
}
dataReader.Close();
_dbConnection.Close();
//get all tasks for these teams
var taskList = new TaskListResponse();
foreach (var team in teams.TeamDesc)
{
command = "SELECT * FROM ScheduleItem WHERE Team = '" + team.Name + "'";
newCommand = new SqlCommand(command, _dbConnection);
dataReader = newCommand.ExecuteReader();
while (dataReader.Read())
{
taskList.Tasks.Add(new MessagesPack.Task
{
Status = dataReader.GetString(3), Team = dataReader.GetString(1),
TeamID = dataReader.GetInt32(0), Text = dataReader.GetString(4)
});
}
}
dataReader.Close();
_dbConnection.Close();
return(System.Threading.Tasks.Task.FromResult(taskList));
}
private void AddNew(string newName, string dialogHeader = "Введите имя набора")
{
List <string> names;
lock (_dictSyncLock)
{
names = _dict.Select(s => s.SetName).ToList();
}
var nr = new NameRequest(names, newName, _modalType, _modalParent);
nr.OnOK += OnOkPressed;
if (_modalType == EnumNameRequestModalType.SimpleModal && _modalParent != null)
{
_modalParent.ShowModal(nr, "Введите имя набора");
}
else
{
Manager.UI.ShowGlobalModal(nr, dialogHeader);
}
}
private void AddSelectToDB_Click(object sender, EventArgs e)
{
if (flag)
{
using (SqlConnection con = new SqlConnection(connectionString)) {
using (SqlCommand com = new SqlCommand("Update Requests set NameRequest = @name, Request = @req, Departments = @dep Where NameRequest = @name1", con)) {
con.Open();
com.Parameters.AddWithValue("@name", NameRequest.Text);
com.Parameters.AddWithValue("@req", Request.Text);
com.Parameters.AddWithValue("@name1", ListWithRequests.SelectedItem.ToString());
com.Parameters.AddWithValue("@dep", DepList.SelectedItem.ToString());
com.ExecuteNonQuery();
}
}
ListWithRequests.Items.Clear();
UpdateList();
}
else
{
using (SqlConnection con = new SqlConnection(connectionString)) {
using (SqlCommand com = new SqlCommand("Insert Into Requests(NameRequest, Request, Departments) Values(@name, @req, @dep)", con)) {
con.Open();
com.Parameters.AddWithValue("@name", NameRequest.Text);
com.Parameters.AddWithValue("@req", Request.Text);
com.Parameters.AddWithValue("@dep", DepList.SelectedItem.ToString());
com.ExecuteNonQuery();
}
}
ListWithRequests.Items.Add(NameRequest.Text);
}
NameRequest.Clear();
Request.Clear();
this.AutoSize = false;
this.Size = new Size(520, 300);
flag = false;
AddSelectToDB.Text = "Добавить";
PanelWithElementForAddRequest.Visible = false;
}
public IAsyncResult BeginChangeName(NameRequest request, string acctname, string name, AsyncCallback callback, object asyncState)
{
CharacterResponse response = null;
Account account = Account.Login(acctname, request.Login.Password);
if (account != null)
{
response = Character.Load(acctname, name);
if (response.Success && !response.Character.Deleted)
{
string message = response.Character.SetName(account, request.NewName);
if (message != string.Empty)
{
response = new CharacterResponse(message, response.Character);
}
}
}
else
{
response = new CharacterResponse("Error: Bad username or password.", null);
}
return(new CompletedAsyncResult <CharacterResponse>(response));
}
public IActionResult PostBasic(NameRequest request)
{
_sessionService.Set(c_NAMESESSIONKEY, request.Name);
return(RedirectToAction(nameof(Index)));
}
static async Task Main(string[] args)
{
while (true)
{
printer.Value("Press ? to get instructions.").ToString();
GetEnteredKey(Console.ReadKey());
//if (Console.ReadLine() == "?")
if (key == '?')
{
while (true)
{
// The port number(5001) must match the port of the gRPC server.
var channel = GrpcChannel.ForAddress("https://localhost:5001");
var client = new JokeCheck.JokeCheckClient(channel);
printer.Value("Press r to get random jokes").ToString();
GetEnteredKey(Console.ReadKey());
if (key == 'r')
{
var jokeRequest = new JokeRequest();
printer.Value("Want to specify a category? y/n").ToString();
GetEnteredKey(Console.ReadKey());
if (key == 'y')
{
printer.Value("Please select the category by typing the 1-9 or a-z inside[] following each category.").ToString();
printer.Value("'animal[1]','career[2],'celebrity[3]','dev[4]','explicit[5]','fashion[6]','food[7]','history[8]','money[9]','movie[a]','music[b]','political[c]','religion[d]','science[e]','sport[f]','travel[g]'").ToString();
jokeRequest.Category = MapCategoryKey(Console.ReadKey());
}
printer.Value("Want to use a random name? y/n").ToString();
GetEnteredKey(Console.ReadKey());
if (key == 'y')
{
var nameRequest = new NameRequest();
var nameReply = await client.CheckJokeNameRequestAsync(nameRequest);
jokeRequest.FirstName = nameReply.FirstName;
jokeRequest.LastName = nameReply.LastName;
Console.WriteLine($"Random name is {jokeRequest.FirstName} {jokeRequest.LastName} :-)");
}
printer.Value("How many jokes do you want? (1-9)").ToString();
//GetEnteredKey(Console.ReadLine());
int n = Int32.Parse(Console.ReadLine());
jokeRequest.Number = n;
var reply = new JokeReply();
var success = true;
try
{
reply = await client.CheckJokeRequestAsync(jokeRequest);
}
catch (Exception ex)
{
//To do: logger ex
reply.Message = "Joke service is not available at this moment. Please come back later.";
success = false;
}
Console.WriteLine($"Hello {jokeRequest.FirstName} {jokeRequest.LastName}!");
if (success)
{
Console.WriteLine($"Enjoy the joke for {jokeRequest.Category.ToUpper()} category: {reply.Message}");
}
else
{
Console.WriteLine($"Sorry, {reply.Message}");
}
}
Console.WriteLine("Press any key to continue new joke... Press ctrl+c to exit...");
Console.ReadKey();
}
}
}
}
public IActionResult PostBasic(NameRequest request)
{
_cookieService.Set(c_NAMECOOKIENAME, request.Name);
return(RedirectToAction(nameof(Index)));
}
