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)); }