public override Task <Value_Reply> GetSettingValueByName(Name_Request request, ServerCallContext context)
{
Value_Reply value_Reply = new Value_Reply();
MySqlConnection connection = CreateDBConnection();
var cmd = connection.CreateCommand();
cmd.CommandText = $"SELECT `value` FROM trackerdb.setting WHERE `name` = '{request.Name}';";
var reader = cmd.ExecuteReader();
reader.Read();
value_Reply.Value = Convert.ToString(reader["value"]);
cmd.Dispose();
connection.Close();
connection.Dispose();
return(Task.FromResult(value_Reply));
}
public override Task <Project_Reply> AddProject(Name_Request request, ServerCallContext context)
{
Project_Reply project_Reply = new Project_Reply();
MySqlConnection connection = CreateDBConnection();
var cmd = connection.CreateCommand();
cmd.CommandText = $"INSERT INTO trackerdb.project (`name`, `active`) VALUES ('{request.Name}','Y');";
cmd.ExecuteNonQuery();
cmd.CommandText = $"SELECT `projectId`, `name`, `active` FROM trackerdb.project WHERE `name` = '{request.Name}' LIMIT 1;";
var reader = cmd.ExecuteReader();
reader.Read();
project_Reply.ProjectId = Convert.ToInt32(reader["projectId"]);
project_Reply.Name = Convert.ToString(reader["name"]);
project_Reply.Active = Convert.ToString(reader["active"]);
cmd.Dispose();
connection.Close();
connection.Dispose();
return(Task.FromResult(project_Reply));
}
